PREVIEW / stock_1hour / 2025-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-09-23.parquet
  size:    1.5 MB
  rows:    64,794
  symbols: 307

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-09-23 04:00:00	AAPL	Stock	256.68	256.68	255.09	255.1	31726.0
2025-09-23 05:00:00	AAPL	Stock	255.05	255.8	254.94	255.65	15738.0
2025-09-23 06:00:00	AAPL	Stock	255.65	255.65	255.09	255.3	10221.0
2025-09-23 07:00:00	AAPL	Stock	255.28	255.47	254.62	255.08	54443.0
2025-09-23 08:00:00	AAPL	Stock	256.41	256.75	254.6	255.03	232092.0
2025-09-23 09:00:00	AAPL	Stock	255.03	257.34	254.75	256.2	7466142.0
2025-09-23 10:00:00	AAPL	Stock	256.21	257.0	255.0	255.29	6983950.0
2025-09-23 11:00:00	AAPL	Stock	255.31	256.38	255.22	255.9656	4048276.0
2025-09-23 12:00:00	AAPL	Stock	255.965	256.21	254.68	255.093	2729941.0
2025-09-23 13:00:00	AAPL	Stock	255.08	255.23	253.93	254.3276	3836124.0
2025-09-23 14:00:00	AAPL	Stock	254.335	254.961	253.97	254.125	3267219.0
2025-09-23 15:00:00	AAPL	Stock	254.12	254.53	253.58	254.53	5580337.0
2025-09-23 16:00:00	AAPL	Stock	254.43	254.65	254.2	254.33	8336235.0
2025-09-23 17:00:00	AAPL	Stock	254.4	254.41	254.21	254.26	8569.0
2025-09-23 18:00:00	AAPL	Stock	254.28	254.49	254.1542	254.35	18190.0
2025-09-23 19:00:00	AAPL	Stock	254.28	254.35	253.95	254.18	17892.0
2025-09-23 04:00:00	MSFT	Stock	515.75	516.5	515.66	515.78	2826.0
2025-09-23 05:00:00	MSFT	Stock	515.35	515.65	515.3	515.5	5743.0
2025-09-23 06:00:00	MSFT	Stock	515.01	515.01	514.46	514.7	1500.0
2025-09-23 07:00:00	MSFT	Stock	514.7	514.95	514.5	514.83	7297.0
2025-09-23 08:00:00	MSFT	Stock	514.9	516.3	514.45	515.49	26698.0
2025-09-23 09:00:00	MSFT	Stock	515.5	515.74	510.375	511.75	1343002.0
2025-09-23 10:00:00	MSFT	Stock	511.68	513.0632	510.85	511.07	1151645.0
2025-09-23 11:00:00	MSFT	Stock	511.12	511.425	509.84	510.37	960810.0
2025-09-23 12:00:00	MSFT	Stock	510.37	511.37	510.0654	510.43	589188.0
2025-09-23 13:00:00	MSFT	Stock	510.43	510.54	508.8901	509.8701	976640.0
2025-09-23 14:00:00	MSFT	Stock	509.9	510.5899	508.58	508.765	877944.0
2025-09-23 15:00:00	MSFT	Stock	508.765	509.9	507.31	509.62	1664222.0
2025-09-23 16:00:00	MSFT	Stock	509.61	509.9169	509.0	509.3	4544421.0
2025-09-23 17:00:00	MSFT	Stock	509.34	510.2	509.3	510.165	4730.0
2025-09-23 18:00:00	MSFT	Stock	510.21	510.5	509.81	509.88	2089.0
2025-09-23 19:00:00	MSFT	Stock	509.82	510.0	509.56	509.75	2422.0
2025-09-23 04:00:00	NVDA	Stock	182.62	183.0	182.15	182.17	487535.0
2025-09-23 05:00:00	NVDA	Stock	182.18	182.53	181.78	182.425	413643.0
2025-09-23 06:00:00	NVDA	Stock	182.44	182.57	182.09	182.18	315866.0
2025-09-23 07:00:00	NVDA	Stock	182.17	182.26	181.36	182.0	794341.0
2025-09-23 08:00:00	NVDA	Stock	182.02	183.61	181.39	181.98	2421159.0
2025-09-23 09:00:00	NVDA	Stock	181.98	182.42	179.35	179.565	28210854.0
2025-09-23 10:00:00	NVDA	Stock	179.57	180.8199	179.145	179.845	25678376.0
2025-09-23 11:00:00	NVDA	Stock	179.85	180.55	179.67	179.96	12346815.0
2025-09-23 12:00:00	NVDA	Stock	179.965	180.14	178.84	179.1901	15268497.0
2025-09-23 13:00:00	NVDA	Stock	179.1951	179.36	177.3	178.255	19723753.0
2025-09-23 14:00:00	NVDA	Stock	178.26	178.3874	177.445	178.145	12045894.0
2025-09-23 15:00:00	NVDA	Stock	178.145	178.92	176.21	178.44	18290981.0
2025-09-23 16:00:00	NVDA	Stock	178.45	178.75	177.8	178.2999	16132536.0
2025-09-23 17:00:00	NVDA	Stock	178.2806	179.25	178.12	178.15	910584.0
2025-09-23 18:00:00	NVDA	Stock	178.17	178.4	178.12	178.13	287894.0
2025-09-23 19:00:00	NVDA	Stock	178.1217	178.26	177.8	177.92	314302.0
2025-09-23 04:00:00	AMZN	Stock	228.59	228.73	228.31	228.51	25376.0
2025-09-23 05:00:00	AMZN	Stock	228.6	228.7	228.38	228.5	7931.0

> showing 50 of 64,794 rows — these rows as CSV

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