PREVIEW / stock_1hour / 2025-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-11-17.parquet
  size:    1.4 MB
  rows:    61,493
  symbols: 211

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-11-17 04:00:00	AAPL	Stock	272.89	272.89	271.6	271.65	24539.0
2025-11-17 05:00:00	AAPL	Stock	271.55	271.7	271.03	271.23	11868.0
2025-11-17 06:00:00	AAPL	Stock	271.2	271.73	270.2	270.5	23539.0
2025-11-17 07:00:00	AAPL	Stock	270.5	270.5	269.3	269.95	40140.0
2025-11-17 08:00:00	AAPL	Stock	270.1	273.0	268.88	269.69	192565.0
2025-11-17 09:00:00	AAPL	Stock	269.7	270.49	267.0	270.04	5206357.0
2025-11-17 10:00:00	AAPL	Stock	270.01	270.32	267.76	268.0	3259629.0
2025-11-17 11:00:00	AAPL	Stock	268.0	269.55	266.65	269.52	2781319.0
2025-11-17 12:00:00	AAPL	Stock	269.51	269.52	267.87	267.885	1675694.0
2025-11-17 13:00:00	AAPL	Stock	267.93	268.35	267.17	267.28	1612011.0
2025-11-17 14:00:00	AAPL	Stock	267.27	267.505	265.844	265.86	2033257.0
2025-11-17 15:00:00	AAPL	Stock	265.84	267.59	265.73	267.46	4960239.0
2025-11-17 16:00:00	AAPL	Stock	267.501	268.33	267.45	267.49	8658098.0
2025-11-17 17:00:00	AAPL	Stock	267.9799	267.9799	267.1936	267.2072	12935.0
2025-11-17 18:00:00	AAPL	Stock	267.46	268.0	267.2535	267.67	19029.0
2025-11-17 19:00:00	AAPL	Stock	267.68	267.9	267.06	267.69	35014.0
2025-11-17 04:00:00	MSFT	Stock	511.96	512.61	510.61	510.61	7547.0
2025-11-17 05:00:00	MSFT	Stock	510.6	510.71	508.57	508.57	7189.0
2025-11-17 06:00:00	MSFT	Stock	508.56	510.18	508.56	509.69	2027.0
2025-11-17 07:00:00	MSFT	Stock	509.66	509.81	508.8	508.85	10118.0
2025-11-17 08:00:00	MSFT	Stock	509.6	513.0	507.5	508.16	52823.0
2025-11-17 09:00:00	MSFT	Stock	508.43	512.12	506.05	508.96	1903074.0
2025-11-17 10:00:00	MSFT	Stock	508.92	509.39	506.5845	507.625	1262624.0
2025-11-17 11:00:00	MSFT	Stock	507.57	510.25	505.6	510.185	897311.0
2025-11-17 12:00:00	MSFT	Stock	510.24	510.82	508.17	508.235	774125.0
2025-11-17 13:00:00	MSFT	Stock	508.235	509.2	506.53	506.56	559104.0
2025-11-17 14:00:00	MSFT	Stock	506.55	507.26	505.26	505.315	808277.0
2025-11-17 15:00:00	MSFT	Stock	505.26	507.75	504.91	507.49	2038708.0
2025-11-17 16:00:00	MSFT	Stock	507.49	508.5	507.49	508.28	4399312.0
2025-11-17 17:00:00	MSFT	Stock	508.3	508.3	507.49	507.61	8578.0
2025-11-17 18:00:00	MSFT	Stock	507.75	508.52	507.0	507.7	6971.0
2025-11-17 19:00:00	MSFT	Stock	507.51	508.48	506.36	507.0064	10414.0
2025-11-17 04:00:00	NVDA	Stock	192.16	192.33	191.08	191.15	178593.0
2025-11-17 05:00:00	NVDA	Stock	191.15	191.23	188.56	189.48	276443.0
2025-11-17 06:00:00	NVDA	Stock	189.39	189.88	188.7	189.4	221205.0
2025-11-17 07:00:00	NVDA	Stock	189.4	189.6	187.69	188.1	605374.0
2025-11-17 08:00:00	NVDA	Stock	189.46	192.44	186.55	187.71	2584990.0
2025-11-17 09:00:00	NVDA	Stock	187.66	189.0	184.92	188.0922	19587604.0
2025-11-17 10:00:00	NVDA	Stock	188.085	188.4782	186.15	187.22	17703203.0
2025-11-17 11:00:00	NVDA	Stock	187.23	188.3	185.74	188.21	17092333.0
2025-11-17 12:00:00	NVDA	Stock	188.21	188.24	186.51	186.55	10109560.0
2025-11-17 13:00:00	NVDA	Stock	186.57	187.55	185.58	185.825	10920698.0
2025-11-17 14:00:00	NVDA	Stock	185.81	185.97	184.4201	184.71	13231298.0
2025-11-17 15:00:00	NVDA	Stock	184.7	186.8	184.32	186.59	20693070.0
2025-11-17 16:00:00	NVDA	Stock	186.59	187.1878	186.24	186.55	15102876.0
2025-11-17 17:00:00	NVDA	Stock	186.58	186.83	186.01	186.12	185783.0
2025-11-17 18:00:00	NVDA	Stock	186.13	186.72	186.01	186.1422	257033.0
2025-11-17 19:00:00	NVDA	Stock	186.1016	186.3287	184.911	185.3299	492001.0
2025-11-17 04:00:00	AMZN	Stock	237.6	238.0	237.0	237.45	67272.0
2025-11-17 05:00:00	AMZN	Stock	237.46	237.54	236.4	236.69	25124.0

> showing 50 of 61,493 rows — these rows as CSV

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