PREVIEW / etf_1hour / 2026-08-28

all etf 1-hour files

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

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-28 04:00:00	SPY	ETF	771.19	771.61	770.27	771.08	28693.0
2026-08-28 05:00:00	SPY	ETF	771.05	771.16	770.78	770.99	5570.0
2026-08-28 06:00:00	SPY	ETF	770.94	771.14	770.77	770.98	7900.0
2026-08-28 07:00:00	SPY	ETF	771.051	771.4401	770.83	771.08	173601.0
2026-08-28 08:00:00	SPY	ETF	771.07	772.23	771.06	772.08	210663.0
2026-08-28 09:00:00	SPY	ETF	772.0	772.87	771.4	771.78	2208665.0
2026-08-28 10:00:00	SPY	ETF	771.79	775.04	769.77	774.9601	6176497.0
2026-08-28 11:00:00	SPY	ETF	774.98	775.3	770.83	771.07	4256817.0
2026-08-28 12:00:00	SPY	ETF	771.085	771.65	769.13	769.69	3672519.0
2026-08-28 13:00:00	SPY	ETF	769.68	769.74	768.3076	769.5399	2426539.0
2026-08-28 14:00:00	SPY	ETF	769.56	769.8	768.31	768.68	1934105.0
2026-08-28 15:00:00	SPY	ETF	768.68	769.88	768.47	769.34	5966889.0
2026-08-28 16:00:00	SPY	ETF	769.36	769.65	769.02	769.54	1705825.0
2026-08-28 17:00:00	SPY	ETF	769.573	769.77	769.06	769.39	59902.0
2026-08-28 18:00:00	SPY	ETF	769.4099	769.4099	769.26	769.315	7444.0
2026-08-28 19:00:00	SPY	ETF	769.31	769.42	769.25	769.3278	20433.0
2026-08-28 04:00:00	QQQ	ETF	719.22	720.64	718.51	719.52	103539.0
2026-08-28 05:00:00	QQQ	ETF	719.47	719.56	719.0	719.23	15511.0
2026-08-28 06:00:00	QQQ	ETF	719.12	719.59	718.94	719.56	21803.0
2026-08-28 07:00:00	QQQ	ETF	719.58	720.0	719.035	719.1707	138165.0
2026-08-28 08:00:00	QQQ	ETF	719.13	720.58	719.04	720.47	129083.0
2026-08-28 09:00:00	QQQ	ETF	720.42	721.55	718.1762	719.91	2608538.0
2026-08-28 10:00:00	QQQ	ETF	719.93	723.83	716.78	723.8	5721795.0
2026-08-28 11:00:00	QQQ	ETF	723.77	724.125	717.7	717.87	3705515.0
2026-08-28 12:00:00	QQQ	ETF	717.93	718.82	715.69	716.65	3302141.0
2026-08-28 13:00:00	QQQ	ETF	716.65	717.29	715.085	716.986	1985840.0
2026-08-28 14:00:00	QQQ	ETF	717.0	717.11	715.14	715.51	1539276.0
2026-08-28 15:00:00	QQQ	ETF	715.515	717.08	715.24	716.44	4616303.0
2026-08-28 16:00:00	QQQ	ETF	716.45	717.02	716.03	716.94	2503464.0
2026-08-28 17:00:00	QQQ	ETF	716.86	716.958	716.16	716.41	45947.0
2026-08-28 18:00:00	QQQ	ETF	716.43	716.48	716.06	716.28	23604.0
2026-08-28 19:00:00	QQQ	ETF	716.2149	716.43	716.09	716.2454	32035.0
2026-08-28 04:00:00	IWM	ETF	300.1	300.43	299.93	300.0	12624.0
2026-08-28 05:00:00	IWM	ETF	299.98	300.05	299.86	299.98	2410.0
2026-08-28 06:00:00	IWM	ETF	299.98	300.0	299.55	299.66	7152.0
2026-08-28 07:00:00	IWM	ETF	299.67	299.71	299.24	299.43	63215.0
2026-08-28 08:00:00	IWM	ETF	299.41	299.88	299.41	299.77	69293.0
2026-08-28 09:00:00	IWM	ETF	299.75	300.39	299.01	299.15	1684126.0
2026-08-28 10:00:00	IWM	ETF	299.28	300.13	297.365	298.44	4137818.0
2026-08-28 11:00:00	IWM	ETF	298.43	298.585	296.52	296.565	2313553.0
2026-08-28 12:00:00	IWM	ETF	296.57	296.78	295.83	296.37	1810751.0
2026-08-28 13:00:00	IWM	ETF	296.37	296.46	295.88	296.3	1040018.0
2026-08-28 14:00:00	IWM	ETF	296.3	296.375	295.83	295.94	1359513.0
2026-08-28 15:00:00	IWM	ETF	295.935	296.58	295.67	295.76	3311081.0
2026-08-28 16:00:00	IWM	ETF	295.76	295.93	295.66	295.81	1019943.0
2026-08-28 17:00:00	IWM	ETF	295.79	296.15	295.61	295.78	23627.0
2026-08-28 18:00:00	IWM	ETF	295.66	295.9	295.61	295.65	8980.0
2026-08-28 19:00:00	IWM	ETF	295.63	295.78	295.63	295.669	2390.0
2026-08-28 04:00:00	DIA	ETF	535.87	536.7	535.87	536.62	510.0
2026-08-28 06:00:00	DIA	ETF	535.53	535.59	535.51	535.59	455.0

> showing 50 of 27,784 rows — these rows as CSV

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