PREVIEW / etf_1hour / 2026-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-25.parquet
  size:    722 KB
  rows:    28,517

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-25 04:00:00	SPY	ETF	764.9	766.615	764.15	766.38	75846.0
2026-08-25 05:00:00	SPY	ETF	766.26	768.15	766.18	767.59	59875.0
2026-08-25 06:00:00	SPY	ETF	767.5	767.63	766.66	766.85	51174.0
2026-08-25 07:00:00	SPY	ETF	766.879	767.35	765.975	767.09	195009.0
2026-08-25 08:00:00	SPY	ETF	767.12	767.55	766.15	766.46	186814.0
2026-08-25 09:00:00	SPY	ETF	766.47	766.78	765.5001	765.69	2442420.0
2026-08-25 10:00:00	SPY	ETF	765.69	765.81	763.0501	764.72	4075585.0
2026-08-25 11:00:00	SPY	ETF	764.73	765.85	764.3	765.44	2179102.0
2026-08-25 12:00:00	SPY	ETF	765.46	765.95	765.3213	765.76	1645397.0
2026-08-25 13:00:00	SPY	ETF	765.76	765.84	764.63	765.04	1700599.0
2026-08-25 14:00:00	SPY	ETF	765.03	765.87	764.72	765.64	2051983.0
2026-08-25 15:00:00	SPY	ETF	765.65	766.22	764.87	765.83	5224800.0
2026-08-25 16:00:00	SPY	ETF	765.84	766.28	765.33	765.85	1636719.0
2026-08-25 17:00:00	SPY	ETF	765.81	766.12	765.72	766.0	30427.0
2026-08-25 18:00:00	SPY	ETF	765.99	766.0538	765.8	765.98	23070.0
2026-08-25 19:00:00	SPY	ETF	765.96	765.96	764.8277	764.97	17895.0
2026-08-25 04:00:00	QQQ	ETF	709.68	711.81	708.06	711.3	194919.0
2026-08-25 05:00:00	QQQ	ETF	711.0942	714.17	710.97	713.56	145711.0
2026-08-25 06:00:00	QQQ	ETF	713.42	713.8857	712.44	712.67	76996.0
2026-08-25 07:00:00	QQQ	ETF	712.661	713.42	711.2	712.98	194012.0
2026-08-25 08:00:00	QQQ	ETF	712.97	713.92	705.791	712.12	210122.0
2026-08-25 09:00:00	QQQ	ETF	712.11	714.04	710.76	711.62	3360386.0
2026-08-25 10:00:00	QQQ	ETF	711.67	711.68	707.45	709.7	3949483.0
2026-08-25 11:00:00	QQQ	ETF	709.69	711.57	708.88	710.435	2389991.0
2026-08-25 12:00:00	QQQ	ETF	710.47	711.29	710.19	710.705	1547960.0
2026-08-25 13:00:00	QQQ	ETF	710.7116	710.8	709.27	709.544	1505939.0
2026-08-25 14:00:00	QQQ	ETF	709.53	710.67	708.96	710.26	1666885.0
2026-08-25 15:00:00	QQQ	ETF	710.255	711.1	709.18	710.63	3122192.0
2026-08-25 16:00:00	QQQ	ETF	710.635	711.64	710.25	710.94	1055197.0
2026-08-25 17:00:00	QQQ	ETF	711.0	711.29	710.85	711.29	36420.0
2026-08-25 18:00:00	QQQ	ETF	711.21	711.52	710.9	711.0	43644.0
2026-08-25 19:00:00	QQQ	ETF	711.0	711.0	709.12	709.22	125594.0
2026-08-25 04:00:00	IWM	ETF	298.57	299.57	298.26	299.44	56364.0
2026-08-25 05:00:00	IWM	ETF	299.44	300.29	299.36	300.06	38484.0
2026-08-25 06:00:00	IWM	ETF	300.06	300.06	299.71	299.85	70882.0
2026-08-25 07:00:00	IWM	ETF	299.78	300.25	299.35	300.25	62923.0
2026-08-25 08:00:00	IWM	ETF	300.2432	300.2432	299.46	299.55	65644.0
2026-08-25 09:00:00	IWM	ETF	299.6	299.78	298.36	298.57	1758927.0
2026-08-25 10:00:00	IWM	ETF	298.6	299.12	297.97	298.99	2032798.0
2026-08-25 11:00:00	IWM	ETF	298.99	299.26	298.75	299.04	1312058.0
2026-08-25 12:00:00	IWM	ETF	299.035	299.1	298.585	298.83	564988.0
2026-08-25 13:00:00	IWM	ETF	298.825	298.875	298.51	298.735	494320.0
2026-08-25 14:00:00	IWM	ETF	298.735	299.03	298.625	298.855	853491.0
2026-08-25 15:00:00	IWM	ETF	298.85	299.46	298.61	299.25	2741372.0
2026-08-25 16:00:00	IWM	ETF	299.23	299.38	299.13	299.25	745709.0
2026-08-25 17:00:00	IWM	ETF	299.32	299.35	299.23	299.34	7013.0
2026-08-25 18:00:00	IWM	ETF	299.24	299.3	299.14	299.16	10018.0
2026-08-25 19:00:00	IWM	ETF	299.16	299.18	298.93	298.93	7004.0
2026-08-25 04:00:00	DIA	ETF	533.68	534.98	533.68	534.9	4914.0
2026-08-25 05:00:00	DIA	ETF	535.08	536.54	535.08	536.54	1906.0

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

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