PREVIEW / etf_1hour / 2026-09-04

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-09-04.parquet
  size:    703 KB
  rows:    28,269

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-09-04 04:00:00	SPY	ETF	773.79	774.24	773.33	773.97	98830.0
2026-09-04 05:00:00	SPY	ETF	773.89	773.97	773.3	773.64	9643.0
2026-09-04 06:00:00	SPY	ETF	773.68	774.12	773.595	773.89	36281.0
2026-09-04 07:00:00	SPY	ETF	773.955	774.15	773.5	773.95	97212.0
2026-09-04 08:00:00	SPY	ETF	773.99	774.1	770.5	771.66	924450.0
2026-09-04 09:00:00	SPY	ETF	771.64	772.87	771.25	772.31	3351710.0
2026-09-04 10:00:00	SPY	ETF	772.32	772.36	769.3	769.45	3523171.0
2026-09-04 11:00:00	SPY	ETF	769.47	770.06	769.0	769.9575	2614400.0
2026-09-04 12:00:00	SPY	ETF	769.955	771.32	769.83	770.89	1969826.0
2026-09-04 13:00:00	SPY	ETF	770.9	770.97	769.13	769.459	2142239.0
2026-09-04 14:00:00	SPY	ETF	769.44	770.37	769.2101	770.25	1923966.0
2026-09-04 15:00:00	SPY	ETF	770.26	770.48	769.59	770.23	6316700.0
2026-09-04 16:00:00	SPY	ETF	770.25	770.3311	769.23	769.45	3439914.0
2026-09-04 17:00:00	SPY	ETF	769.45	770.0	769.45	769.83	118443.0
2026-09-04 18:00:00	SPY	ETF	769.83	769.8424	769.24	769.8	34699.0
2026-09-04 19:00:00	SPY	ETF	769.82	769.94	769.45	769.45	19267.0
2026-09-04 04:00:00	QQQ	ETF	720.79	721.4	718.62	721.0	164833.0
2026-09-04 05:00:00	QQQ	ETF	721.07	721.09	720.05	721.0404	39882.0
2026-09-04 06:00:00	QQQ	ETF	721.0327	722.06	720.98	721.6	47298.0
2026-09-04 07:00:00	QQQ	ETF	721.6	721.81	720.9	721.65	122510.0
2026-09-04 08:00:00	QQQ	ETF	721.65	721.75	717.132	718.35	750626.0
2026-09-04 09:00:00	QQQ	ETF	718.3	721.86	717.72	721.81	3158955.0
2026-09-04 10:00:00	QQQ	ETF	721.82	721.84	717.26	717.78	5236872.0
2026-09-04 11:00:00	QQQ	ETF	717.75	718.32	716.78	717.65	3129952.0
2026-09-04 12:00:00	QQQ	ETF	717.64	719.61	717.43	719.16	2452806.0
2026-09-04 13:00:00	QQQ	ETF	719.155	719.26	716.56	717.12	3158661.0
2026-09-04 14:00:00	QQQ	ETF	717.11	718.32	716.64	718.23	2098832.0
2026-09-04 15:00:00	QQQ	ETF	718.235	719.445	717.48	719.06	3811063.0
2026-09-04 16:00:00	QQQ	ETF	719.03	719.06	717.69	717.9	1211145.0
2026-09-04 17:00:00	QQQ	ETF	717.99	718.21	717.75	718.1	78971.0
2026-09-04 18:00:00	QQQ	ETF	717.9893	718.1	717.5	718.03	23073.0
2026-09-04 19:00:00	QQQ	ETF	718.03	718.03	717.4	717.5	56453.0
2026-09-04 04:00:00	IWM	ETF	295.42	295.68	295.14	295.4	20257.0
2026-09-04 05:00:00	IWM	ETF	295.45	295.45	295.05	295.09	3939.0
2026-09-04 06:00:00	IWM	ETF	295.04	295.39	295.01	295.2301	24090.0
2026-09-04 07:00:00	IWM	ETF	295.25	295.41	295.17	295.32	56125.0
2026-09-04 08:00:00	IWM	ETF	295.2	295.92	293.24	293.85	332100.0
2026-09-04 09:00:00	IWM	ETF	293.92	295.22	293.56	294.59	2428866.0
2026-09-04 10:00:00	IWM	ETF	294.6	295.91	294.53	295.15	1710597.0
2026-09-04 11:00:00	IWM	ETF	295.16	295.885	295.02	295.5338	1061948.0
2026-09-04 12:00:00	IWM	ETF	295.52	296.175	295.51	295.76	1232923.0
2026-09-04 13:00:00	IWM	ETF	295.755	295.795	295.075	295.2	891042.0
2026-09-04 14:00:00	IWM	ETF	295.2	295.72	295.2	295.575	735595.0
2026-09-04 15:00:00	IWM	ETF	295.58	296.18	295.39	295.96	2020658.0
2026-09-04 16:00:00	IWM	ETF	295.97	296.02	295.61	295.71	731892.0
2026-09-04 17:00:00	IWM	ETF	295.8	295.85	295.48	295.59	30548.0
2026-09-04 18:00:00	IWM	ETF	295.56	295.71	295.42	295.57	3374.0
2026-09-04 19:00:00	IWM	ETF	295.63	295.68	295.39	295.46	6003.0
2026-09-04 04:00:00	DIA	ETF	537.2	537.21	536.56	536.76	1713.0
2026-09-04 06:00:00	DIA	ETF	536.66	536.72	536.48	536.67	677.0

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

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