PREVIEW / etf_1hour / 2026-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-06.parquet
  size:    710 KB
  rows:    28,169

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-06 04:00:00	SPY	ETF	770.9	771.55	770.05	771.39	49103.0
2026-08-06 05:00:00	SPY	ETF	771.42	771.705	770.62	771.685	17578.0
2026-08-06 06:00:00	SPY	ETF	771.65	771.67	770.89	771.16	14797.0
2026-08-06 07:00:00	SPY	ETF	771.189	771.77	770.04	770.91	135266.0
2026-08-06 08:00:00	SPY	ETF	770.9	771.13	770.22	770.39	203822.0
2026-08-06 09:00:00	SPY	ETF	770.43	771.525	769.0576	770.92	2998290.0
2026-08-06 10:00:00	SPY	ETF	770.95	771.82	769.53	770.985	3336206.0
2026-08-06 11:00:00	SPY	ETF	771.0	771.21	767.95	768.125	3649664.0
2026-08-06 12:00:00	SPY	ETF	768.16	769.04	767.46	768.96	3028903.0
2026-08-06 13:00:00	SPY	ETF	768.99	769.18	767.72	768.6303	2486607.0
2026-08-06 14:00:00	SPY	ETF	768.65	769.73	768.45	768.96	3240052.0
2026-08-06 15:00:00	SPY	ETF	768.97	769.79	767.7	768.53	6931086.0
2026-08-06 16:00:00	SPY	ETF	768.52	769.13	767.85	768.21	1973697.0
2026-08-06 17:00:00	SPY	ETF	768.2	768.36	767.8	768.34	47980.0
2026-08-06 18:00:00	SPY	ETF	768.39	769.05	768.0	768.8271	45303.0
2026-08-06 19:00:00	SPY	ETF	768.77	769.09	768.64	768.9861	23170.0
2026-08-06 04:00:00	QQQ	ETF	716.63	717.14	713.46	715.23	204558.0
2026-08-06 05:00:00	QQQ	ETF	715.21	715.49	713.39	715.35	69593.0
2026-08-06 06:00:00	QQQ	ETF	715.35	715.59	714.01	714.32	69929.0
2026-08-06 07:00:00	QQQ	ETF	714.41	715.12	711.49	714.0088	443325.0
2026-08-06 08:00:00	QQQ	ETF	713.9	716.763	712.09	712.39	372153.0
2026-08-06 09:00:00	QQQ	ETF	712.3	716.03	708.5	715.48	4463995.0
2026-08-06 10:00:00	QQQ	ETF	715.5	718.86	714.52	718.592	4991688.0
2026-08-06 11:00:00	QQQ	ETF	718.6	719.32	714.965	715.17	3198863.0
2026-08-06 12:00:00	QQQ	ETF	715.17	716.16	713.53	716.1499	2691256.0
2026-08-06 13:00:00	QQQ	ETF	716.14	716.58	714.6	715.44	1742472.0
2026-08-06 14:00:00	QQQ	ETF	715.48	716.56	714.0	715.09	2199859.0
2026-08-06 15:00:00	QQQ	ETF	715.08	716.405	714.11	714.57	4143111.0
2026-08-06 16:00:00	QQQ	ETF	714.64	715.939	714.24	714.8199	1221237.0
2026-08-06 17:00:00	QQQ	ETF	714.82	715.25	714.68	715.03	91691.0
2026-08-06 18:00:00	QQQ	ETF	715.2	716.63	714.8	716.36	103657.0
2026-08-06 19:00:00	QQQ	ETF	716.33	717.18	716.101	717.0	88288.0
2026-08-06 04:00:00	IWM	ETF	300.09	300.39	299.69	300.38	19505.0
2026-08-06 05:00:00	IWM	ETF	300.44	300.52	300.07	300.52	9292.0
2026-08-06 06:00:00	IWM	ETF	300.45	300.52	300.28	300.33	9541.0
2026-08-06 07:00:00	IWM	ETF	300.2923	300.2923	299.41	299.62	55283.0
2026-08-06 08:00:00	IWM	ETF	299.67	300.06	299.5	299.73	80514.0
2026-08-06 09:00:00	IWM	ETF	299.72	300.11	298.78	299.925	1729149.0
2026-08-06 10:00:00	IWM	ETF	299.91	301.38	299.91	300.46	2066918.0
2026-08-06 11:00:00	IWM	ETF	300.47	300.93	299.42	299.467	1371313.0
2026-08-06 12:00:00	IWM	ETF	299.48	299.67	298.815	299.33	1987604.0
2026-08-06 13:00:00	IWM	ETF	299.3599	299.53	298.76	298.95	1058011.0
2026-08-06 14:00:00	IWM	ETF	298.99	299.11	298.58	298.83	1258568.0
2026-08-06 15:00:00	IWM	ETF	298.84	299.125	297.95	298.245	2730887.0
2026-08-06 16:00:00	IWM	ETF	298.25	299.033	297.81	298.01	888011.0
2026-08-06 17:00:00	IWM	ETF	297.89	298.32	297.84	298.31	38950.0
2026-08-06 18:00:00	IWM	ETF	298.2	298.2295	297.91	298.18	27543.0
2026-08-06 19:00:00	IWM	ETF	298.13	298.25	298.09	298.23	10345.0
2026-08-06 04:00:00	DIA	ETF	544.32	544.59	543.8	544.59	6947.0
2026-08-06 05:00:00	DIA	ETF	544.45	544.7	544.45	544.58	260.0

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

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