PREVIEW / stock_30min / 2023-02-23

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-23.parquet
  size:    2.1 MB
  rows:    100,232
  symbols: 1,830

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
2023-02-23 04:00:00	AAPL	Stock	149.74	149.81	149.06	149.39	20326.0
2023-02-23 04:30:00	AAPL	Stock	149.4	149.4	149.26	149.36	4515.0
2023-02-23 05:00:00	AAPL	Stock	149.35	149.38	149.28	149.28	2254.0
2023-02-23 05:30:00	AAPL	Stock	149.26	149.38	149.2	149.38	3066.0
2023-02-23 06:00:00	AAPL	Stock	149.38	149.6	149.32	149.35	3511.0
2023-02-23 06:30:00	AAPL	Stock	149.34	149.56	149.34	149.5	4508.0
2023-02-23 07:00:00	AAPL	Stock	149.58	149.8	149.51	149.79	21202.0
2023-02-23 07:30:00	AAPL	Stock	149.78	149.9	149.63	149.73	38301.0
2023-02-23 08:00:00	AAPL	Stock	149.576	149.99	149.31	149.84	121939.0
2023-02-23 08:30:00	AAPL	Stock	149.83	149.95	149.18	149.6	114490.0
2023-02-23 09:00:00	AAPL	Stock	149.66	150.28	149.63	150.0	171636.0
2023-02-23 09:30:00	AAPL	Stock	150.09	150.34	149.366	149.58	5432441.0
2023-02-23 10:00:00	AAPL	Stock	149.58	149.79	148.7201	148.8499	3596365.0
2023-02-23 10:30:00	AAPL	Stock	148.835	149.0399	147.6701	147.98	3541192.0
2023-02-23 11:00:00	AAPL	Stock	147.97	148.25	147.65	147.81	2525937.0
2023-02-23 11:30:00	AAPL	Stock	147.82	147.99	147.47	147.54	2485296.0
2023-02-23 12:00:00	AAPL	Stock	147.53	147.6801	147.24	147.4666	1895785.0
2023-02-23 12:30:00	AAPL	Stock	147.46	147.82	147.43	147.73	1476545.0
2023-02-23 13:00:00	AAPL	Stock	147.74	147.91	147.43	147.793	1430144.0
2023-02-23 13:30:00	AAPL	Stock	147.8	148.4	147.65	148.1986	1813374.0
2023-02-23 14:00:00	AAPL	Stock	148.19	149.28	148.05	149.2	2419223.0
2023-02-23 14:30:00	AAPL	Stock	149.22	149.66	149.105	149.24	2231556.0
2023-02-23 15:00:00	AAPL	Stock	149.26	149.86	149.25	149.795	2269179.0
2023-02-23 15:30:00	AAPL	Stock	149.795	149.93	149.33	149.42	4174222.0
2023-02-23 16:00:00	AAPL	Stock	149.42	149.46	149.1	149.2	5651101.0
2023-02-23 16:30:00	AAPL	Stock	149.16	149.4	149.11	149.23	12045.0
2023-02-23 17:00:00	AAPL	Stock	149.2	149.28	149.2	149.28	4400.0
2023-02-23 17:30:00	AAPL	Stock	149.22	149.22	149.16	149.18	7186.0
2023-02-23 18:00:00	AAPL	Stock	149.16	149.16	149.0	149.03	8153.0
2023-02-23 18:30:00	AAPL	Stock	149.08	149.08	148.91	148.94	9351.0
2023-02-23 19:00:00	AAPL	Stock	148.94	149.05	148.94	149.04	4562.0
2023-02-23 19:30:00	AAPL	Stock	149.04	149.18	148.95	148.95	14484.0
2023-02-23 04:00:00	MSFT	Stock	252.7	254.28	252.7	252.81	37187.0
2023-02-23 04:30:00	MSFT	Stock	253.39	254.0	253.16	253.51	7756.0
2023-02-23 05:00:00	MSFT	Stock	253.72	254.07	253.7	253.89	3230.0
2023-02-23 05:30:00	MSFT	Stock	253.82	253.84	253.5	253.7	4481.0
2023-02-23 06:00:00	MSFT	Stock	254.28	254.34	254.0	254.0	14757.0
2023-02-23 06:30:00	MSFT	Stock	254.29	254.48	254.29	254.41	2296.0
2023-02-23 07:00:00	MSFT	Stock	254.51	254.51	254.11	254.48	17333.0
2023-02-23 07:30:00	MSFT	Stock	254.32	254.34	253.66	254.01	11144.0
2023-02-23 08:00:00	MSFT	Stock	254.38	254.57	253.32	254.05	44150.0
2023-02-23 08:30:00	MSFT	Stock	254.24	254.37	253.15	254.32	55200.0
2023-02-23 09:00:00	MSFT	Stock	254.32	255.85	254.22	255.55	74207.0
2023-02-23 09:30:00	MSFT	Stock	255.56	256.84	254.24	256.35	3037917.0
2023-02-23 10:00:00	MSFT	Stock	256.37	256.61	254.86	255.29	1471096.0
2023-02-23 10:30:00	MSFT	Stock	255.29	255.81	253.04	253.07	1399937.0
2023-02-23 11:00:00	MSFT	Stock	253.07	253.69	252.3	252.45	1405569.0
2023-02-23 11:30:00	MSFT	Stock	252.44	252.62	251.26	251.3	1324164.0
2023-02-23 12:00:00	MSFT	Stock	251.33	251.89	251.23	251.61	920010.0
2023-02-23 12:30:00	MSFT	Stock	251.61	251.96	251.14	251.62	752904.0

> showing 50 of 100,232 rows — these rows as CSV

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