PREVIEW / stock_1hour / 2026-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-07-09.parquet
  size:    1.4 MB
  rows:    59,534

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
2026-07-09 04:00:00	AAPL	Stock	313.26	314.96	312.5	312.59	63367.0
2026-07-09 05:00:00	AAPL	Stock	312.52	312.68	312.0	312.43	10669.0
2026-07-09 06:00:00	AAPL	Stock	312.4898	312.49	312.05	312.21	17764.0
2026-07-09 07:00:00	AAPL	Stock	312.29	312.6	311.9	312.46	46844.0
2026-07-09 08:00:00	AAPL	Stock	312.3	312.77	311.26	311.55	82596.0
2026-07-09 09:00:00	AAPL	Stock	311.7	312.19	308.16	310.975	4165461.0
2026-07-09 10:00:00	AAPL	Stock	310.98	312.4	310.16	311.555	3586368.0
2026-07-09 11:00:00	AAPL	Stock	311.55	315.02	311.51	314.77	3424413.0
2026-07-09 12:00:00	AAPL	Stock	314.79	315.5	314.09	314.71	3287100.0
2026-07-09 13:00:00	AAPL	Stock	314.72	315.18	314.31	314.98	2218382.0
2026-07-09 14:00:00	AAPL	Stock	314.99	315.3199	314.23	314.44	2536936.0
2026-07-09 15:00:00	AAPL	Stock	314.44	316.53	314.405	316.17	4949072.0
2026-07-09 16:00:00	AAPL	Stock	316.17	316.25	315.4	315.5217	8948249.0
2026-07-09 17:00:00	AAPL	Stock	315.6	315.8948	315.56	315.73	10131.0
2026-07-09 18:00:00	AAPL	Stock	315.72	315.81	315.37	315.44	16165.0
2026-07-09 19:00:00	AAPL	Stock	315.4304	315.8	315.18	315.2801	20009.0
2026-07-09 04:00:00	MSFT	Stock	384.48	385.0333	380.0	381.2	123771.0
2026-07-09 05:00:00	MSFT	Stock	381.32	381.616	380.6	381.2	18849.0
2026-07-09 06:00:00	MSFT	Stock	381.195	381.66	378.62	379.95	67152.0
2026-07-09 07:00:00	MSFT	Stock	379.95	380.0	376.0	376.84	220134.0
2026-07-09 08:00:00	MSFT	Stock	376.87	377.0	375.03	375.32	287336.0
2026-07-09 09:00:00	MSFT	Stock	375.485	379.32	373.35	378.59	3904070.0
2026-07-09 10:00:00	MSFT	Stock	378.66	378.94	375.15	378.94	3352280.0
2026-07-09 11:00:00	MSFT	Stock	378.95	380.6	378.83	380.095	2038155.0
2026-07-09 12:00:00	MSFT	Stock	380.1	380.2	378.9501	379.42	1338948.0
2026-07-09 13:00:00	MSFT	Stock	379.44	380.91	379.4	380.65	1627604.0
2026-07-09 14:00:00	MSFT	Stock	380.69	381.25	380.37	380.79	1414578.0
2026-07-09 15:00:00	MSFT	Stock	380.786	384.65	380.74	384.33	3391596.0
2026-07-09 16:00:00	MSFT	Stock	384.315	384.59	383.65	384.15	6134511.0
2026-07-09 17:00:00	MSFT	Stock	384.12	384.3482	383.6401	383.6712	29407.0
2026-07-09 18:00:00	MSFT	Stock	383.7171	384.11	383.38	383.8	15818.0
2026-07-09 19:00:00	MSFT	Stock	383.8499	384.5	383.5	384.12	27056.0
2026-07-09 04:00:00	NVDA	Stock	205.38	205.86	203.4	204.45	519066.0
2026-07-09 05:00:00	NVDA	Stock	204.53	204.66	204.05	204.56	122751.0
2026-07-09 06:00:00	NVDA	Stock	204.57	204.91	203.83	204.16	149225.0
2026-07-09 07:00:00	NVDA	Stock	204.12	205.8	204.12	205.66	629179.0
2026-07-09 08:00:00	NVDA	Stock	205.7294	206.33	205.25	205.2699	698066.0
2026-07-09 09:00:00	NVDA	Stock	205.2695	205.99	201.32	202.09	15938686.0
2026-07-09 10:00:00	NVDA	Stock	202.09	202.17	198.96	201.295	19212300.0
2026-07-09 11:00:00	NVDA	Stock	201.3	202.2	201.0	201.75	9085372.0
2026-07-09 12:00:00	NVDA	Stock	201.75	202.56	201.64	201.71	7647614.0
2026-07-09 13:00:00	NVDA	Stock	201.71	203.5299	201.6901	203.32	7514397.0
2026-07-09 14:00:00	NVDA	Stock	203.31	204.2	202.92	203.47	8645253.0
2026-07-09 15:00:00	NVDA	Stock	203.48	204.585	202.57	202.7563	12511222.0
2026-07-09 16:00:00	NVDA	Stock	202.71	203.19	199.965	202.51	18532945.0
2026-07-09 17:00:00	NVDA	Stock	202.5721	202.9299	202.5721	202.7435	109296.0
2026-07-09 18:00:00	NVDA	Stock	202.7	202.77	202.1456	202.3607	155547.0
2026-07-09 19:00:00	NVDA	Stock	202.4249	202.66	202.16	202.33	199340.0
2026-07-09 04:00:00	AMZN	Stock	243.8542	244.1958	242.83	242.85	50635.0
2026-07-09 05:00:00	AMZN	Stock	242.9	243.25	242.82	243.17	9399.0

> showing 50 of 59,534 rows — these rows as CSV

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