PREVIEW / stock_30min / 2022-09-19

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-19.parquet
  size:    2.1 MB
  rows:    104,582
  symbols: 2,237

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-09-19 04:00:00	AAPL	Stock	149.97	149.97	149.02	149.55	27375.0
2022-09-19 04:30:00	AAPL	Stock	149.5	149.5	149.15	149.2	3517.0
2022-09-19 05:00:00	AAPL	Stock	149.24	149.31	149.01	149.16	13452.0
2022-09-19 05:30:00	AAPL	Stock	149.09	149.19	149.04	149.17	14721.0
2022-09-19 06:00:00	AAPL	Stock	149.09	149.09	148.71	148.92	20163.0
2022-09-19 06:30:00	AAPL	Stock	148.85	149.2	148.85	149.2	15276.0
2022-09-19 07:00:00	AAPL	Stock	149.2	149.31	149.04	149.15	82438.0
2022-09-19 07:30:00	AAPL	Stock	149.16	149.42	149.1	149.15	22883.0
2022-09-19 08:00:00	AAPL	Stock	149.17	149.64	149.0412	149.6076	126083.0
2022-09-19 08:30:00	AAPL	Stock	149.59	149.88	149.51	149.61	85421.0
2022-09-19 09:00:00	AAPL	Stock	149.62	149.72	149.08	149.22	157737.0
2022-09-19 09:30:00	AAPL	Stock	149.31	151.12	149.1	151.105	8874806.0
2022-09-19 10:00:00	AAPL	Stock	151.11	151.56	150.57	151.22	5804583.0
2022-09-19 10:30:00	AAPL	Stock	151.21	152.4	151.0138	152.09	4617722.0
2022-09-19 11:00:00	AAPL	Stock	152.1	152.83	151.96	151.98	4972525.0
2022-09-19 11:30:00	AAPL	Stock	151.9821	152.54	151.75	151.94	4804764.0
2022-09-19 12:00:00	AAPL	Stock	151.9371	152.48	151.42	152.3092	3728119.0
2022-09-19 12:30:00	AAPL	Stock	152.31	153.33	152.285	153.1607	4264931.0
2022-09-19 13:00:00	AAPL	Stock	153.161	153.29	152.7	153.29	2779019.0
2022-09-19 13:30:00	AAPL	Stock	153.29	153.45	152.79	152.9591	3070491.0
2022-09-19 14:00:00	AAPL	Stock	152.96	153.04	152.6018	152.925	2869890.0
2022-09-19 14:30:00	AAPL	Stock	152.92	153.1801	152.74	153.09	2841666.0
2022-09-19 15:00:00	AAPL	Stock	153.1	154.2899	153.1	154.1389	5414926.0
2022-09-19 15:30:00	AAPL	Stock	154.14	154.56	153.83	154.54	8335859.0
2022-09-19 16:00:00	AAPL	Stock	154.53	154.88	154.3	154.5	6999924.0
2022-09-19 16:30:00	AAPL	Stock	154.49	154.75	154.43	154.56	114073.0
2022-09-19 17:00:00	AAPL	Stock	154.56	154.68	154.48	154.6	46143.0
2022-09-19 17:30:00	AAPL	Stock	154.6	154.72	154.53	154.64	38963.0
2022-09-19 18:00:00	AAPL	Stock	154.67	154.91	154.62	154.84	19886.0
2022-09-19 18:30:00	AAPL	Stock	154.82	154.87	154.75	154.79	13352.0
2022-09-19 19:00:00	AAPL	Stock	154.8	154.85	154.67	154.77	18789.0
2022-09-19 19:30:00	AAPL	Stock	154.77	155.01	154.77	155.01	61879.0
2022-09-19 04:00:00	MSFT	Stock	243.0	243.28	242.52	243.28	4963.0
2022-09-19 04:30:00	MSFT	Stock	243.11	243.11	242.5	242.5	1495.0
2022-09-19 05:00:00	MSFT	Stock	242.5	242.81	242.5	242.6	3312.0
2022-09-19 05:30:00	MSFT	Stock	242.35	242.49	242.21	242.49	787.0
2022-09-19 06:00:00	MSFT	Stock	242.35	242.35	242.1	242.3	1382.0
2022-09-19 06:30:00	MSFT	Stock	242.31	242.48	242.3	242.48	964.0
2022-09-19 07:00:00	MSFT	Stock	242.48	242.92	242.22	242.3	19547.0
2022-09-19 07:30:00	MSFT	Stock	242.4	242.56	242.15	242.21	6365.0
2022-09-19 08:00:00	MSFT	Stock	242.1004	243.06	242.1	242.6829	17926.0
2022-09-19 08:30:00	MSFT	Stock	242.7	243.2741	242.7	243.07	17426.0
2022-09-19 09:00:00	MSFT	Stock	242.95	243.1	242.08	242.43	20602.0
2022-09-19 09:30:00	MSFT	Stock	242.48	243.98	241.95	243.61	2158185.0
2022-09-19 10:00:00	MSFT	Stock	243.63	244.34	242.7101	243.42	1069015.0
2022-09-19 10:30:00	MSFT	Stock	243.38	244.58	243.07	243.62	1067164.0
2022-09-19 11:00:00	MSFT	Stock	243.66	244.18	242.68	242.77	882108.0
2022-09-19 11:30:00	MSFT	Stock	242.775	242.85	241.65	241.6911	1319637.0
2022-09-19 12:00:00	MSFT	Stock	241.67	241.95	240.85	241.35	1319026.0
2022-09-19 12:30:00	MSFT	Stock	241.34	242.83	241.24	242.58	1466399.0

> showing 50 of 104,582 rows — these rows as CSV

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