PREVIEW / stock_30min / 2022-08-11

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-11.parquet
  size:    2.2 MB
  rows:    107,587
  symbols: 2,276

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-08-11 04:00:00	AAPL	Stock	169.0	169.35	169.0	169.2	13527.0
2022-08-11 04:30:00	AAPL	Stock	169.16	169.28	169.08	169.28	6511.0
2022-08-11 05:00:00	AAPL	Stock	169.3	169.37	169.28	169.37	4871.0
2022-08-11 05:30:00	AAPL	Stock	169.37	169.59	169.26	169.31	17910.0
2022-08-11 06:00:00	AAPL	Stock	169.25	169.26	169.06	169.07	12211.0
2022-08-11 06:30:00	AAPL	Stock	169.22	169.22	169.12	169.12	2482.0
2022-08-11 07:00:00	AAPL	Stock	169.23	169.46	169.12	169.46	24647.0
2022-08-11 07:30:00	AAPL	Stock	169.48	169.8	169.45	169.75	19810.0
2022-08-11 08:00:00	AAPL	Stock	169.1277	170.24	169.1	170.19	295477.0
2022-08-11 08:30:00	AAPL	Stock	170.2	170.4	169.75	170.17	290271.0
2022-08-11 09:00:00	AAPL	Stock	170.16	170.17	169.8	170.0	209195.0
2022-08-11 09:30:00	AAPL	Stock	170.06	170.55	169.62	170.25	7758437.0
2022-08-11 10:00:00	AAPL	Stock	170.25	170.99	170.11	170.215	4873140.0
2022-08-11 10:30:00	AAPL	Stock	170.22	170.52	169.714	169.7799	3476432.0
2022-08-11 11:00:00	AAPL	Stock	169.78	169.91	168.97	169.48	3823073.0
2022-08-11 11:30:00	AAPL	Stock	169.48	169.79	169.0	169.23	2599029.0
2022-08-11 12:00:00	AAPL	Stock	169.22	169.515	168.89	169.51	1895772.0
2022-08-11 12:30:00	AAPL	Stock	169.5	169.755	169.38	169.61	1657667.0
2022-08-11 13:00:00	AAPL	Stock	169.615	169.725	169.2263	169.41	1651321.0
2022-08-11 13:30:00	AAPL	Stock	169.4	169.5	169.16	169.2391	1591351.0
2022-08-11 14:00:00	AAPL	Stock	169.2304	169.2304	168.55	168.8205	2069570.0
2022-08-11 14:30:00	AAPL	Stock	168.825	168.89	168.39	168.775	2075208.0
2022-08-11 15:00:00	AAPL	Stock	168.7799	168.8979	168.335	168.72	2294539.0
2022-08-11 15:30:00	AAPL	Stock	168.715	168.9161	168.19	168.52	5588463.0
2022-08-11 16:00:00	AAPL	Stock	168.51	168.84	168.33	168.72	4820187.0
2022-08-11 16:30:00	AAPL	Stock	168.7	168.94	168.49	168.805	75104.0
2022-08-11 17:00:00	AAPL	Stock	168.8428	168.88	168.74	168.7793	10428.0
2022-08-11 17:30:00	AAPL	Stock	168.74	168.83	168.49	168.82	644039.0
2022-08-11 18:00:00	AAPL	Stock	168.79	168.81	168.6	168.65	35601.0
2022-08-11 18:30:00	AAPL	Stock	168.64	168.69	168.58	168.68	7520.0
2022-08-11 19:00:00	AAPL	Stock	168.7	168.77	168.7	168.76	5751.0
2022-08-11 19:30:00	AAPL	Stock	168.75	168.83	168.71	168.78	14390.0
2022-08-11 04:00:00	MSFT	Stock	289.5	289.98	289.35	289.35	1360.0
2022-08-11 04:30:00	MSFT	Stock	289.28	289.45	289.0	289.36	1883.0
2022-08-11 05:00:00	MSFT	Stock	289.36	289.5	289.36	289.39	1321.0
2022-08-11 05:30:00	MSFT	Stock	289.4	289.8	289.4	289.73	1787.0
2022-08-11 06:00:00	MSFT	Stock	289.5	289.5	289.3	289.3	1117.0
2022-08-11 07:00:00	MSFT	Stock	289.26	289.53	289.26	289.53	2379.0
2022-08-11 07:30:00	MSFT	Stock	289.6	289.89	289.55	289.89	3023.0
2022-08-11 08:00:00	MSFT	Stock	289.5	291.0	289.16	290.5	24021.0
2022-08-11 08:30:00	MSFT	Stock	290.88	291.44	290.0	291.4	47318.0
2022-08-11 09:00:00	MSFT	Stock	291.25	291.25	289.95	290.86	34152.0
2022-08-11 09:30:00	MSFT	Stock	290.88	291.21	288.51	288.92	2311274.0
2022-08-11 10:00:00	MSFT	Stock	288.96	290.45	288.96	289.02	1219600.0
2022-08-11 10:30:00	MSFT	Stock	289.0326	289.56	287.88	288.3881	968040.0
2022-08-11 11:00:00	MSFT	Stock	288.38	288.49	287.05	288.07	997652.0
2022-08-11 11:30:00	MSFT	Stock	288.06	288.725	287.785	288.53	833266.0
2022-08-11 12:00:00	MSFT	Stock	288.535	288.8	287.8743	288.77	540485.0
2022-08-11 12:30:00	MSFT	Stock	288.75	289.07	288.48	288.5794	541385.0
2022-08-11 13:00:00	MSFT	Stock	288.61	289.2	288.22	288.75	473497.0

> showing 50 of 107,587 rows — these rows as CSV

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