PREVIEW / stock_1hour / 2025-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-09-09.parquet
  size:    1.5 MB
  rows:    64,567
  symbols: 312

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-09 04:00:00	AAPL	Stock	237.87	238.08	237.1	237.14	11206.0
2025-09-09 05:00:00	AAPL	Stock	237.15	237.3	236.65	236.96	39861.0
2025-09-09 06:00:00	AAPL	Stock	236.95	237.07	236.94	237.05	10589.0
2025-09-09 07:00:00	AAPL	Stock	237.15	237.3	236.89	237.3	15532.0
2025-09-09 08:00:00	AAPL	Stock	237.02	238.35	236.69	237.73	117421.0
2025-09-09 09:00:00	AAPL	Stock	237.64	238.0	236.22	236.8	3806950.0
2025-09-09 10:00:00	AAPL	Stock	236.83	236.91	235.78	236.545	3827856.0
2025-09-09 11:00:00	AAPL	Stock	236.545	236.69	235.55	235.68	2580300.0
2025-09-09 12:00:00	AAPL	Stock	235.68	236.67	235.56	236.6196	2948284.0
2025-09-09 13:00:00	AAPL	Stock	236.62	238.7805	236.32	236.53	11585508.0
2025-09-09 14:00:00	AAPL	Stock	236.54	236.7899	233.36	233.7399	12439831.0
2025-09-09 15:00:00	AAPL	Stock	233.74	234.635	233.515	234.35	8176094.0
2025-09-09 16:00:00	AAPL	Stock	234.34	234.4	233.0	233.18	5144063.0
2025-09-09 17:00:00	AAPL	Stock	233.2016	233.3	233.01	233.16	134393.0
2025-09-09 18:00:00	AAPL	Stock	233.15	233.86	233.04	233.6	82363.0
2025-09-09 19:00:00	AAPL	Stock	233.57	233.75	233.335	233.54	70407.0
2025-09-09 04:00:00	MSFT	Stock	500.4	500.79	500.0	500.0	3607.0
2025-09-09 05:00:00	MSFT	Stock	500.11	500.12	499.36	499.5	5656.0
2025-09-09 06:00:00	MSFT	Stock	500.4	500.4	500.0	500.0	653.0
2025-09-09 07:00:00	MSFT	Stock	500.0	500.37	499.77	500.25	4894.0
2025-09-09 08:00:00	MSFT	Stock	500.37	501.15	499.4	500.66	19601.0
2025-09-09 09:00:00	MSFT	Stock	500.47	502.095	500.0727	501.01	1173655.0
2025-09-09 10:00:00	MSFT	Stock	501.01	502.25	498.8	499.75	1098075.0
2025-09-09 11:00:00	MSFT	Stock	499.73	500.25	498.7127	499.46	518857.0
2025-09-09 12:00:00	MSFT	Stock	499.4	499.66	498.25	498.84	906359.0
2025-09-09 13:00:00	MSFT	Stock	498.82	499.61	498.5	498.92	657282.0
2025-09-09 14:00:00	MSFT	Stock	498.92	499.415	498.302	499.0	1111202.0
2025-09-09 15:00:00	MSFT	Stock	499.0	499.015	497.7	498.45	1616767.0
2025-09-09 16:00:00	MSFT	Stock	498.41	501.0898	497.0	500.75	1864737.0
2025-09-09 17:00:00	MSFT	Stock	500.72	501.75	500.07	500.6713	52103.0
2025-09-09 18:00:00	MSFT	Stock	500.34	500.57	500.0	500.1	10553.0
2025-09-09 19:00:00	MSFT	Stock	500.2	500.2	498.0	498.45	32375.0
2025-09-09 04:00:00	NVDA	Stock	169.2	169.98	168.79	169.85	314895.0
2025-09-09 05:00:00	NVDA	Stock	169.85	169.97	169.51	169.51	133241.0
2025-09-09 06:00:00	NVDA	Stock	169.54	169.81	169.42	169.52	121048.0
2025-09-09 07:00:00	NVDA	Stock	169.54	169.55	168.49	169.03	310875.0
2025-09-09 08:00:00	NVDA	Stock	168.8	169.97	168.23	169.0501	1137069.0
2025-09-09 09:00:00	NVDA	Stock	169.0597	169.64	167.94	168.38	17188862.0
2025-09-09 10:00:00	NVDA	Stock	168.38	168.74	166.7401	167.405	23141320.0
2025-09-09 11:00:00	NVDA	Stock	167.405	168.36	167.2226	168.09	12140408.0
2025-09-09 12:00:00	NVDA	Stock	168.09	168.93	168.0401	168.25	10174334.0
2025-09-09 13:00:00	NVDA	Stock	168.26	168.46	167.845	168.085	9147630.0
2025-09-09 14:00:00	NVDA	Stock	168.085	169.05	167.96	169.035	9375171.0
2025-09-09 15:00:00	NVDA	Stock	169.04	170.98	169.0101	170.7585	24958975.0
2025-09-09 16:00:00	NVDA	Stock	170.76	174.77	170.62	173.45	15436852.0
2025-09-09 17:00:00	NVDA	Stock	173.42	174.49	173.24	174.0	1496750.0
2025-09-09 18:00:00	NVDA	Stock	173.98	174.0299	173.5	173.7	539539.0
2025-09-09 19:00:00	NVDA	Stock	173.74	174.22	173.2401	174.22	575646.0
2025-09-09 04:00:00	AMZN	Stock	236.61	236.68	235.74	235.88	12522.0
2025-09-09 05:00:00	AMZN	Stock	235.99	236.11	235.85	235.99	2499.0

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

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