PREVIEW / stock_1hour / 2025-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-07-17.parquet
  size:    1.5 MB
  rows:    63,807
  symbols: 371

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-07-17 04:00:00	AAPL	Stock	210.5	210.64	210.15	210.54	24735.0
2025-07-17 05:00:00	AAPL	Stock	210.63	210.86	210.62	210.68	6709.0
2025-07-17 06:00:00	AAPL	Stock	210.69	210.8	210.0	210.4	12880.0
2025-07-17 07:00:00	AAPL	Stock	210.33	210.5	210.25	210.49	11471.0
2025-07-17 08:00:00	AAPL	Stock	210.33	211.09	209.635	211.0	150134.0
2025-07-17 09:00:00	AAPL	Stock	211.05	211.3	209.975	210.28	4002514.0
2025-07-17 10:00:00	AAPL	Stock	210.27	210.6	209.59	210.175	3925449.0
2025-07-17 11:00:00	AAPL	Stock	210.175	210.83	210.0817	210.6501	3590525.0
2025-07-17 12:00:00	AAPL	Stock	210.66	211.51	210.535	211.02	4433578.0
2025-07-17 13:00:00	AAPL	Stock	211.01	211.5	210.79	211.4885	2533549.0
2025-07-17 14:00:00	AAPL	Stock	211.485	211.8	210.87	210.935	3570621.0
2025-07-17 15:00:00	AAPL	Stock	210.94	211.065	209.74	210.061	7030182.0
2025-07-17 16:00:00	AAPL	Stock	210.02	210.46	210.02	210.2165	5956313.0
2025-07-17 17:00:00	AAPL	Stock	210.3	210.4	210.02	210.2	30824.0
2025-07-17 18:00:00	AAPL	Stock	210.13	210.25	210.12	210.12	17303.0
2025-07-17 19:00:00	AAPL	Stock	210.1147	210.3	210.1147	210.2395	29128.0
2025-07-17 04:00:00	MSFT	Stock	506.18	506.39	505.5	505.51	1517.0
2025-07-17 05:00:00	MSFT	Stock	505.35	505.51	505.35	505.45	1150.0
2025-07-17 06:00:00	MSFT	Stock	505.12	505.12	504.97	504.97	400.0
2025-07-17 07:00:00	MSFT	Stock	504.8	505.39	504.8	505.33	1148.0
2025-07-17 08:00:00	MSFT	Stock	505.39	506.9	504.3	506.33	22956.0
2025-07-17 09:00:00	MSFT	Stock	506.8	510.27	504.9	509.76	1332586.0
2025-07-17 10:00:00	MSFT	Stock	509.8	511.48	508.943	511.22	1370263.0
2025-07-17 11:00:00	MSFT	Stock	511.26	513.0	511.18	512.95	1164320.0
2025-07-17 12:00:00	MSFT	Stock	512.95	513.37	512.62	512.785	666217.0
2025-07-17 13:00:00	MSFT	Stock	512.785	513.0	512.3	512.77	688908.0
2025-07-17 14:00:00	MSFT	Stock	512.785	512.9175	511.54	511.59	625803.0
2025-07-17 15:00:00	MSFT	Stock	511.59	512.6022	511.0	511.88	2057155.0
2025-07-17 16:00:00	MSFT	Stock	511.7	512.29	511.57	511.7	2623528.0
2025-07-17 17:00:00	MSFT	Stock	511.7	512.29	511.7	512.0	11267.0
2025-07-17 18:00:00	MSFT	Stock	512.0	512.09	511.75	511.87	3168.0
2025-07-17 19:00:00	MSFT	Stock	511.95	513.0	511.95	512.77	4001.0
2025-07-17 04:00:00	NVDA	Stock	172.65	173.2	171.77	172.93	562833.0
2025-07-17 05:00:00	NVDA	Stock	172.95	173.1	172.6	172.74	212633.0
2025-07-17 06:00:00	NVDA	Stock	172.74	172.87	172.44	172.44	224626.0
2025-07-17 07:00:00	NVDA	Stock	172.42	172.56	172.17	172.55	391813.0
2025-07-17 08:00:00	NVDA	Stock	172.32	173.46	171.18	172.77	2614739.0
2025-07-17 09:00:00	NVDA	Stock	172.76	173.44	170.83	173.175	26352680.0
2025-07-17 10:00:00	NVDA	Stock	173.175	173.6402	172.53	172.805	20924964.0
2025-07-17 11:00:00	NVDA	Stock	172.815	173.55	172.77	173.375	14116872.0
2025-07-17 12:00:00	NVDA	Stock	173.375	174.16	173.27	173.61	16825199.0
2025-07-17 13:00:00	NVDA	Stock	173.61	173.98	173.08	173.312	11579262.0
2025-07-17 14:00:00	NVDA	Stock	173.32	173.6885	173.0901	173.465	9388132.0
2025-07-17 15:00:00	NVDA	Stock	173.47	173.63	173.0	173.1114	16997776.0
2025-07-17 16:00:00	NVDA	Stock	173.11	173.2	173.0	173.15	11162965.0
2025-07-17 17:00:00	NVDA	Stock	173.17	173.26	173.0	173.13	242627.0
2025-07-17 18:00:00	NVDA	Stock	173.13	173.24	173.11	173.18	111193.0
2025-07-17 19:00:00	NVDA	Stock	173.17	173.5	173.17	173.4612	248032.0
2025-07-17 04:00:00	AMZN	Stock	223.81	223.86	223.58	223.84	11915.0
2025-07-17 05:00:00	AMZN	Stock	223.8	223.99	223.8	223.95	6402.0

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

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