PREVIEW / stock_30min / 2022-06-17

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-06-17.parquet
  size:    2.1 MB
  rows:    106,821
  symbols: 2,386

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2022-06-17 04:00:00	AAPL	Stock	131.01	131.54	130.92	131.47	25544.0
2022-06-17 04:30:00	AAPL	Stock	131.56	131.7	131.16	131.37	12944.0
2022-06-17 05:00:00	AAPL	Stock	131.3	131.59	131.3	131.58	10203.0
2022-06-17 05:30:00	AAPL	Stock	131.57	131.59	131.2	131.48	12085.0
2022-06-17 06:00:00	AAPL	Stock	131.4	131.5	131.2	131.45	6015.0
2022-06-17 06:30:00	AAPL	Stock	131.45	131.69	131.31	131.42	17637.0
2022-06-17 07:00:00	AAPL	Stock	131.42	131.75	131.26	131.75	38123.0
2022-06-17 07:30:00	AAPL	Stock	131.75	131.99	131.23	131.36	67635.0
2022-06-17 08:00:00	AAPL	Stock	131.3999	131.95	130.99	131.3	349753.0
2022-06-17 08:30:00	AAPL	Stock	131.3	131.41	130.6	130.7	303785.0
2022-06-17 09:00:00	AAPL	Stock	130.7	130.81	129.76	130.06	727853.0
2022-06-17 09:30:00	AAPL	Stock	130.07	132.66	130.01	132.05	24059802.0
2022-06-17 10:00:00	AAPL	Stock	132.06	132.4199	130.82	131.04	6066219.0
2022-06-17 10:30:00	AAPL	Stock	131.05	131.16	129.81	130.5968	5754535.0
2022-06-17 11:00:00	AAPL	Stock	130.6	132.5397	130.205	132.51	6024153.0
2022-06-17 11:30:00	AAPL	Stock	132.5147	132.83	131.2	131.3465	5222634.0
2022-06-17 12:00:00	AAPL	Stock	131.35	132.1	131.08	131.89	4061756.0
2022-06-17 12:30:00	AAPL	Stock	131.8987	132.32	131.66	131.97	3792187.0
2022-06-17 13:00:00	AAPL	Stock	131.98	133.079	131.86	132.4491	4118529.0
2022-06-17 13:30:00	AAPL	Stock	132.45	132.51	131.65	132.0737	3503685.0
2022-06-17 14:00:00	AAPL	Stock	132.08	132.54	131.85	132.215	3283969.0
2022-06-17 14:30:00	AAPL	Stock	132.21	132.44	131.69	131.874	3985778.0
2022-06-17 15:00:00	AAPL	Stock	131.87	132.22	131.0428	131.9776	5816371.0
2022-06-17 15:30:00	AAPL	Stock	131.97	132.14	131.4	131.42	10710421.0
2022-06-17 16:00:00	AAPL	Stock	131.48	131.7	131.35	131.65	31702617.0
2022-06-17 16:30:00	AAPL	Stock	131.5999	131.62	131.45	131.52	63740.0
2022-06-17 17:00:00	AAPL	Stock	131.51	131.56	131.42	131.48	1382380.0
2022-06-17 17:30:00	AAPL	Stock	131.45	131.56	131.44	131.5273	260945.0
2022-06-17 18:00:00	AAPL	Stock	131.57	131.58	131.51	131.56	11566.0
2022-06-17 18:30:00	AAPL	Stock	131.57	131.66	131.53	131.62	12556.0
2022-06-17 19:00:00	AAPL	Stock	131.55	131.61	131.5	131.52	9224.0
2022-06-17 19:30:00	AAPL	Stock	131.52	131.57	131.5	131.56	5860.0
2022-06-17 04:00:00	MSFT	Stock	246.51	247.08	246.5	247.08	1942.0
2022-06-17 04:30:00	MSFT	Stock	247.3	247.5	246.82	246.82	2218.0
2022-06-17 05:00:00	MSFT	Stock	246.8	247.47	246.8	247.3	4065.0
2022-06-17 05:30:00	MSFT	Stock	247.1	247.18	246.8	247.1	3174.0
2022-06-17 06:00:00	MSFT	Stock	247.11	247.49	247.1	247.32	1392.0
2022-06-17 06:30:00	MSFT	Stock	247.5	247.8	247.13	247.15	1833.0
2022-06-17 07:00:00	MSFT	Stock	247.05	247.95	247.05	247.89	8683.0
2022-06-17 07:30:00	MSFT	Stock	247.95	248.1	247.1	247.2	18872.0
2022-06-17 08:00:00	MSFT	Stock	247.69	248.16	244.358	247.38	21028.0
2022-06-17 08:30:00	MSFT	Stock	247.38	247.38	246.11	246.3	53749.0
2022-06-17 09:00:00	MSFT	Stock	246.18	246.32	244.13	244.25	112632.0
2022-06-17 09:30:00	MSFT	Stock	244.53	249.0	244.36	247.76	8872119.0
2022-06-17 10:00:00	MSFT	Stock	247.81	247.94	245.79	246.13	1324265.0
2022-06-17 10:30:00	MSFT	Stock	246.145	246.4	244.03	245.11	1367529.0
2022-06-17 11:00:00	MSFT	Stock	245.13	247.97	244.45	247.85	1272690.0
2022-06-17 11:30:00	MSFT	Stock	247.87	248.66	246.6	246.9	1264409.0
2022-06-17 12:00:00	MSFT	Stock	246.92	247.87	246.4201	247.705	1218329.0
2022-06-17 12:30:00	MSFT	Stock	247.7	248.827	247.33	248.645	1069117.0

> showing 50 of 106,821 rows — these rows as CSV

> unlock the full archive -- $79 one-time