PREVIEW / stock_30min / 2024-07-09

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-07-09.parquet
  size:    2.0 MB
  rows:    96,984
  symbols: 904

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
2024-07-09 04:00:00	AAPL	Stock	228.27	228.27	227.5	227.8	12855.0
2024-07-09 04:30:00	AAPL	Stock	227.62	227.7	227.43	227.55	5712.0
2024-07-09 05:00:00	AAPL	Stock	227.74	227.83	227.38	227.52	7029.0
2024-07-09 05:30:00	AAPL	Stock	227.57	227.64	227.47	227.47	4087.0
2024-07-09 06:00:00	AAPL	Stock	227.63	227.73	227.63	227.65	502.0
2024-07-09 06:30:00	AAPL	Stock	227.61	227.74	227.57	227.74	2715.0
2024-07-09 07:00:00	AAPL	Stock	227.74	228.0	227.56	227.75	23154.0
2024-07-09 07:30:00	AAPL	Stock	227.73	227.73	227.5	227.53	7603.0
2024-07-09 08:00:00	AAPL	Stock	227.75	228.75	227.46	227.9	96499.0
2024-07-09 08:30:00	AAPL	Stock	227.88	228.4695	227.83	228.3002	64701.0
2024-07-09 09:00:00	AAPL	Stock	228.3	228.36	227.82	227.85	184081.0
2024-07-09 09:30:00	AAPL	Stock	227.88	228.28	226.3721	228.175	5524199.0
2024-07-09 10:00:00	AAPL	Stock	228.175	229.4	228.03	228.54	4714307.0
2024-07-09 10:30:00	AAPL	Stock	228.5229	228.67	227.3	228.42	4086266.0
2024-07-09 11:00:00	AAPL	Stock	228.43	228.4691	227.465	227.915	2231168.0
2024-07-09 11:30:00	AAPL	Stock	227.9101	228.23	227.6	228.2001	1475840.0
2024-07-09 12:00:00	AAPL	Stock	228.21	228.248	227.71	228.18	1600099.0
2024-07-09 12:30:00	AAPL	Stock	228.17	228.54	228.08	228.5101	1483820.0
2024-07-09 13:00:00	AAPL	Stock	228.525	228.7254	228.01	228.01	1427147.0
2024-07-09 13:30:00	AAPL	Stock	228.01	228.25	227.85	228.1	1172902.0
2024-07-09 14:00:00	AAPL	Stock	228.1	228.535	227.88	228.44	1465829.0
2024-07-09 14:30:00	AAPL	Stock	228.45	228.5199	228.17	228.29	1265692.0
2024-07-09 15:00:00	AAPL	Stock	228.28	228.46	228.16	228.36	1423277.0
2024-07-09 15:30:00	AAPL	Stock	228.35	228.78	228.18	228.7	4030360.0
2024-07-09 16:00:00	AAPL	Stock	228.68	228.78	228.6786	228.7	5798397.0
2024-07-09 16:30:00	AAPL	Stock	228.69	228.75	228.62	228.62	91269.0
2024-07-09 17:00:00	AAPL	Stock	228.6196	228.65	228.42	228.6	17132.0
2024-07-09 17:30:00	AAPL	Stock	228.66	228.73	228.62	228.68	14947.0
2024-07-09 18:00:00	AAPL	Stock	228.68	228.84	228.6285	228.8	41620.0
2024-07-09 18:30:00	AAPL	Stock	228.8194	228.99	228.8	228.9365	11209.0
2024-07-09 19:00:00	AAPL	Stock	228.95	228.98	228.85	228.9628	7351.0
2024-07-09 19:30:00	AAPL	Stock	228.94	229.0	228.9069	229.0	23222.0
2024-07-09 04:00:00	MSFT	Stock	466.12	467.56	466.12	467.48	340.0
2024-07-09 04:30:00	MSFT	Stock	467.5	467.5	467.17	467.17	316.0
2024-07-09 05:00:00	MSFT	Stock	467.02	467.33	467.02	467.33	200.0
2024-07-09 06:00:00	MSFT	Stock	467.23	467.29	467.21	467.29	1228.0
2024-07-09 06:30:00	MSFT	Stock	467.26	467.26	467.26	467.26	100.0
2024-07-09 07:00:00	MSFT	Stock	467.29	467.59	467.13	467.13	2858.0
2024-07-09 07:30:00	MSFT	Stock	467.3	467.35	467.14	467.3	1029.0
2024-07-09 08:00:00	MSFT	Stock	467.2891	468.2	466.75	466.8	12649.0
2024-07-09 08:30:00	MSFT	Stock	466.73	466.92	466.73	466.88	5852.0
2024-07-09 09:00:00	MSFT	Stock	466.82	467.35	466.52	467.1	15708.0
2024-07-09 09:30:00	MSFT	Stock	467.07	467.33	463.82	464.62	1442080.0
2024-07-09 10:00:00	MSFT	Stock	464.62	464.9	463.45	464.18	832508.0
2024-07-09 10:30:00	MSFT	Stock	464.2	464.24	463.42	463.55	537375.0
2024-07-09 11:00:00	MSFT	Stock	463.5525	464.06	462.22	463.325	522426.0
2024-07-09 11:30:00	MSFT	Stock	463.35	463.66	461.41	461.745	576664.0
2024-07-09 12:00:00	MSFT	Stock	461.76	462.17	460.83	461.22	489896.0
2024-07-09 12:30:00	MSFT	Stock	461.24	461.25	459.31	460.01	845505.0
2024-07-09 13:00:00	MSFT	Stock	460.015	460.42	459.36	459.75	537574.0

> showing 50 of 96,984 rows — these rows as CSV

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