PREVIEW / stock_1hour / 2026-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-07-24.parquet
  size:    1.3 MB
  rows:    57,528

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
2026-07-24 04:00:00	AAPL	Stock	321.07	322.82	319.83	322.01	64142.0
2026-07-24 05:00:00	AAPL	Stock	322.07	322.7	321.61	322.3596	17323.0
2026-07-24 06:00:00	AAPL	Stock	322.32	322.69	321.93	322.6	9403.0
2026-07-24 07:00:00	AAPL	Stock	322.33	322.9668	322.15	322.52	17603.0
2026-07-24 08:00:00	AAPL	Stock	322.81	322.81	321.55	321.8003	23460.0
2026-07-24 09:00:00	AAPL	Stock	321.72	327.76	321.55	326.86	4024534.0
2026-07-24 10:00:00	AAPL	Stock	326.86	330.23	326.786	329.965	5598591.0
2026-07-24 11:00:00	AAPL	Stock	329.96	333.64	329.71	333.05	5571444.0
2026-07-24 12:00:00	AAPL	Stock	333.02	334.37	332.66	333.182	4041395.0
2026-07-24 13:00:00	AAPL	Stock	333.19	334.22	332.1505	332.65	2936386.0
2026-07-24 14:00:00	AAPL	Stock	332.645	333.18	332.06	332.93	2732725.0
2026-07-24 15:00:00	AAPL	Stock	332.96	333.45	331.85	333.07	5535021.0
2026-07-24 16:00:00	AAPL	Stock	333.06	333.6999	332.4	333.58	6531521.0
2026-07-24 17:00:00	AAPL	Stock	333.41	333.88	333.3305	333.79	29569.0
2026-07-24 18:00:00	AAPL	Stock	333.85	333.85	333.39	333.4183	16621.0
2026-07-24 19:00:00	AAPL	Stock	333.4215	333.843	333.42	333.8	21276.0
2026-07-24 04:00:00	MSFT	Stock	383.95	385.88	381.16	385.52	65062.0
2026-07-24 05:00:00	MSFT	Stock	385.5	386.5	385.0	385.88	14925.0
2026-07-24 06:00:00	MSFT	Stock	385.81	385.89	385.0	385.48	16849.0
2026-07-24 07:00:00	MSFT	Stock	385.07	386.66	385.0	386.19	36064.0
2026-07-24 08:00:00	MSFT	Stock	386.15	386.63	385.66	385.71	44898.0
2026-07-24 09:00:00	MSFT	Stock	385.7	389.03	380.65	381.26	3219194.0
2026-07-24 10:00:00	MSFT	Stock	381.26	384.5	380.8	384.205	3281524.0
2026-07-24 11:00:00	MSFT	Stock	384.21	386.03	383.48	383.925	2309445.0
2026-07-24 12:00:00	MSFT	Stock	383.9	385.33	383.83	383.95	1259789.0
2026-07-24 13:00:00	MSFT	Stock	383.975	384.925	383.55	384.715	1167126.0
2026-07-24 14:00:00	MSFT	Stock	384.73	384.95	383.63	384.55	1323162.0
2026-07-24 15:00:00	MSFT	Stock	384.58	384.79	381.42	381.74	3623546.0
2026-07-24 16:00:00	MSFT	Stock	381.7	381.99	380.74	381.6	4098039.0
2026-07-24 17:00:00	MSFT	Stock	381.6	381.9	381.04	381.87	21401.0
2026-07-24 18:00:00	MSFT	Stock	381.77	381.89	381.5	381.84	18030.0
2026-07-24 19:00:00	MSFT	Stock	381.7	381.79	381.31	381.4	15219.0
2026-07-24 04:00:00	NVDA	Stock	207.6	207.8313	206.12	207.44	224828.0
2026-07-24 05:00:00	NVDA	Stock	207.46	208.5	207.46	208.32	28716.0
2026-07-24 06:00:00	NVDA	Stock	208.3	208.3178	207.71	208.05	27994.0
2026-07-24 07:00:00	NVDA	Stock	207.93	208.74	207.8993	208.66	141619.0
2026-07-24 08:00:00	NVDA	Stock	208.52	208.98	207.89	207.98	193424.0
2026-07-24 09:00:00	NVDA	Stock	208.0	208.6	205.67	206.2839	8077329.0
2026-07-24 10:00:00	NVDA	Stock	206.29	209.58	206.2	209.495	11143410.0
2026-07-24 11:00:00	NVDA	Stock	209.52	210.36	208.59	210.181	9090679.0
2026-07-24 12:00:00	NVDA	Stock	210.185	211.9099	209.76	210.22	8342223.0
2026-07-24 13:00:00	NVDA	Stock	210.24	210.53	209.52	209.7	5206204.0
2026-07-24 14:00:00	NVDA	Stock	209.7	209.91	206.02	206.27	8981680.0
2026-07-24 15:00:00	NVDA	Stock	206.27	207.4	204.81	206.96	15824275.0
2026-07-24 16:00:00	NVDA	Stock	206.98	207.25	206.5	207.0	13426069.0
2026-07-24 17:00:00	NVDA	Stock	207.0	207.1	206.7077	206.9	92443.0
2026-07-24 18:00:00	NVDA	Stock	206.905	206.99	206.63	206.72	59689.0
2026-07-24 19:00:00	NVDA	Stock	206.71	206.8135	206.5	206.7999	88579.0
2026-07-24 04:00:00	AMZN	Stock	234.5	234.83	233.28	234.8139	52273.0
2026-07-24 05:00:00	AMZN	Stock	234.82	235.5	234.6	234.9109	19002.0

> showing 50 of 57,528 rows — these rows as CSV

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