PREVIEW / etf_1hour / 2026-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-27.parquet
  size:    724 KB
  rows:    28,396

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-27 04:00:00	SPY	ETF	769.47	770.27	767.6	769.79	94857.0
2026-08-27 05:00:00	SPY	ETF	769.6	769.68	768.76	769.46	71437.0
2026-08-27 06:00:00	SPY	ETF	769.17	769.3	768.69	769.205	34503.0
2026-08-27 07:00:00	SPY	ETF	769.27	769.8	768.375	769.0869	246339.0
2026-08-27 08:00:00	SPY	ETF	769.06	769.46	767.96	768.02	265924.0
2026-08-27 09:00:00	SPY	ETF	767.97	769.69	767.16	768.4056	4479216.0
2026-08-27 10:00:00	SPY	ETF	768.4	770.44	768.05	770.395	3105623.0
2026-08-27 11:00:00	SPY	ETF	770.41	771.1	769.39	770.64	2882768.0
2026-08-27 12:00:00	SPY	ETF	770.64	772.03	770.34	771.99	2025072.0
2026-08-27 13:00:00	SPY	ETF	772.02	772.355	771.1	771.225	2180409.0
2026-08-27 14:00:00	SPY	ETF	771.225	771.39	769.16	769.65	2837138.0
2026-08-27 15:00:00	SPY	ETF	769.65	771.36	769.52	771.07	6046371.0
2026-08-27 16:00:00	SPY	ETF	771.05	771.2	770.0	770.15	2422165.0
2026-08-27 17:00:00	SPY	ETF	770.29	770.45	770.0	770.3	40236.0
2026-08-27 18:00:00	SPY	ETF	770.29	770.34	769.65	770.18	33170.0
2026-08-27 19:00:00	SPY	ETF	770.19	770.19	769.6202	769.8	42392.0
2026-08-27 04:00:00	QQQ	ETF	717.35	720.18	714.0	719.36	416789.0
2026-08-27 05:00:00	QQQ	ETF	719.33	719.5	717.95	718.775	91936.0
2026-08-27 06:00:00	QQQ	ETF	718.76	718.865	718.0	718.67	93556.0
2026-08-27 07:00:00	QQQ	ETF	718.71	719.45	716.75	717.69	222555.0
2026-08-27 08:00:00	QQQ	ETF	717.74	718.48	716.735	716.84	226054.0
2026-08-27 09:00:00	QQQ	ETF	716.85	718.83	714.525	715.93	4253264.0
2026-08-27 10:00:00	QQQ	ETF	715.96	719.29	715.84	718.8	3169661.0
2026-08-27 11:00:00	QQQ	ETF	718.81	719.59	716.67	718.69	2528928.0
2026-08-27 12:00:00	QQQ	ETF	718.695	720.18	718.08	720.03	1791816.0
2026-08-27 13:00:00	QQQ	ETF	720.03	720.63	718.99	719.09	1577520.0
2026-08-27 14:00:00	QQQ	ETF	719.11	719.34	717.04	718.1	1920523.0
2026-08-27 15:00:00	QQQ	ETF	718.105	721.35	718.03	721.06	3896703.0
2026-08-27 16:00:00	QQQ	ETF	721.06	721.41	718.0884	719.6408	1688669.0
2026-08-27 17:00:00	QQQ	ETF	719.6414	719.92	719.5	719.5	70532.0
2026-08-27 18:00:00	QQQ	ETF	719.5	719.79	718.93	719.6377	72268.0
2026-08-27 19:00:00	QQQ	ETF	719.65	719.72	718.63	718.75	53430.0
2026-08-27 04:00:00	IWM	ETF	298.87	299.24	298.47	298.62	49079.0
2026-08-27 05:00:00	IWM	ETF	298.57	299.18	298.41	298.84	33806.0
2026-08-27 06:00:00	IWM	ETF	298.75	298.89	298.42	298.89	21626.0
2026-08-27 07:00:00	IWM	ETF	298.94	299.0568	298.67	299.0568	30572.0
2026-08-27 08:00:00	IWM	ETF	299.0	299.04	298.5	298.53	66113.0
2026-08-27 09:00:00	IWM	ETF	298.51	299.625	298.33	298.72	1963971.0
2026-08-27 10:00:00	IWM	ETF	298.72	299.27	298.14	299.205	2036777.0
2026-08-27 11:00:00	IWM	ETF	299.21	300.26	299.21	300.205	1664023.0
2026-08-27 12:00:00	IWM	ETF	300.2	300.315	299.61	300.225	933461.0
2026-08-27 13:00:00	IWM	ETF	300.225	300.295	299.75	299.755	828960.0
2026-08-27 14:00:00	IWM	ETF	299.755	299.9	299.38	299.88	729624.0
2026-08-27 15:00:00	IWM	ETF	299.88	300.175	299.71	299.82	2038340.0
2026-08-27 16:00:00	IWM	ETF	299.82	299.93	299.55	299.75	392689.0
2026-08-27 17:00:00	IWM	ETF	299.79	299.97	299.74	299.9	11950.0
2026-08-27 18:00:00	IWM	ETF	299.9	299.91	299.78	299.87	5111.0
2026-08-27 19:00:00	IWM	ETF	299.83	299.83	299.6	299.642	6816.0
2026-08-27 04:00:00	DIA	ETF	535.19	536.01	534.17	534.17	4118.0
2026-08-27 05:00:00	DIA	ETF	534.0	534.4	534.0	534.04	1335.0

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

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