PREVIEW / etf_1hour / 2026-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-19.parquet
  size:    730 KB
  rows:    28,930

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-08-19 04:00:00	SPY	ETF	767.89	768.24	765.86	767.89	71972.0
2026-08-19 05:00:00	SPY	ETF	767.89	767.93	767.24	767.36	23814.0
2026-08-19 06:00:00	SPY	ETF	767.32	767.69	767.055	767.47	16365.0
2026-08-19 07:00:00	SPY	ETF	767.42	768.0	767.39	767.85	51745.0
2026-08-19 08:00:00	SPY	ETF	767.79	771.82	766.99	770.86	1067687.0
2026-08-19 09:00:00	SPY	ETF	770.73	771.09	768.1	769.99	3901300.0
2026-08-19 10:00:00	SPY	ETF	770.02	772.24	768.73	772.2	3994666.0
2026-08-19 11:00:00	SPY	ETF	772.195	772.47	770.07	770.6209	2780065.0
2026-08-19 12:00:00	SPY	ETF	770.64	771.99	769.5	769.68	2495208.0
2026-08-19 13:00:00	SPY	ETF	769.69	770.229	769.02	769.5076	2280055.0
2026-08-19 14:00:00	SPY	ETF	769.53	770.55	768.96	769.515	2479549.0
2026-08-19 15:00:00	SPY	ETF	769.53	770.38	768.2	769.06	7142822.0
2026-08-19 16:00:00	SPY	ETF	769.09	769.23	766.875	769.05	3134892.0
2026-08-19 17:00:00	SPY	ETF	769.0	769.17	768.96	769.17	40347.0
2026-08-19 18:00:00	SPY	ETF	769.24	770.29	769.15	770.23	60281.0
2026-08-19 19:00:00	SPY	ETF	770.26	770.59	770.01	770.01	30867.0
2026-08-19 04:00:00	QQQ	ETF	717.3	719.02	714.01	718.295	212129.0
2026-08-19 05:00:00	QQQ	ETF	718.34	718.77	716.58	716.94	70044.0
2026-08-19 06:00:00	QQQ	ETF	716.97	717.05	715.97	716.19	83620.0
2026-08-19 07:00:00	QQQ	ETF	716.18	717.57	715.85	716.54	135264.0
2026-08-19 08:00:00	QQQ	ETF	716.5	721.87	716.0095	721.54	980957.0
2026-08-19 09:00:00	QQQ	ETF	721.4	721.66	713.37	715.5	6040978.0
2026-08-19 10:00:00	QQQ	ETF	715.52	718.6	712.61	718.59	6002985.0
2026-08-19 11:00:00	QQQ	ETF	718.57	718.737	716.8	718.17	2111769.0
2026-08-19 12:00:00	QQQ	ETF	718.18	719.7	716.86	717.04	1919089.0
2026-08-19 13:00:00	QQQ	ETF	717.02	717.345	715.82	716.63	2073739.0
2026-08-19 14:00:00	QQQ	ETF	716.65	717.79	715.38	716.4	2192679.0
2026-08-19 15:00:00	QQQ	ETF	716.4175	717.76	715.24	716.13	4351487.0
2026-08-19 16:00:00	QQQ	ETF	716.11	717.02	715.94	717.02	887694.0
2026-08-19 17:00:00	QQQ	ETF	716.96	717.25	715.93	717.08	462923.0
2026-08-19 18:00:00	QQQ	ETF	717.11	719.3	717.06	719.2	106393.0
2026-08-19 19:00:00	QQQ	ETF	719.16	720.09	718.6317	718.76	73082.0
2026-08-19 04:00:00	IWM	ETF	300.46	300.74	299.64	300.36	42633.0
2026-08-19 05:00:00	IWM	ETF	300.31	300.37	299.89	299.94	39911.0
2026-08-19 06:00:00	IWM	ETF	299.93	300.15	299.77	300.03	8278.0
2026-08-19 07:00:00	IWM	ETF	300.02	300.45	300.02	300.32	29678.0
2026-08-19 08:00:00	IWM	ETF	300.3	303.58	300.23	302.75	705214.0
2026-08-19 09:00:00	IWM	ETF	302.72	303.15	301.74	302.35	2702283.0
2026-08-19 10:00:00	IWM	ETF	302.35	303.15	301.435	303.15	2017115.0
2026-08-19 11:00:00	IWM	ETF	303.16	303.4105	302.27	302.29	1377623.0
2026-08-19 12:00:00	IWM	ETF	302.3	302.7399	302.0675	302.14	827486.0
2026-08-19 13:00:00	IWM	ETF	302.13	302.275	301.65	301.76	969643.0
2026-08-19 14:00:00	IWM	ETF	301.7501	302.0	301.23	301.34	973562.0
2026-08-19 15:00:00	IWM	ETF	301.35	301.83	301.27	301.72	2175619.0
2026-08-19 16:00:00	IWM	ETF	301.72	301.82	301.54	301.72	532120.0
2026-08-19 17:00:00	IWM	ETF	301.75	301.92	301.61	301.68	9660.0
2026-08-19 18:00:00	IWM	ETF	301.77	302.08	301.77	302.03	12173.0
2026-08-19 19:00:00	IWM	ETF	302.09	302.12	301.91	301.95	18574.0
2026-08-19 04:00:00	DIA	ETF	533.3	533.42	532.38	533.38	4568.0
2026-08-19 05:00:00	DIA	ETF	532.94	532.94	532.84	532.9	1666.0

> showing 50 of 28,930 rows — these rows as CSV

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