itimoshenko/rewards-program

rewards-program service

Description

Service for rewards program to customers awarding points based on each recorded purchase.

Getting Started

• Install Node.js
• Install Docker

# step 1: create and start containers
$ npm run docker:compose

# step 2: install development dependencies
npm install --only=development

# step 3: run migrations
$ npm run typeorm -- migration:run -d ./src/data-source.ts

# step 4: seed initial data for database
$ npm run seed

• service will be available on port 3000, Swagger will be available on /api route
• pgadmin will be available on port 5050

Docker

# create containers
$ npm run docker:compose -- --no-start

# create and start containers
$ npm run docker:compose

Installation for development on a local machine

# install dependencies
$ npm install

Running the app for development on a local machine

# development
$ npm run start

# watch mode
$ npm run start:dev

# production mode
$ npm run start:prod

Seeding initial data

# seed initial data for database
$ npm run seed

# generate and seed initial data for database
$ npm run randomSeed

Migrations

# run migration
$ npm run typeorm -- migration:run -d ./src/data-source.ts

# revert migration
$ npm run typeorm -- migration:revert -d ./src/data-source.ts

# generate migration on entities changes
$ npm run typeorm -- migration:generate ./src/migrations/MIGRATION_NAME -d ./src/data-source.ts

# create migration
$ npm run typeorm -- migration:create ./src/migrations/MIGRATION_NAME

Test

# unit tests
$ npm run test

# test coverage
$ npm run test:cov

Results and dataset

Results

customerId	lastMonth	lastThreeMonths
1	21980	402020
2	0	35850
3	0	29405
4	0	6410
5	77115	237595

Customer

"id"
1
2
3
4
5

Payments

"id"	"amount"	"date"	"customerId"
1	2225.98	"2022-08-09 09:03:10.837"	1
2	672.86	"2022-06-19 22:23:13.705"	1
3	642.48	"2022-04-15 18:01:00.188"	1
4	577.42	"2022-06-29 17:14:12.873"	1
5	1458.45	"2022-05-15 19:08:11.797"	1
6	1015.5	"2022-07-10 22:29:17.74"	1
7	2390.05	"2022-07-28 10:43:50.011"	1
8	1405.8	"2022-07-13 11:50:31.33"	1
9	2249.55	"2022-06-14 08:32:11.799"	1
10	1576.23	"2022-06-13 03:49:06.923"	1
11	1161.93	"2022-07-24 17:20:21.912"	1
12	644.15	"2022-06-15 10:35:20.651"	1
13	1547.26	"2022-05-22 17:02:33.206"	1
14	1162.14	"2022-07-15 22:59:01.953"	1
15	357.44	"2022-06-29 21:17:29.163"	1
16	248.35	"2022-06-15 05:12:09.703"	1
17	1130.58	"2022-07-27 20:07:05.601"	1
18	1768.55	"2022-06-15 15:48:40.191"	1
19	1186.6	"2022-05-20 21:12:37.877"	1
20	1648.19	"2022-06-17 05:00:09.508"	1
21	1157.64	"2022-04-19 04:11:16.225"	1
22	1049.38	"2022-05-06 12:41:32.701"	1
23	1177.72	"2022-07-20 23:08:24.396"	1
24	1859.74	"2022-06-07 06:34:04.703"	1
25	862.48	"2022-04-16 00:36:59.582"	1
26	151.62	"2022-07-26 04:58:54.045"	1
27	159.57	"2022-06-04 10:10:45.865"	1
28	947.65	"2022-05-12 07:57:17.014"	1
29	2002.13	"2022-05-30 16:09:28.063"	1
30	592.11	"2022-04-11 23:21:08.571"	1
31	2465.2	"2022-07-20 09:40:56.011"	1
32	2496.25	"2022-04-25 03:20:40.278"	1
33	817.24	"2022-06-20 14:31:40.3"	1
34	709.9	"2022-04-15 17:24:34.928"	1
35	1659.91	"2022-06-29 18:36:23.259"	1
36	994.35	"2022-05-14 00:38:36.106"	1
37	2345.31	"2022-05-02 04:49:38.762"	1
38	1432.21	"2022-06-27 12:47:56.428"	1
39	1585.49	"2022-04-12 00:02:51.192"	1
40	1060.48	"2022-07-17 21:54:15.057"	1
41	919.82	"2022-05-28 19:21:42.339"	1
42	888.5	"2022-06-26 02:11:35.171"	1
43	1106.8	"2022-06-12 19:59:19.723"	1
44	162.21	"2022-04-16 04:11:28.872"	1
45	853.34	"2022-05-02 06:20:30.772"	1
46	242.27	"2022-07-20 23:45:04.03"	1
47	2154.61	"2022-05-16 17:28:16.463"	1
48	123.97	"2022-08-08 02:21:30.77"	1
49	2110.41	"2022-04-26 01:53:22.319"	1
50	248.9	"2022-05-03 16:39:50.415"	1
51	13.11	"2022-04-15 12:17:06.872"	1
52	2240.58	"2022-07-12 05:42:52.932"	1
53	2267.76	"2022-06-04 17:57:22.162"	1
54	1982.16	"2022-06-22 09:22:09.334"	1
55	2144.03	"2022-07-28 13:01:47.305"	1
56	754.39	"2022-06-12 15:58:02.786"	1
57	1251.51	"2022-07-30 16:31:52.492"	2
58	1998.38	"2022-07-31 21:49:17.755"	2
59	2463.06	"2022-05-04 04:41:50.575"	2
60	554.03	"2022-04-17 10:05:33.589"	2
61	30.24	"2022-05-20 07:29:31.558"	2
62	1283.61	"2022-04-29 21:15:47.775"	2
63	561.02	"2022-07-09 07:48:31.601"	2
64	291.71	"2022-05-31 08:56:25.977"	3
65	2032.9	"2022-04-15 19:35:10.178"	3
66	354.75	"2022-04-17 12:00:16.343"	3
67	838.05	"2022-07-02 01:37:07.355"	3
68	1302.51	"2022-06-18 23:19:54.315"	3
69	55.03	"2022-07-24 22:44:08.998"	3
70	1895.33	"2022-05-06 14:46:30.739"	3
71	2105.3	"2022-04-22 15:29:12.352"	3
72	1023.86	"2022-07-17 19:50:09.341"	3
73	338.94	"2022-06-20 21:31:12.94"	4
74	1437.46	"2022-04-28 20:11:33.587"	4
75	298.7	"2022-07-02 19:43:51.048"	4
76	230.75	"2022-06-12 00:00:51.481"	4
77	635.66	"2022-06-14 12:25:29.078"	5
78	372.8	"2022-07-25 20:57:12.694"	5
79	578.9	"2022-06-15 07:51:24.421"	5
80	1534.53	"2022-04-14 00:25:07.064"	5
81	796.76	"2022-08-10 02:57:26.321"	5
82	421.33	"2022-05-26 00:34:35.033"	5
83	1661.67	"2022-05-21 14:36:19.602"	5
84	437.32	"2022-06-01 20:53:44.621"	5
85	2084.31	"2022-07-25 05:53:17.934"	5
86	627.49	"2022-07-08 02:58:24.872"	5
87	73.32	"2022-05-23 11:28:03.301"	5
88	2303.36	"2022-07-25 13:34:45.552"	5
89	2441.84	"2022-08-02 12:13:16.384"	5
90	886.13	"2022-07-09 18:27:28.625"	5
91	1138.39	"2022-05-14 09:46:05.974"	5
92	1106.58	"2022-08-03 09:21:37.498"	5
93	1612.68	"2022-08-04 00:17:12.348"	5
94	946.76	"2022-05-21 08:10:46.678"	5
95	2039.18	"2022-05-01 21:57:44.491"	5
96	269.6	"2022-04-13 06:27:58.999"	5
97	2130.49	"2022-06-14 11:29:25.085"	5
98	706.54	"2022-05-29 13:47:41.937"	5
99	1436.04	"2022-04-25 21:41:30.73"	5
100	79.03	"2022-08-03 08:56:41.716"	5
101	1085.35	"2022-05-16 00:27:07.9"	5
102	2157.49	"2022-06-12 13:21:20.213"	5
103	1704.64	"2022-04-26 06:40:28.718"	5
104	631.76	"2022-04-27 18:26:45.109"	5
105	1343.38	"2022-05-10 16:28:01.7"	5
106	1908.4	"2022-04-12 09:22:35.354"	5
107	411.46	"2022-04-19 07:56:44.34"	5
108	941.39	"2022-07-30 16:07:51.956"	5
109	9.4	"2022-07-06 02:02:54.164"	5
110	532.97	"2022-04-14 15:00:51.283"	5
111	186.78	"2022-05-07 13:46:29.012"	5
112	739.84	"2022-06-21 21:29:02.809"	5
113	317.85	"2022-06-19 18:28:15.09"	5
114	2251.5	"2022-04-15 18:53:34.299"	5
115	779.11	"2022-06-04 23:12:36.698"	5
116	849.87	"2022-05-15 01:26:21.854"	5
117	2188.16	"2022-06-20 21:11:56.489"	5
118	2117.72	"2022-08-11 14:41:55.215"	5
119	448.76	"2022-05-25 13:40:58.555"	5
120	2225.98	"2022-08-09 09:03:10.837"	1
121	672.86	"2022-06-19 22:23:13.705"	1
122	642.48	"2022-04-15 18:01:00.188"	1
123	577.42	"2022-06-29 17:14:12.873"	1
124	1458.45	"2022-05-15 19:08:11.797"	1
125	1015.5	"2022-07-10 22:29:17.74"	1
126	2390.05	"2022-07-28 10:43:50.011"	1
127	1405.8	"2022-07-13 11:50:31.33"	1
128	2249.55	"2022-06-14 08:32:11.799"	1
129	1576.23	"2022-06-13 03:49:06.923"	1
130	1161.93	"2022-07-24 17:20:21.912"	1
131	644.15	"2022-06-15 10:35:20.651"	1
132	1547.26	"2022-05-22 17:02:33.206"	1
133	1162.14	"2022-07-15 22:59:01.953"	1
134	357.44	"2022-06-29 21:17:29.163"	1
135	248.35	"2022-06-15 05:12:09.703"	1
136	1130.58	"2022-07-27 20:07:05.601"	1
137	1768.55	"2022-06-15 15:48:40.191"	1
138	1186.6	"2022-05-20 21:12:37.877"	1
139	1648.19	"2022-06-17 05:00:09.508"	1
140	1157.64	"2022-04-19 04:11:16.225"	1
141	1049.38	"2022-05-06 12:41:32.701"	1
142	1177.72	"2022-07-20 23:08:24.396"	1
143	1859.74	"2022-06-07 06:34:04.703"	1
144	862.48	"2022-04-16 00:36:59.582"	1
145	151.62	"2022-07-26 04:58:54.045"	1
146	159.57	"2022-06-04 10:10:45.865"	1
147	947.65	"2022-05-12 07:57:17.014"	1
148	2002.13	"2022-05-30 16:09:28.063"	1
149	592.11	"2022-04-11 23:21:08.571"	1
150	2465.2	"2022-07-20 09:40:56.011"	1
151	2496.25	"2022-04-25 03:20:40.278"	1
152	817.24	"2022-06-20 14:31:40.3"	1
153	709.9	"2022-04-15 17:24:34.928"	1
154	1659.91	"2022-06-29 18:36:23.259"	1
155	994.35	"2022-05-14 00:38:36.106"	1
156	2345.31	"2022-05-02 04:49:38.762"	1
157	1432.21	"2022-06-27 12:47:56.428"	1
158	1585.49	"2022-04-12 00:02:51.192"	1
159	1060.48	"2022-07-17 21:54:15.057"	1
160	919.82	"2022-05-28 19:21:42.339"	1
161	888.5	"2022-06-26 02:11:35.171"	1
162	1106.8	"2022-06-12 19:59:19.723"	1
163	162.21	"2022-04-16 04:11:28.872"	1
164	853.34	"2022-05-02 06:20:30.772"	1
165	242.27	"2022-07-20 23:45:04.03"	1
166	2154.61	"2022-05-16 17:28:16.463"	1
167	123.97	"2022-08-08 02:21:30.77"	1
168	2110.41	"2022-04-26 01:53:22.319"	1
169	248.9	"2022-05-03 16:39:50.415"	1
170	13.11	"2022-04-15 12:17:06.872"	1
171	2240.58	"2022-07-12 05:42:52.932"	1
172	2267.76	"2022-06-04 17:57:22.162"	1
173	1982.16	"2022-06-22 09:22:09.334"	1
174	2144.03	"2022-07-28 13:01:47.305"	1
175	754.39	"2022-06-12 15:58:02.786"	1
176	1251.51	"2022-07-30 16:31:52.492"	2
177	1998.38	"2022-07-31 21:49:17.755"	2
178	2463.06	"2022-05-04 04:41:50.575"	2
179	554.03	"2022-04-17 10:05:33.589"	2
180	30.24	"2022-05-20 07:29:31.558"	2
181	1283.61	"2022-04-29 21:15:47.775"	2
182	561.02	"2022-07-09 07:48:31.601"	2
183	291.71	"2022-05-31 08:56:25.977"	3
184	2032.9	"2022-04-15 19:35:10.178"	3
185	354.75	"2022-04-17 12:00:16.343"	3
186	838.05	"2022-07-02 01:37:07.355"	3
187	1302.51	"2022-06-18 23:19:54.315"	3
188	55.03	"2022-07-24 22:44:08.998"	3
189	1895.33	"2022-05-06 14:46:30.739"	3
190	2105.3	"2022-04-22 15:29:12.352"	3
191	1023.86	"2022-07-17 19:50:09.341"	3
192	338.94	"2022-06-20 21:31:12.94"	4
193	1437.46	"2022-04-28 20:11:33.587"	4
194	298.7	"2022-07-02 19:43:51.048"	4
195	230.75	"2022-06-12 00:00:51.481"	4
196	635.66	"2022-06-14 12:25:29.078"	5
197	372.8	"2022-07-25 20:57:12.694"	5
198	578.9	"2022-06-15 07:51:24.421"	5
199	1534.53	"2022-04-14 00:25:07.064"	5
200	796.76	"2022-08-10 02:57:26.321"	5
201	421.33	"2022-05-26 00:34:35.033"	5
202	1661.67	"2022-05-21 14:36:19.602"	5
203	437.32	"2022-06-01 20:53:44.621"	5
204	2084.31	"2022-07-25 05:53:17.934"	5
205	627.49	"2022-07-08 02:58:24.872"	5
206	73.32	"2022-05-23 11:28:03.301"	5
207	2303.36	"2022-07-25 13:34:45.552"	5
208	2441.84	"2022-08-02 12:13:16.384"	5
209	886.13	"2022-07-09 18:27:28.625"	5
210	1138.39	"2022-05-14 09:46:05.974"	5
211	1106.58	"2022-08-03 09:21:37.498"	5
212	1612.68	"2022-08-04 00:17:12.348"	5
213	946.76	"2022-05-21 08:10:46.678"	5
214	2039.18	"2022-05-01 21:57:44.491"	5
215	269.6	"2022-04-13 06:27:58.999"	5
216	2130.49	"2022-06-14 11:29:25.085"	5
217	706.54	"2022-05-29 13:47:41.937"	5
218	1436.04	"2022-04-25 21:41:30.73"	5
219	79.03	"2022-08-03 08:56:41.716"	5
220	1085.35	"2022-05-16 00:27:07.9"	5
221	2157.49	"2022-06-12 13:21:20.213"	5
222	1704.64	"2022-04-26 06:40:28.718"	5
223	631.76	"2022-04-27 18:26:45.109"	5
224	1343.38	"2022-05-10 16:28:01.7"	5
225	1908.4	"2022-04-12 09:22:35.354"	5
226	411.46	"2022-04-19 07:56:44.34"	5
227	941.39	"2022-07-30 16:07:51.956"	5
228	9.4	"2022-07-06 02:02:54.164"	5
229	532.97	"2022-04-14 15:00:51.283"	5
230	186.78	"2022-05-07 13:46:29.012"	5
231	739.84	"2022-06-21 21:29:02.809"	5
232	317.85	"2022-06-19 18:28:15.09"	5
233	2251.5	"2022-04-15 18:53:34.299"	5
234	779.11	"2022-06-04 23:12:36.698"	5
235	849.87	"2022-05-15 01:26:21.854"	5
236	2188.16	"2022-06-20 21:11:56.489"	5
237	2117.72	"2022-08-11 14:41:55.215"	5
238	448.76	"2022-05-25 13:40:58.555"	5
239	2225.98	"2022-08-09 09:03:10.837"	1
240	672.86	"2022-06-19 22:23:13.705"	1
241	642.48	"2022-04-15 18:01:00.188"	1
242	577.42	"2022-06-29 17:14:12.873"	1
243	1458.45	"2022-05-15 19:08:11.797"	1
244	1015.5	"2022-07-10 22:29:17.74"	1
245	2390.05	"2022-07-28 10:43:50.011"	1
246	1405.8	"2022-07-13 11:50:31.33"	1
247	2249.55	"2022-06-14 08:32:11.799"	1
248	1576.23	"2022-06-13 03:49:06.923"	1
249	1161.93	"2022-07-24 17:20:21.912"	1
250	644.15	"2022-06-15 10:35:20.651"	1
251	1547.26	"2022-05-22 17:02:33.206"	1
252	1162.14	"2022-07-15 22:59:01.953"	1
253	357.44	"2022-06-29 21:17:29.163"	1
254	248.35	"2022-06-15 05:12:09.703"	1
255	1130.58	"2022-07-27 20:07:05.601"	1
256	1768.55	"2022-06-15 15:48:40.191"	1
257	1186.6	"2022-05-20 21:12:37.877"	1
258	1648.19	"2022-06-17 05:00:09.508"	1
259	1157.64	"2022-04-19 04:11:16.225"	1
260	1049.38	"2022-05-06 12:41:32.701"	1
261	1177.72	"2022-07-20 23:08:24.396"	1
262	1859.74	"2022-06-07 06:34:04.703"	1
263	862.48	"2022-04-16 00:36:59.582"	1
264	151.62	"2022-07-26 04:58:54.045"	1
265	159.57	"2022-06-04 10:10:45.865"	1
266	947.65	"2022-05-12 07:57:17.014"	1
267	2002.13	"2022-05-30 16:09:28.063"	1
268	592.11	"2022-04-11 23:21:08.571"	1
269	2465.2	"2022-07-20 09:40:56.011"	1
270	2496.25	"2022-04-25 03:20:40.278"	1
271	817.24	"2022-06-20 14:31:40.3"	1
272	709.9	"2022-04-15 17:24:34.928"	1
273	1659.91	"2022-06-29 18:36:23.259"	1
274	994.35	"2022-05-14 00:38:36.106"	1
275	2345.31	"2022-05-02 04:49:38.762"	1
276	1432.21	"2022-06-27 12:47:56.428"	1
277	1585.49	"2022-04-12 00:02:51.192"	1
278	1060.48	"2022-07-17 21:54:15.057"	1
279	919.82	"2022-05-28 19:21:42.339"	1
280	888.5	"2022-06-26 02:11:35.171"	1
281	1106.8	"2022-06-12 19:59:19.723"	1
282	162.21	"2022-04-16 04:11:28.872"	1
283	853.34	"2022-05-02 06:20:30.772"	1
284	242.27	"2022-07-20 23:45:04.03"	1
285	2154.61	"2022-05-16 17:28:16.463"	1
286	123.97	"2022-08-08 02:21:30.77"	1
287	2110.41	"2022-04-26 01:53:22.319"	1
288	248.9	"2022-05-03 16:39:50.415"	1
289	13.11	"2022-04-15 12:17:06.872"	1
290	2240.58	"2022-07-12 05:42:52.932"	1
291	2267.76	"2022-06-04 17:57:22.162"	1
292	1982.16	"2022-06-22 09:22:09.334"	1
293	2144.03	"2022-07-28 13:01:47.305"	1
294	754.39	"2022-06-12 15:58:02.786"	1
295	1251.51	"2022-07-30 16:31:52.492"	2
296	1998.38	"2022-07-31 21:49:17.755"	2
297	2463.06	"2022-05-04 04:41:50.575"	2
298	554.03	"2022-04-17 10:05:33.589"	2
299	30.24	"2022-05-20 07:29:31.558"	2
300	1283.61	"2022-04-29 21:15:47.775"	2
301	561.02	"2022-07-09 07:48:31.601"	2
302	291.71	"2022-05-31 08:56:25.977"	3
303	2032.9	"2022-04-15 19:35:10.178"	3
304	354.75	"2022-04-17 12:00:16.343"	3
305	838.05	"2022-07-02 01:37:07.355"	3
306	1302.51	"2022-06-18 23:19:54.315"	3
307	55.03	"2022-07-24 22:44:08.998"	3
308	1895.33	"2022-05-06 14:46:30.739"	3
309	2105.3	"2022-04-22 15:29:12.352"	3
310	1023.86	"2022-07-17 19:50:09.341"	3
311	338.94	"2022-06-20 21:31:12.94"	4
312	1437.46	"2022-04-28 20:11:33.587"	4
313	298.7	"2022-07-02 19:43:51.048"	4
314	230.75	"2022-06-12 00:00:51.481"	4
315	635.66	"2022-06-14 12:25:29.078"	5
316	372.8	"2022-07-25 20:57:12.694"	5
317	578.9	"2022-06-15 07:51:24.421"	5
318	1534.53	"2022-04-14 00:25:07.064"	5
319	796.76	"2022-08-10 02:57:26.321"	5
320	421.33	"2022-05-26 00:34:35.033"	5
321	1661.67	"2022-05-21 14:36:19.602"	5
322	437.32	"2022-06-01 20:53:44.621"	5
323	2084.31	"2022-07-25 05:53:17.934"	5
324	627.49	"2022-07-08 02:58:24.872"	5
325	73.32	"2022-05-23 11:28:03.301"	5
326	2303.36	"2022-07-25 13:34:45.552"	5
327	2441.84	"2022-08-02 12:13:16.384"	5
328	886.13	"2022-07-09 18:27:28.625"	5
329	1138.39	"2022-05-14 09:46:05.974"	5
330	1106.58	"2022-08-03 09:21:37.498"	5
331	1612.68	"2022-08-04 00:17:12.348"	5
332	946.76	"2022-05-21 08:10:46.678"	5
333	2039.18	"2022-05-01 21:57:44.491"	5
334	269.6	"2022-04-13 06:27:58.999"	5
335	2130.49	"2022-06-14 11:29:25.085"	5
336	706.54	"2022-05-29 13:47:41.937"	5
337	1436.04	"2022-04-25 21:41:30.73"	5
338	79.03	"2022-08-03 08:56:41.716"	5
339	1085.35	"2022-05-16 00:27:07.9"	5
340	2157.49	"2022-06-12 13:21:20.213"	5
341	1704.64	"2022-04-26 06:40:28.718"	5
342	631.76	"2022-04-27 18:26:45.109"	5
343	1343.38	"2022-05-10 16:28:01.7"	5
344	1908.4	"2022-04-12 09:22:35.354"	5
345	411.46	"2022-04-19 07:56:44.34"	5
346	941.39	"2022-07-30 16:07:51.956"	5
347	9.4	"2022-07-06 02:02:54.164"	5
348	532.97	"2022-04-14 15:00:51.283"	5
349	186.78	"2022-05-07 13:46:29.012"	5
350	739.84	"2022-06-21 21:29:02.809"	5
351	317.85	"2022-06-19 18:28:15.09"	5
352	2251.5	"2022-04-15 18:53:34.299"	5
353	779.11	"2022-06-04 23:12:36.698"	5
354	849.87	"2022-05-15 01:26:21.854"	5
355	2188.16	"2022-06-20 21:11:56.489"	5
356	2117.72	"2022-08-11 14:41:55.215"	5
357	448.76	"2022-05-25 13:40:58.555"	5
358	2225.98	"2022-08-09 09:03:10.837"	1
359	672.86	"2022-06-19 22:23:13.705"	1
360	642.48	"2022-04-15 18:01:00.188"	1
361	577.42	"2022-06-29 17:14:12.873"	1
362	1458.45	"2022-05-15 19:08:11.797"	1
363	1015.5	"2022-07-10 22:29:17.74"	1
364	2390.05	"2022-07-28 10:43:50.011"	1
365	1405.8	"2022-07-13 11:50:31.33"	1
366	2249.55	"2022-06-14 08:32:11.799"	1
367	1576.23	"2022-06-13 03:49:06.923"	1
368	1161.93	"2022-07-24 17:20:21.912"	1
369	644.15	"2022-06-15 10:35:20.651"	1
370	1547.26	"2022-05-22 17:02:33.206"	1
371	1162.14	"2022-07-15 22:59:01.953"	1
372	357.44	"2022-06-29 21:17:29.163"	1
373	248.35	"2022-06-15 05:12:09.703"	1
374	1130.58	"2022-07-27 20:07:05.601"	1
375	1768.55	"2022-06-15 15:48:40.191"	1
376	1186.6	"2022-05-20 21:12:37.877"	1
377	1648.19	"2022-06-17 05:00:09.508"	1
378	1157.64	"2022-04-19 04:11:16.225"	1
379	1049.38	"2022-05-06 12:41:32.701"	1
380	1177.72	"2022-07-20 23:08:24.396"	1
381	1859.74	"2022-06-07 06:34:04.703"	1
382	862.48	"2022-04-16 00:36:59.582"	1
383	151.62	"2022-07-26 04:58:54.045"	1
384	159.57	"2022-06-04 10:10:45.865"	1
385	947.65	"2022-05-12 07:57:17.014"	1
386	2002.13	"2022-05-30 16:09:28.063"	1
387	592.11	"2022-04-11 23:21:08.571"	1
388	2465.2	"2022-07-20 09:40:56.011"	1
389	2496.25	"2022-04-25 03:20:40.278"	1
390	817.24	"2022-06-20 14:31:40.3"	1
391	709.9	"2022-04-15 17:24:34.928"	1
392	1659.91	"2022-06-29 18:36:23.259"	1
393	994.35	"2022-05-14 00:38:36.106"	1
394	2345.31	"2022-05-02 04:49:38.762"	1
395	1432.21	"2022-06-27 12:47:56.428"	1
396	1585.49	"2022-04-12 00:02:51.192"	1
397	1060.48	"2022-07-17 21:54:15.057"	1
398	919.82	"2022-05-28 19:21:42.339"	1
399	888.5	"2022-06-26 02:11:35.171"	1
400	1106.8	"2022-06-12 19:59:19.723"	1
401	162.21	"2022-04-16 04:11:28.872"	1
402	853.34	"2022-05-02 06:20:30.772"	1
403	242.27	"2022-07-20 23:45:04.03"	1
404	2154.61	"2022-05-16 17:28:16.463"	1
405	123.97	"2022-08-08 02:21:30.77"	1
406	2110.41	"2022-04-26 01:53:22.319"	1
407	248.9	"2022-05-03 16:39:50.415"	1
408	13.11	"2022-04-15 12:17:06.872"	1
409	2240.58	"2022-07-12 05:42:52.932"	1
410	2267.76	"2022-06-04 17:57:22.162"	1
411	1982.16	"2022-06-22 09:22:09.334"	1
412	2144.03	"2022-07-28 13:01:47.305"	1
413	754.39	"2022-06-12 15:58:02.786"	1
414	1251.51	"2022-07-30 16:31:52.492"	2
415	1998.38	"2022-07-31 21:49:17.755"	2
416	2463.06	"2022-05-04 04:41:50.575"	2
417	554.03	"2022-04-17 10:05:33.589"	2
418	30.24	"2022-05-20 07:29:31.558"	2
419	1283.61	"2022-04-29 21:15:47.775"	2
420	561.02	"2022-07-09 07:48:31.601"	2
421	291.71	"2022-05-31 08:56:25.977"	3
422	2032.9	"2022-04-15 19:35:10.178"	3
423	354.75	"2022-04-17 12:00:16.343"	3
424	838.05	"2022-07-02 01:37:07.355"	3
425	1302.51	"2022-06-18 23:19:54.315"	3
426	55.03	"2022-07-24 22:44:08.998"	3
427	1895.33	"2022-05-06 14:46:30.739"	3
428	2105.3	"2022-04-22 15:29:12.352"	3
429	1023.86	"2022-07-17 19:50:09.341"	3
430	338.94	"2022-06-20 21:31:12.94"	4
431	1437.46	"2022-04-28 20:11:33.587"	4
432	298.7	"2022-07-02 19:43:51.048"	4
433	230.75	"2022-06-12 00:00:51.481"	4
434	635.66	"2022-06-14 12:25:29.078"	5
435	372.8	"2022-07-25 20:57:12.694"	5
436	578.9	"2022-06-15 07:51:24.421"	5
437	1534.53	"2022-04-14 00:25:07.064"	5
438	796.76	"2022-08-10 02:57:26.321"	5
439	421.33	"2022-05-26 00:34:35.033"	5
440	1661.67	"2022-05-21 14:36:19.602"	5
441	437.32	"2022-06-01 20:53:44.621"	5
442	2084.31	"2022-07-25 05:53:17.934"	5
443	627.49	"2022-07-08 02:58:24.872"	5
444	73.32	"2022-05-23 11:28:03.301"	5
445	2303.36	"2022-07-25 13:34:45.552"	5
446	2441.84	"2022-08-02 12:13:16.384"	5
447	886.13	"2022-07-09 18:27:28.625"	5
448	1138.39	"2022-05-14 09:46:05.974"	5
449	1106.58	"2022-08-03 09:21:37.498"	5
450	1612.68	"2022-08-04 00:17:12.348"	5
451	946.76	"2022-05-21 08:10:46.678"	5
452	2039.18	"2022-05-01 21:57:44.491"	5
453	269.6	"2022-04-13 06:27:58.999"	5
454	2130.49	"2022-06-14 11:29:25.085"	5
455	706.54	"2022-05-29 13:47:41.937"	5
456	1436.04	"2022-04-25 21:41:30.73"	5
457	79.03	"2022-08-03 08:56:41.716"	5
458	1085.35	"2022-05-16 00:27:07.9"	5
459	2157.49	"2022-06-12 13:21:20.213"	5
460	1704.64	"2022-04-26 06:40:28.718"	5
461	631.76	"2022-04-27 18:26:45.109"	5
462	1343.38	"2022-05-10 16:28:01.7"	5
463	1908.4	"2022-04-12 09:22:35.354"	5
464	411.46	"2022-04-19 07:56:44.34"	5
465	941.39	"2022-07-30 16:07:51.956"	5
466	9.4	"2022-07-06 02:02:54.164"	5
467	532.97	"2022-04-14 15:00:51.283"	5
468	186.78	"2022-05-07 13:46:29.012"	5
469	739.84	"2022-06-21 21:29:02.809"	5
470	317.85	"2022-06-19 18:28:15.09"	5
471	2251.5	"2022-04-15 18:53:34.299"	5
472	779.11	"2022-06-04 23:12:36.698"	5
473	849.87	"2022-05-15 01:26:21.854"	5
474	2188.16	"2022-06-20 21:11:56.489"	5
475	2117.72	"2022-08-11 14:41:55.215"	5
476	448.76	"2022-05-25 13:40:58.555"	5
477	2225.98	"2022-08-09 09:03:10.837"	1
478	672.86	"2022-06-19 22:23:13.705"	1
479	642.48	"2022-04-15 18:01:00.188"	1
480	577.42	"2022-06-29 17:14:12.873"	1
481	1458.45	"2022-05-15 19:08:11.797"	1
482	1015.5	"2022-07-10 22:29:17.74"	1
483	2390.05	"2022-07-28 10:43:50.011"	1
484	1405.8	"2022-07-13 11:50:31.33"	1
485	2249.55	"2022-06-14 08:32:11.799"	1
486	1576.23	"2022-06-13 03:49:06.923"	1
487	1161.93	"2022-07-24 17:20:21.912"	1
488	644.15	"2022-06-15 10:35:20.651"	1
489	1547.26	"2022-05-22 17:02:33.206"	1
490	1162.14	"2022-07-15 22:59:01.953"	1
491	357.44	"2022-06-29 21:17:29.163"	1
492	248.35	"2022-06-15 05:12:09.703"	1
493	1130.58	"2022-07-27 20:07:05.601"	1
494	1768.55	"2022-06-15 15:48:40.191"	1
495	1186.6	"2022-05-20 21:12:37.877"	1
496	1648.19	"2022-06-17 05:00:09.508"	1
497	1157.64	"2022-04-19 04:11:16.225"	1
498	1049.38	"2022-05-06 12:41:32.701"	1
499	1177.72	"2022-07-20 23:08:24.396"	1
500	1859.74	"2022-06-07 06:34:04.703"	1
501	862.48	"2022-04-16 00:36:59.582"	1
502	151.62	"2022-07-26 04:58:54.045"	1
503	159.57	"2022-06-04 10:10:45.865"	1
504	947.65	"2022-05-12 07:57:17.014"	1
505	2002.13	"2022-05-30 16:09:28.063"	1
506	592.11	"2022-04-11 23:21:08.571"	1
507	2465.2	"2022-07-20 09:40:56.011"	1
508	2496.25	"2022-04-25 03:20:40.278"	1
509	817.24	"2022-06-20 14:31:40.3"	1
510	709.9	"2022-04-15 17:24:34.928"	1
511	1659.91	"2022-06-29 18:36:23.259"	1
512	994.35	"2022-05-14 00:38:36.106"	1
513	2345.31	"2022-05-02 04:49:38.762"	1
514	1432.21	"2022-06-27 12:47:56.428"	1
515	1585.49	"2022-04-12 00:02:51.192"	1
516	1060.48	"2022-07-17 21:54:15.057"	1
517	919.82	"2022-05-28 19:21:42.339"	1
518	888.5	"2022-06-26 02:11:35.171"	1
519	1106.8	"2022-06-12 19:59:19.723"	1
520	162.21	"2022-04-16 04:11:28.872"	1
521	853.34	"2022-05-02 06:20:30.772"	1
522	242.27	"2022-07-20 23:45:04.03"	1
523	2154.61	"2022-05-16 17:28:16.463"	1
524	123.97	"2022-08-08 02:21:30.77"	1
525	2110.41	"2022-04-26 01:53:22.319"	1
526	248.9	"2022-05-03 16:39:50.415"	1
527	13.11	"2022-04-15 12:17:06.872"	1
528	2240.58	"2022-07-12 05:42:52.932"	1
529	2267.76	"2022-06-04 17:57:22.162"	1
530	1982.16	"2022-06-22 09:22:09.334"	1
531	2144.03	"2022-07-28 13:01:47.305"	1
532	754.39	"2022-06-12 15:58:02.786"	1
533	1251.51	"2022-07-30 16:31:52.492"	2
534	1998.38	"2022-07-31 21:49:17.755"	2
535	2463.06	"2022-05-04 04:41:50.575"	2
536	554.03	"2022-04-17 10:05:33.589"	2
537	30.24	"2022-05-20 07:29:31.558"	2
538	1283.61	"2022-04-29 21:15:47.775"	2
539	561.02	"2022-07-09 07:48:31.601"	2
540	291.71	"2022-05-31 08:56:25.977"	3
541	2032.9	"2022-04-15 19:35:10.178"	3
542	354.75	"2022-04-17 12:00:16.343"	3
543	838.05	"2022-07-02 01:37:07.355"	3
544	1302.51	"2022-06-18 23:19:54.315"	3
545	55.03	"2022-07-24 22:44:08.998"	3
546	1895.33	"2022-05-06 14:46:30.739"	3
547	2105.3	"2022-04-22 15:29:12.352"	3
548	1023.86	"2022-07-17 19:50:09.341"	3
549	338.94	"2022-06-20 21:31:12.94"	4
550	1437.46	"2022-04-28 20:11:33.587"	4
551	298.7	"2022-07-02 19:43:51.048"	4
552	230.75	"2022-06-12 00:00:51.481"	4
553	635.66	"2022-06-14 12:25:29.078"	5
554	372.8	"2022-07-25 20:57:12.694"	5
555	578.9	"2022-06-15 07:51:24.421"	5
556	1534.53	"2022-04-14 00:25:07.064"	5
557	796.76	"2022-08-10 02:57:26.321"	5
558	421.33	"2022-05-26 00:34:35.033"	5
559	1661.67	"2022-05-21 14:36:19.602"	5
560	437.32	"2022-06-01 20:53:44.621"	5
561	2084.31	"2022-07-25 05:53:17.934"	5
562	627.49	"2022-07-08 02:58:24.872"	5
563	73.32	"2022-05-23 11:28:03.301"	5
564	2303.36	"2022-07-25 13:34:45.552"	5
565	2441.84	"2022-08-02 12:13:16.384"	5
566	886.13	"2022-07-09 18:27:28.625"	5
567	1138.39	"2022-05-14 09:46:05.974"	5
568	1106.58	"2022-08-03 09:21:37.498"	5
569	1612.68	"2022-08-04 00:17:12.348"	5
570	946.76	"2022-05-21 08:10:46.678"	5
571	2039.18	"2022-05-01 21:57:44.491"	5
572	269.6	"2022-04-13 06:27:58.999"	5
573	2130.49	"2022-06-14 11:29:25.085"	5
574	706.54	"2022-05-29 13:47:41.937"	5
575	1436.04	"2022-04-25 21:41:30.73"	5
576	79.03	"2022-08-03 08:56:41.716"	5
577	1085.35	"2022-05-16 00:27:07.9"	5
578	2157.49	"2022-06-12 13:21:20.213"	5
579	1704.64	"2022-04-26 06:40:28.718"	5
580	631.76	"2022-04-27 18:26:45.109"	5
581	1343.38	"2022-05-10 16:28:01.7"	5
582	1908.4	"2022-04-12 09:22:35.354"	5
583	411.46	"2022-04-19 07:56:44.34"	5
584	941.39	"2022-07-30 16:07:51.956"	5
585	9.4	"2022-07-06 02:02:54.164"	5
586	532.97	"2022-04-14 15:00:51.283"	5
587	186.78	"2022-05-07 13:46:29.012"	5
588	739.84	"2022-06-21 21:29:02.809"	5
589	317.85	"2022-06-19 18:28:15.09"	5
590	2251.5	"2022-04-15 18:53:34.299"	5
591	779.11	"2022-06-04 23:12:36.698"	5
592	849.87	"2022-05-15 01:26:21.854"	5
593	2188.16	"2022-06-20 21:11:56.489"	5
594	2117.72	"2022-08-11 14:41:55.215"	5
595	448.76	"2022-05-25 13:40:58.555"	5