PREVIEW / stock_30min / 2023-08-14

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-14.parquet
  size:    2.1 MB
  rows:    100,418
  symbols: 1,524

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-08-14 04:00:00	AAPL	Stock	177.82	179.45	177.73	178.55	74996.0
2023-08-14 04:30:00	AAPL	Stock	178.56	178.84	178.5	178.63	15065.0
2023-08-14 05:00:00	AAPL	Stock	178.55	178.71	178.29	178.68	4816.0
2023-08-14 05:30:00	AAPL	Stock	178.55	178.7	178.55	178.56	1282.0
2023-08-14 06:00:00	AAPL	Stock	178.56	178.78	178.5	178.7	4601.0
2023-08-14 06:30:00	AAPL	Stock	178.7	178.77	178.63	178.63	4495.0
2023-08-14 07:00:00	AAPL	Stock	178.55	178.57	178.26	178.35	27590.0
2023-08-14 07:30:00	AAPL	Stock	178.39	178.4	177.99	178.18	35013.0
2023-08-14 08:00:00	AAPL	Stock	178.45	178.765	177.7	177.79	127086.0
2023-08-14 08:30:00	AAPL	Stock	177.72	177.91	177.38	177.65	101834.0
2023-08-14 09:00:00	AAPL	Stock	177.65	177.99	177.4	177.95	96144.0
2023-08-14 09:30:00	AAPL	Stock	177.92	178.53	177.305	178.275	5219130.0
2023-08-14 10:00:00	AAPL	Stock	178.27	178.86	178.02	178.27	3204847.0
2023-08-14 10:30:00	AAPL	Stock	178.27	179.69	178.26	179.44	3269864.0
2023-08-14 11:00:00	AAPL	Stock	179.438	179.54	179.0	179.35	1779247.0
2023-08-14 11:30:00	AAPL	Stock	179.35	179.488	178.94	179.01	1761847.0
2023-08-14 12:00:00	AAPL	Stock	179.015	179.255	178.62	178.7145	1888452.0
2023-08-14 12:30:00	AAPL	Stock	178.71	179.22	178.59	179.16	1246781.0
2023-08-14 13:00:00	AAPL	Stock	179.17	179.44	179.13	179.2279	1104554.0
2023-08-14 13:30:00	AAPL	Stock	179.23	179.3	179.03	179.169	1027473.0
2023-08-14 14:00:00	AAPL	Stock	179.17	179.35	178.9096	179.09	1504625.0
2023-08-14 14:30:00	AAPL	Stock	179.1	179.11	178.7	178.95	1428583.0
2023-08-14 15:00:00	AAPL	Stock	178.96	179.145	178.83	178.965	1630030.0
2023-08-14 15:30:00	AAPL	Stock	178.96	179.52	178.86	179.51	3794934.0
2023-08-14 16:00:00	AAPL	Stock	179.515	179.6	179.31	179.42	5667618.0
2023-08-14 16:30:00	AAPL	Stock	179.42	179.46	179.4	179.43	64881.0
2023-08-14 17:00:00	AAPL	Stock	179.41	179.4999	179.41	179.47	23598.0
2023-08-14 17:30:00	AAPL	Stock	179.5	179.55	179.47	179.51	9160.0
2023-08-14 18:00:00	AAPL	Stock	179.5	179.67	179.47	179.67	13876.0
2023-08-14 18:30:00	AAPL	Stock	179.664	179.84	179.65	179.81	12339.0
2023-08-14 19:00:00	AAPL	Stock	179.82	179.84	179.65	179.8	8331.0
2023-08-14 19:30:00	AAPL	Stock	179.8	179.93	179.75	179.91	25523.0
2023-08-14 04:00:00	MSFT	Stock	322.1	323.46	322.1	323.0	4736.0
2023-08-14 04:30:00	MSFT	Stock	322.7	322.9	322.21	322.5	1825.0
2023-08-14 05:00:00	MSFT	Stock	322.21	322.51	322.21	322.45	1227.0
2023-08-14 05:30:00	MSFT	Stock	322.43	322.43	322.35	322.35	300.0
2023-08-14 06:00:00	MSFT	Stock	322.56	322.7	322.4	322.4	4501.0
2023-08-14 06:30:00	MSFT	Stock	322.86	323.32	322.78	323.32	4361.0
2023-08-14 07:00:00	MSFT	Stock	322.75	322.75	322.2	322.5	4834.0
2023-08-14 07:30:00	MSFT	Stock	322.68	322.68	322.2	322.2	1453.0
2023-08-14 08:00:00	MSFT	Stock	322.71	323.0	321.25	321.4674	14505.0
2023-08-14 08:30:00	MSFT	Stock	321.1	321.6	320.658	321.36	21467.0
2023-08-14 09:00:00	MSFT	Stock	321.5199	321.52	320.3	321.45	14770.0
2023-08-14 09:30:00	MSFT	Stock	321.39	321.87	320.08	320.985	1306733.0
2023-08-14 10:00:00	MSFT	Stock	320.99	322.22	320.65	320.95	1323583.0
2023-08-14 10:30:00	MSFT	Stock	320.9501	324.06	320.8586	323.61	1141839.0
2023-08-14 11:00:00	MSFT	Stock	323.65	323.65	322.16	322.78	825431.0
2023-08-14 11:30:00	MSFT	Stock	322.8	323.9456	322.19	322.87	828554.0
2023-08-14 12:00:00	MSFT	Stock	322.95	323.135	321.89	322.15	555845.0
2023-08-14 12:30:00	MSFT	Stock	322.1	322.6699	321.836	322.3799	373450.0

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

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