PREVIEW / stock_30min / 2023-11-21

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-21.parquet
  size:    2.0 MB
  rows:    97,353
  symbols: 1,306

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-11-21 04:00:00	AAPL	Stock	191.41	191.41	191.34	191.4	683.0
2023-11-21 04:30:00	AAPL	Stock	191.32	191.33	191.1	191.12	3967.0
2023-11-21 05:00:00	AAPL	Stock	191.2	191.2	191.2	191.2	204.0
2023-11-21 05:30:00	AAPL	Stock	191.18	191.18	191.18	191.18	150.0
2023-11-21 06:00:00	AAPL	Stock	191.2	191.2	190.92	191.0	5324.0
2023-11-21 06:30:00	AAPL	Stock	191.05	191.25	191.0	191.13	6129.0
2023-11-21 07:00:00	AAPL	Stock	191.15	191.36	191.05	191.27	10257.0
2023-11-21 07:30:00	AAPL	Stock	191.31	191.44	191.15	191.15	11491.0
2023-11-21 08:00:00	AAPL	Stock	191.15	191.54	190.85	191.0	67808.0
2023-11-21 08:30:00	AAPL	Stock	191.0	191.095	190.59	190.6	77294.0
2023-11-21 09:00:00	AAPL	Stock	190.58	191.49	190.57	191.47	132993.0
2023-11-21 09:30:00	AAPL	Stock	191.46	191.52	190.495	190.82	4415415.0
2023-11-21 10:00:00	AAPL	Stock	190.835	191.08	190.27	190.3475	2869985.0
2023-11-21 10:30:00	AAPL	Stock	190.35	190.47	190.07	190.2475	2425538.0
2023-11-21 11:00:00	AAPL	Stock	190.25	190.31	189.74	189.942	2054592.0
2023-11-21 11:30:00	AAPL	Stock	189.94	190.245	189.83	190.2219	1440993.0
2023-11-21 12:00:00	AAPL	Stock	190.235	190.32	190.09	190.275	1191981.0
2023-11-21 12:30:00	AAPL	Stock	190.277	190.595	190.2	190.53	1328971.0
2023-11-21 13:00:00	AAPL	Stock	190.529	190.6	190.04	190.12	1375964.0
2023-11-21 13:30:00	AAPL	Stock	190.12	190.6	190.085	190.42	1157939.0
2023-11-21 14:00:00	AAPL	Stock	190.41	190.615	190.19	190.38	1293927.0
2023-11-21 14:30:00	AAPL	Stock	190.3828	190.5495	190.29	190.5175	1100541.0
2023-11-21 15:00:00	AAPL	Stock	190.51	190.71	190.495	190.65	1588050.0
2023-11-21 15:30:00	AAPL	Stock	190.645	190.73	190.29	190.65	3783512.0
2023-11-21 16:00:00	AAPL	Stock	190.64	190.75	190.25	190.65	4248567.0
2023-11-21 16:30:00	AAPL	Stock	190.64	190.77	190.4	190.56	46514.0
2023-11-21 17:00:00	AAPL	Stock	190.57	190.58	190.47	190.53	3915.0
2023-11-21 17:30:00	AAPL	Stock	190.55	190.75	190.5	190.66	17912.0
2023-11-21 18:00:00	AAPL	Stock	190.62	190.62	190.37	190.56	17015.0
2023-11-21 18:30:00	AAPL	Stock	190.51	190.58	190.42	190.51	7117.0
2023-11-21 19:00:00	AAPL	Stock	190.55	190.59	190.3	190.38	18861.0
2023-11-21 19:30:00	AAPL	Stock	190.33	190.44	190.3	190.3	7034.0
2023-11-21 04:00:00	MSFT	Stock	378.83	379.0	378.24	378.95	3562.0
2023-11-21 04:30:00	MSFT	Stock	378.98	379.0	378.52	378.83	3452.0
2023-11-21 05:00:00	MSFT	Stock	378.8	379.23	378.8	379.23	2221.0
2023-11-21 05:30:00	MSFT	Stock	379.6	379.6	378.99	378.99	952.0
2023-11-21 06:00:00	MSFT	Stock	379.0	379.0	378.66	378.8	2546.0
2023-11-21 06:30:00	MSFT	Stock	378.7	378.7	376.93	377.0	11815.0
2023-11-21 07:00:00	MSFT	Stock	377.48	377.85	376.0	376.0	35545.0
2023-11-21 07:30:00	MSFT	Stock	375.9	376.3	375.48	375.55	20418.0
2023-11-21 08:00:00	MSFT	Stock	375.5	379.6	374.6801	374.9883	90008.0
2023-11-21 08:30:00	MSFT	Stock	374.9	375.0	374.11	374.57	48003.0
2023-11-21 09:00:00	MSFT	Stock	374.44	376.88	374.2	375.69	108989.0
2023-11-21 09:30:00	MSFT	Stock	375.69	376.2215	373.55	375.015	2654445.0
2023-11-21 10:00:00	MSFT	Stock	375.01	375.25	371.48	371.74	1883698.0
2023-11-21 10:30:00	MSFT	Stock	371.75	372.7	371.12	372.2453	1509703.0
2023-11-21 11:00:00	MSFT	Stock	372.245	372.48	371.22	372.06	921849.0
2023-11-21 11:30:00	MSFT	Stock	372.03	372.53	371.412	372.4401	760532.0
2023-11-21 12:00:00	MSFT	Stock	372.47	373.161	371.64	373.105	926499.0
2023-11-21 12:30:00	MSFT	Stock	373.11	373.53	372.304	372.58	1247245.0

> showing 50 of 97,353 rows — these rows as CSV

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