PREVIEW / stock_1hour / 2025-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-07-18.parquet
  size:    1.4 MB
  rows:    62,633
  symbols: 370

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-07-18 04:00:00	AAPL	Stock	210.56	210.7	210.46	210.55	9018.0
2025-07-18 05:00:00	AAPL	Stock	210.58	210.8	210.58	210.7	12540.0
2025-07-18 06:00:00	AAPL	Stock	210.67	210.67	210.35	210.4	20355.0
2025-07-18 07:00:00	AAPL	Stock	210.45	210.45	210.02	210.35	20777.0
2025-07-18 08:00:00	AAPL	Stock	210.15	210.76	209.495	210.5295	101538.0
2025-07-18 09:00:00	AAPL	Stock	210.5505	211.93	209.89	210.32	8260015.0
2025-07-18 10:00:00	AAPL	Stock	210.38	211.01	209.7045	210.4701	4405480.0
2025-07-18 11:00:00	AAPL	Stock	210.511	211.1	210.42	211.075	2943112.0
2025-07-18 12:00:00	AAPL	Stock	211.0701	211.79	210.67	211.32	3100811.0
2025-07-18 13:00:00	AAPL	Stock	211.32	211.54	210.97	211.09	2274979.0
2025-07-18 14:00:00	AAPL	Stock	211.1	211.26	210.76	210.965	1906972.0
2025-07-18 15:00:00	AAPL	Stock	210.96	211.35	209.94	211.22	4300436.0
2025-07-18 16:00:00	AAPL	Stock	211.23	211.23	210.76	211.0978	6794842.0
2025-07-18 17:00:00	AAPL	Stock	211.01	211.28	211.01	211.1999	58245.0
2025-07-18 18:00:00	AAPL	Stock	211.2	211.2001	211.05	211.07	10468.0
2025-07-18 19:00:00	AAPL	Stock	211.08	211.3	211.0519	211.2	15830.0
2025-07-18 04:00:00	MSFT	Stock	512.86	513.2	512.0	513.2	1993.0
2025-07-18 05:00:00	MSFT	Stock	513.5	513.5	513.21	513.32	580.0
2025-07-18 06:00:00	MSFT	Stock	513.32	513.32	512.84	513.19	2739.0
2025-07-18 07:00:00	MSFT	Stock	513.11	513.36	512.7	512.7	4025.0
2025-07-18 08:00:00	MSFT	Stock	513.0	513.5	510.421	512.56	12322.0
2025-07-18 09:00:00	MSFT	Stock	512.58	518.07	510.74	511.4	2974727.0
2025-07-18 10:00:00	MSFT	Stock	511.49	512.29	510.3	510.5068	1643520.0
2025-07-18 11:00:00	MSFT	Stock	510.43	510.79	509.51	509.66	903710.0
2025-07-18 12:00:00	MSFT	Stock	509.66	509.89	508.33	509.8312	916456.0
2025-07-18 13:00:00	MSFT	Stock	509.83	511.18	509.52	510.73	453617.0
2025-07-18 14:00:00	MSFT	Stock	510.78	511.8	510.74	511.61	474953.0
2025-07-18 15:00:00	MSFT	Stock	511.62	511.96	507.43	509.96	1907078.0
2025-07-18 16:00:00	MSFT	Stock	510.05	510.36	509.83	509.98	2561393.0
2025-07-18 17:00:00	MSFT	Stock	510.02	510.0201	509.8	509.96	3019.0
2025-07-18 18:00:00	MSFT	Stock	510.1333	510.1333	510.0	510.1243	1464.0
2025-07-18 19:00:00	MSFT	Stock	509.93	510.13	509.93	510.13	1380.0
2025-07-18 04:00:00	NVDA	Stock	173.95	173.95	173.67	173.81	130123.0
2025-07-18 05:00:00	NVDA	Stock	173.81	173.99	173.75	173.92	82023.0
2025-07-18 06:00:00	NVDA	Stock	173.92	173.96	173.61	173.79	146468.0
2025-07-18 07:00:00	NVDA	Stock	173.8	173.93	173.65	173.78	186079.0
2025-07-18 08:00:00	NVDA	Stock	173.77	174.16	173.59	173.67	985040.0
2025-07-18 09:00:00	NVDA	Stock	173.66	174.53	173.24	173.36	24393758.0
2025-07-18 10:00:00	NVDA	Stock	173.43	173.6	171.8	171.8399	25489896.0
2025-07-18 11:00:00	NVDA	Stock	171.84	172.58	171.26	172.5	16416548.0
2025-07-18 12:00:00	NVDA	Stock	172.495	172.56	171.8	172.195	9349583.0
2025-07-18 13:00:00	NVDA	Stock	172.195	172.75	172.0	172.3901	8350300.0
2025-07-18 14:00:00	NVDA	Stock	172.4	172.52	171.98	171.99	7368641.0
2025-07-18 15:00:00	NVDA	Stock	171.9897	173.0	171.5	172.38	14146089.0
2025-07-18 16:00:00	NVDA	Stock	172.38	172.44	172.31	172.39	9515121.0
2025-07-18 17:00:00	NVDA	Stock	172.39	172.55	172.34	172.46	231739.0
2025-07-18 18:00:00	NVDA	Stock	172.46	172.5	172.4112	172.4592	79852.0
2025-07-18 19:00:00	NVDA	Stock	172.44	172.45	172.2501	172.36	240710.0
2025-07-18 04:00:00	AMZN	Stock	224.26	224.26	223.9	224.13	11478.0
2025-07-18 05:00:00	AMZN	Stock	224.16	224.4	224.16	224.4	5254.0

> showing 50 of 62,633 rows — these rows as CSV

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