PREVIEW / stock_30min / 2024-04-23

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-04-23.parquet
  size:    2.0 MB
  rows:    96,889
  symbols: 979

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-23 04:00:00	AAPL	Stock	165.8	165.8	165.0	165.53	20228.0
2024-04-23 04:30:00	AAPL	Stock	165.5	165.5	165.01	165.05	21180.0
2024-04-23 05:00:00	AAPL	Stock	165.03	165.67	165.03	165.3	26503.0
2024-04-23 05:30:00	AAPL	Stock	165.39	165.39	165.13	165.29	6149.0
2024-04-23 06:00:00	AAPL	Stock	165.31	165.31	165.18	165.18	8157.0
2024-04-23 06:30:00	AAPL	Stock	165.18	165.6	165.1	165.5	17057.0
2024-04-23 07:00:00	AAPL	Stock	165.55	165.87	165.2	165.2	23437.0
2024-04-23 07:30:00	AAPL	Stock	165.21	166.25	165.18	165.6	47492.0
2024-04-23 08:00:00	AAPL	Stock	165.7	166.14	164.81	165.4	86621.0
2024-04-23 08:30:00	AAPL	Stock	165.4	166.1	165.2709	166.1	54899.0
2024-04-23 09:00:00	AAPL	Stock	166.02	166.0872	165.27	165.31	83467.0
2024-04-23 09:30:00	AAPL	Stock	165.31	166.58	164.92	166.16	4603059.0
2024-04-23 10:00:00	AAPL	Stock	166.12	166.71	165.62	165.82	3892754.0
2024-04-23 10:30:00	AAPL	Stock	165.82	166.63	165.82	166.54	2346302.0
2024-04-23 11:00:00	AAPL	Stock	166.55	166.98	166.36	166.625	2037697.0
2024-04-23 11:30:00	AAPL	Stock	166.62	166.7	166.245	166.359	1631264.0
2024-04-23 12:00:00	AAPL	Stock	166.36	166.39	166.0574	166.27	1504589.0
2024-04-23 12:30:00	AAPL	Stock	166.27	166.64	166.22	166.453	1785648.0
2024-04-23 13:00:00	AAPL	Stock	166.4599	166.63	166.17	166.392	1094554.0
2024-04-23 13:30:00	AAPL	Stock	166.395	166.77	166.325	166.75	1194643.0
2024-04-23 14:00:00	AAPL	Stock	166.76	166.86	166.67	166.84	1143452.0
2024-04-23 14:30:00	AAPL	Stock	166.84	166.8668	166.66	166.78	1377804.0
2024-04-23 15:00:00	AAPL	Stock	166.78	166.8699	166.5	166.84	1629352.0
2024-04-23 15:30:00	AAPL	Stock	166.84	167.05	166.755	166.91	4937974.0
2024-04-23 16:00:00	AAPL	Stock	166.9	167.08	166.75	167.0398	6658251.0
2024-04-23 16:30:00	AAPL	Stock	167.01	167.11	166.82	167.05	102403.0
2024-04-23 17:00:00	AAPL	Stock	167.03	167.26	166.99	167.07	56737.0
2024-04-23 17:30:00	AAPL	Stock	167.2	167.22	166.85	167.18	43031.0
2024-04-23 18:00:00	AAPL	Stock	167.01	167.01	166.55	166.61	60862.0
2024-04-23 18:30:00	AAPL	Stock	166.57	166.9	166.57	166.8	29906.0
2024-04-23 19:00:00	AAPL	Stock	166.76	166.9	166.75	166.76	11298.0
2024-04-23 19:30:00	AAPL	Stock	166.78	167.16	166.49	166.94	52874.0
2024-04-23 04:00:00	MSFT	Stock	401.35	402.92	401.35	402.92	917.0
2024-04-23 04:30:00	MSFT	Stock	402.6	402.6	402.51	402.51	339.0
2024-04-23 05:00:00	MSFT	Stock	402.26	402.52	402.26	402.48	325.0
2024-04-23 05:30:00	MSFT	Stock	402.13	402.13	402.13	402.13	100.0
2024-04-23 06:00:00	MSFT	Stock	402.31	402.47	402.1	402.23	2216.0
2024-04-23 06:30:00	MSFT	Stock	402.47	402.61	402.47	402.61	736.0
2024-04-23 07:00:00	MSFT	Stock	402.75	403.13	402.75	403.0	6173.0
2024-04-23 07:30:00	MSFT	Stock	402.79	403.0	402.58	402.7	7712.0
2024-04-23 08:00:00	MSFT	Stock	402.9799	403.28	401.71	402.48	19070.0
2024-04-23 08:30:00	MSFT	Stock	402.7	403.7	402.68	403.56	18179.0
2024-04-23 09:00:00	MSFT	Stock	403.7	404.87	400.96	404.19	37027.0
2024-04-23 09:30:00	MSFT	Stock	404.23	406.16	403.06	405.945	1282593.0
2024-04-23 10:00:00	MSFT	Stock	406.01	407.8	405.6	407.36	867099.0
2024-04-23 10:30:00	MSFT	Stock	407.35	408.2	406.68	407.45	579017.0
2024-04-23 11:00:00	MSFT	Stock	407.46	407.71	405.81	406.58	443732.0
2024-04-23 11:30:00	MSFT	Stock	406.6	407.18	406.18	406.61	387394.0
2024-04-23 12:00:00	MSFT	Stock	406.64	407.69	406.195	407.4	349810.0
2024-04-23 12:30:00	MSFT	Stock	407.39	407.47	406.721	407.185	285742.0

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

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