PREVIEW / stock_1hour / 2025-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-08-25.parquet
  size:    1.4 MB
  rows:    63,064
  symbols: 330

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
2025-08-25 04:00:00	AAPL	Stock	227.9	227.9	226.99	226.99	25379.0
2025-08-25 05:00:00	AAPL	Stock	226.94	227.06	226.86	226.86	3932.0
2025-08-25 06:00:00	AAPL	Stock	227.0	227.05	226.74	226.89	3113.0
2025-08-25 07:00:00	AAPL	Stock	227.04	227.04	226.73	227.01	17668.0
2025-08-25 08:00:00	AAPL	Stock	227.56	227.97	226.2	226.93	159019.0
2025-08-25 09:00:00	AAPL	Stock	226.85	229.05	226.23	228.565	3762909.0
2025-08-25 10:00:00	AAPL	Stock	228.57	229.24	228.09	228.93	3846027.0
2025-08-25 11:00:00	AAPL	Stock	228.93	229.3	228.46	229.16	2321177.0
2025-08-25 12:00:00	AAPL	Stock	229.15	229.18	228.3477	228.505	1612030.0
2025-08-25 13:00:00	AAPL	Stock	228.505	228.76	228.265	228.3	1820726.0
2025-08-25 14:00:00	AAPL	Stock	228.31	228.3711	227.445	227.55	1956790.0
2025-08-25 15:00:00	AAPL	Stock	227.545	227.8358	227.12	227.15	3314972.0
2025-08-25 16:00:00	AAPL	Stock	227.18	227.412	227.03	227.27	3811455.0
2025-08-25 17:00:00	AAPL	Stock	227.23	227.27	227.07	227.1012	9645.0
2025-08-25 18:00:00	AAPL	Stock	227.16	227.37	227.16	227.21	6408.0
2025-08-25 19:00:00	AAPL	Stock	227.28	227.3	227.03	227.07	6065.0
2025-08-25 04:00:00	MSFT	Stock	506.72	507.5	506.72	507.05	4305.0
2025-08-25 05:00:00	MSFT	Stock	507.16	507.16	505.0	505.7	5802.0
2025-08-25 06:00:00	MSFT	Stock	505.62	505.9	505.4	505.84	2259.0
2025-08-25 07:00:00	MSFT	Stock	505.82	506.12	504.88	504.98	4603.0
2025-08-25 08:00:00	MSFT	Stock	505.82	507.3	504.7399	505.0	24008.0
2025-08-25 09:00:00	MSFT	Stock	504.9	508.15	503.7025	506.78	1172090.0
2025-08-25 10:00:00	MSFT	Stock	506.775	508.1799	506.05	507.375	839847.0
2025-08-25 11:00:00	MSFT	Stock	507.36	508.19	506.7	507.2	1172541.0
2025-08-25 12:00:00	MSFT	Stock	507.16	507.84	506.725	506.8268	661177.0
2025-08-25 13:00:00	MSFT	Stock	506.84	506.87	504.78	505.235	1071968.0
2025-08-25 14:00:00	MSFT	Stock	505.21	505.68	504.67	504.725	937060.0
2025-08-25 15:00:00	MSFT	Stock	504.72	505.475	504.12	504.46	1710442.0
2025-08-25 16:00:00	MSFT	Stock	504.26	504.9	504.01	504.31	2264012.0
2025-08-25 17:00:00	MSFT	Stock	504.3305	504.74	504.3305	504.51	1349.0
2025-08-25 18:00:00	MSFT	Stock	504.49	504.75	504.49	504.56	2748.0
2025-08-25 19:00:00	MSFT	Stock	504.51	504.62	504.26	504.26	6412.0
2025-08-25 04:00:00	NVDA	Stock	178.25	178.9	178.25	178.46	265754.0
2025-08-25 05:00:00	NVDA	Stock	178.48	178.5	178.01	178.36	152747.0
2025-08-25 06:00:00	NVDA	Stock	178.38	178.39	177.61	177.66	284873.0
2025-08-25 07:00:00	NVDA	Stock	177.67	178.31	177.23	178.29	398153.0
2025-08-25 08:00:00	NVDA	Stock	177.56	179.37	177.28	177.6	1575467.0
2025-08-25 09:00:00	NVDA	Stock	177.62	178.5	176.57	178.445	19506703.0
2025-08-25 10:00:00	NVDA	Stock	178.44	179.91	178.25	179.882	22974670.0
2025-08-25 11:00:00	NVDA	Stock	179.8799	181.68	179.87	181.57	22992423.0
2025-08-25 12:00:00	NVDA	Stock	181.57	181.91	180.93	181.025	13536113.0
2025-08-25 13:00:00	NVDA	Stock	181.03	181.385	180.62	181.29	11629988.0
2025-08-25 14:00:00	NVDA	Stock	181.29	181.56	181.08	181.4097	9183617.0
2025-08-25 15:00:00	NVDA	Stock	181.41	181.67	178.35	179.84	18875987.0
2025-08-25 16:00:00	NVDA	Stock	179.84	180.18	179.3	180.0	11370304.0
2025-08-25 17:00:00	NVDA	Stock	180.0	180.3	179.92	180.22	297135.0
2025-08-25 18:00:00	NVDA	Stock	180.2299	180.63	180.2	180.57	270873.0
2025-08-25 19:00:00	NVDA	Stock	180.58	180.58	180.2	180.2985	238001.0
2025-08-25 04:00:00	AMZN	Stock	228.88	228.88	227.58	227.58	20150.0
2025-08-25 05:00:00	AMZN	Stock	227.56	227.68	227.35	227.63	5665.0

> showing 50 of 63,064 rows — these rows as CSV

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