PREVIEW / stock_1hour / 2025-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-10-23.parquet
  size:    1.4 MB
  rows:    63,557
  symbols: 224

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-10-23 04:00:00	AAPL	Stock	259.61	259.67	259.07	259.11	9548.0
2025-10-23 05:00:00	AAPL	Stock	259.11	259.12	258.8	258.98	2826.0
2025-10-23 06:00:00	AAPL	Stock	259.26	259.65	259.1	259.29	9396.0
2025-10-23 07:00:00	AAPL	Stock	259.23	259.23	257.64	257.86	24298.0
2025-10-23 08:00:00	AAPL	Stock	258.88	259.79	257.5527	258.8	96154.0
2025-10-23 09:00:00	AAPL	Stock	258.79	260.1799	258.0101	258.35	2943587.0
2025-10-23 10:00:00	AAPL	Stock	258.36	259.66	258.12	259.6222	2713161.0
2025-10-23 11:00:00	AAPL	Stock	259.61	260.55	258.95	260.25	2555746.0
2025-10-23 12:00:00	AAPL	Stock	260.22	260.62	259.92	260.25	1651867.0
2025-10-23 13:00:00	AAPL	Stock	260.27	260.55	259.52	260.19	1858256.0
2025-10-23 14:00:00	AAPL	Stock	260.22	260.42	259.65	259.85	1484377.0
2025-10-23 15:00:00	AAPL	Stock	259.86	260.05	259.08	259.58	3168598.0
2025-10-23 16:00:00	AAPL	Stock	259.58	260.17	259.0431	259.3	6203182.0
2025-10-23 17:00:00	AAPL	Stock	259.3	259.7	259.1575	259.5	18834.0
2025-10-23 18:00:00	AAPL	Stock	259.7	259.89	259.42	259.65	3340.0
2025-10-23 19:00:00	AAPL	Stock	259.8	259.8	259.15	259.53	24200.0
2025-10-23 04:00:00	MSFT	Stock	522.33	522.33	521.9	521.9	849.0
2025-10-23 05:00:00	MSFT	Stock	522.04	522.04	521.47	521.93	1157.0
2025-10-23 06:00:00	MSFT	Stock	522.27	522.27	521.79	522.03	457.0
2025-10-23 07:00:00	MSFT	Stock	521.88	521.88	521.0	521.0	2905.0
2025-10-23 08:00:00	MSFT	Stock	521.5	522.26	520.63	521.8	14625.0
2025-10-23 09:00:00	MSFT	Stock	522.0	523.2	518.61	521.9	1123744.0
2025-10-23 10:00:00	MSFT	Stock	521.68	523.235	520.7	522.6335	1001565.0
2025-10-23 11:00:00	MSFT	Stock	522.705	523.63	521.45	522.4672	712165.0
2025-10-23 12:00:00	MSFT	Stock	522.51	523.95	522.02	522.41	516018.0
2025-10-23 13:00:00	MSFT	Stock	522.34	523.12	521.63	522.855	479505.0
2025-10-23 14:00:00	MSFT	Stock	522.855	523.62	522.71	523.13	518473.0
2025-10-23 15:00:00	MSFT	Stock	523.15	523.21	520.1	520.59	1417299.0
2025-10-23 16:00:00	MSFT	Stock	520.638	521.48	520.1	520.7	2679735.0
2025-10-23 17:00:00	MSFT	Stock	520.56	520.99	520.38	520.99	50383.0
2025-10-23 18:00:00	MSFT	Stock	520.95	520.95	520.56	520.88	2443.0
2025-10-23 19:00:00	MSFT	Stock	520.88	521.19	520.76	521.14	2675.0
2025-10-23 04:00:00	NVDA	Stock	180.61	180.98	180.28	180.78	119755.0
2025-10-23 05:00:00	NVDA	Stock	180.79	180.79	180.09	180.55	111701.0
2025-10-23 06:00:00	NVDA	Stock	180.58	180.67	180.15	180.3	80802.0
2025-10-23 07:00:00	NVDA	Stock	180.33	180.33	179.6	179.66	178811.0
2025-10-23 08:00:00	NVDA	Stock	180.3	180.98	179.22	179.91	895310.0
2025-10-23 09:00:00	NVDA	Stock	179.87	181.605	179.0	181.335	14574247.0
2025-10-23 10:00:00	NVDA	Stock	181.35	182.325	180.62	182.295	16122061.0
2025-10-23 11:00:00	NVDA	Stock	182.295	182.5	181.35	182.12	11198689.0
2025-10-23 12:00:00	NVDA	Stock	182.11	182.28	181.68	182.01	6107697.0
2025-10-23 13:00:00	NVDA	Stock	182.01	182.67	181.5	182.52	7888696.0
2025-10-23 14:00:00	NVDA	Stock	182.53	183.02	182.255	182.935	7679037.0
2025-10-23 15:00:00	NVDA	Stock	182.94	183.03	181.38	182.2	11042615.0
2025-10-23 16:00:00	NVDA	Stock	182.21	182.62	182.05	182.46	9325874.0
2025-10-23 17:00:00	NVDA	Stock	182.47	182.5	182.0	182.18	311576.0
2025-10-23 18:00:00	NVDA	Stock	182.18	182.29	182.173	182.22	88203.0
2025-10-23 19:00:00	NVDA	Stock	182.2107	182.33	182.1716	182.33	158740.0
2025-10-23 04:00:00	AMZN	Stock	219.2	219.67	219.2	219.31	11515.0
2025-10-23 05:00:00	AMZN	Stock	219.22	219.6	219.0	219.07	16006.0

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

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