PREVIEW / stock_30min / 2024-04-05

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-04-05.parquet
  size:    2.0 MB
  rows:    97,770
  symbols: 1,027

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-04-05 04:00:00	AAPL	Stock	169.2	169.22	169.1	169.2	8692.0
2024-04-05 04:30:00	AAPL	Stock	169.29	169.35	169.25	169.3	4680.0
2024-04-05 05:00:00	AAPL	Stock	169.36	169.4	169.3	169.4	3548.0
2024-04-05 05:30:00	AAPL	Stock	169.4	169.4	169.4	169.4	156.0
2024-04-05 06:00:00	AAPL	Stock	169.44	169.44	169.27	169.27	1744.0
2024-04-05 06:30:00	AAPL	Stock	169.29	169.47	169.29	169.47	2749.0
2024-04-05 07:00:00	AAPL	Stock	169.48	169.5	169.36	169.43	5094.0
2024-04-05 07:30:00	AAPL	Stock	169.46	169.94	169.46	169.7	14669.0
2024-04-05 08:00:00	AAPL	Stock	169.4	169.9499	169.24	169.75	60271.0
2024-04-05 08:30:00	AAPL	Stock	169.67	170.1	168.81	169.82	158337.0
2024-04-05 09:00:00	AAPL	Stock	169.8	170.1	169.1	169.51	106762.0
2024-04-05 09:30:00	AAPL	Stock	169.59	169.7399	168.95	169.54	4462462.0
2024-04-05 10:00:00	AAPL	Stock	169.54	169.91	169.045	169.22	2706120.0
2024-04-05 10:30:00	AAPL	Stock	169.23	169.66	169.09	169.65	1875477.0
2024-04-05 11:00:00	AAPL	Stock	169.645	169.82	169.2109	169.465	1953416.0
2024-04-05 11:30:00	AAPL	Stock	169.465	170.24	169.389	170.21	2209133.0
2024-04-05 12:00:00	AAPL	Stock	170.21	170.39	170.0101	170.17	1544577.0
2024-04-05 12:30:00	AAPL	Stock	170.17	170.32	169.9301	170.26	1286607.0
2024-04-05 13:00:00	AAPL	Stock	170.255	170.375	169.78	170.074	1307426.0
2024-04-05 13:30:00	AAPL	Stock	170.09	170.17	169.51	169.62	1294498.0
2024-04-05 14:00:00	AAPL	Stock	169.63	169.97	169.35	169.5003	1407072.0
2024-04-05 14:30:00	AAPL	Stock	169.51	169.81	169.36	169.59	1397841.0
2024-04-05 15:00:00	AAPL	Stock	169.59	169.92	169.54	169.89	1621565.0
2024-04-05 15:30:00	AAPL	Stock	169.89	169.98	169.5	169.6	3656814.0
2024-04-05 16:00:00	AAPL	Stock	169.57	169.99	169.51	169.55	6644862.0
2024-04-05 16:30:00	AAPL	Stock	169.55	169.58	169.47	169.56	45221.0
2024-04-05 17:00:00	AAPL	Stock	169.56	169.7	169.53	169.6	10225.0
2024-04-05 17:30:00	AAPL	Stock	169.6	169.68	169.55	169.63	6781.0
2024-04-05 18:00:00	AAPL	Stock	169.62	169.6763	169.6	169.64	6398.0
2024-04-05 18:30:00	AAPL	Stock	169.65	169.68	169.45	169.5	8948.0
2024-04-05 19:00:00	AAPL	Stock	169.5	169.55	169.25	169.55	10067.0
2024-04-05 19:30:00	AAPL	Stock	169.53	169.56	169.35	169.47	9597.0
2024-04-05 04:00:00	MSFT	Stock	419.21	419.4	419.21	419.3	740.0
2024-04-05 04:30:00	MSFT	Stock	419.54	419.55	419.22	419.43	1272.0
2024-04-05 05:30:00	MSFT	Stock	419.39	419.68	419.39	419.68	712.0
2024-04-05 06:30:00	MSFT	Stock	419.45	419.5	419.45	419.5	387.0
2024-04-05 07:00:00	MSFT	Stock	419.91	420.4	419.91	420.19	2203.0
2024-04-05 07:30:00	MSFT	Stock	420.3	420.4	420.3	420.4	1661.0
2024-04-05 08:00:00	MSFT	Stock	419.96	420.51	418.62	420.36	15824.0
2024-04-05 08:30:00	MSFT	Stock	420.25	421.8199	418.5	420.9236	102352.0
2024-04-05 09:00:00	MSFT	Stock	420.96	421.41	419.31	419.76	13567.0
2024-04-05 09:30:00	MSFT	Stock	419.76	422.565	418.32	422.3	1371143.0
2024-04-05 10:00:00	MSFT	Stock	422.35	422.71	420.92	421.8	647611.0
2024-04-05 10:30:00	MSFT	Stock	421.83	424.0296	421.24	424.02	676911.0
2024-04-05 11:00:00	MSFT	Stock	424.03	424.5	422.86	424.44	458767.0
2024-04-05 11:30:00	MSFT	Stock	424.32	426.3	423.9672	425.68	555506.0
2024-04-05 12:00:00	MSFT	Stock	425.71	426.2	425.41	425.56	425617.0
2024-04-05 12:30:00	MSFT	Stock	425.6166	426.315	425.02	426.27	350835.0
2024-04-05 13:00:00	MSFT	Stock	426.27	426.49	425.08	425.65	323558.0
2024-04-05 13:30:00	MSFT	Stock	425.65	425.95	423.79	424.13	399558.0

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

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