PREVIEW / etf_1hour / 2026-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-09-01.parquet
  size:    741 KB
  rows:    29,232

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-01 04:00:00	SPY	ETF	766.4	767.84	763.19	763.2	97072.0
2026-09-01 05:00:00	SPY	ETF	763.21	763.23	762.205	762.69	76518.0
2026-09-01 06:00:00	SPY	ETF	762.76	764.0	762.5	762.97	90804.0
2026-09-01 07:00:00	SPY	ETF	762.96	763.61	762.4	762.5377	280736.0
2026-09-01 08:00:00	SPY	ETF	762.5177	762.79	761.81	762.05	447388.0
2026-09-01 09:00:00	SPY	ETF	762.03	762.48	761.17	762.015	3347257.0
2026-09-01 10:00:00	SPY	ETF	762.02	764.55	761.74	763.54	3940459.0
2026-09-01 11:00:00	SPY	ETF	763.56	764.67	762.67	764.29	2858392.0
2026-09-01 12:00:00	SPY	ETF	764.29	764.34	761.58	762.26	3306392.0
2026-09-01 13:00:00	SPY	ETF	762.26	762.29	760.73	761.82	2762441.0
2026-09-01 14:00:00	SPY	ETF	761.81	762.04	759.48	760.7295	3562663.0
2026-09-01 15:00:00	SPY	ETF	760.72	761.76	760.58	761.66	7476283.0
2026-09-01 16:00:00	SPY	ETF	761.64	762.17	761.35	761.9	2785837.0
2026-09-01 17:00:00	SPY	ETF	761.97	762.15	761.75	761.78	68138.0
2026-09-01 18:00:00	SPY	ETF	761.77	762.07	761.45	761.8	58670.0
2026-09-01 19:00:00	SPY	ETF	761.77	761.99	761.67	761.93	51158.0
2026-09-01 04:00:00	QQQ	ETF	715.68	718.38	710.3	710.3607	370785.0
2026-09-01 05:00:00	QQQ	ETF	710.43	710.5	709.12	709.85	192003.0
2026-09-01 06:00:00	QQQ	ETF	709.75	710.87	709.46	709.84	174136.0
2026-09-01 07:00:00	QQQ	ETF	709.75	710.39	708.72	708.84	243410.0
2026-09-01 08:00:00	QQQ	ETF	708.81	717.297	707.65	707.65	349422.0
2026-09-01 09:00:00	QQQ	ETF	707.65	708.45	705.62	707.225	4180743.0
2026-09-01 10:00:00	QQQ	ETF	707.27	711.1	706.7714	710.18	3325840.0
2026-09-01 11:00:00	QQQ	ETF	710.18	712.3	708.9997	711.81	2378923.0
2026-09-01 12:00:00	QQQ	ETF	711.85	711.89	707.87	709.3	3303854.0
2026-09-01 13:00:00	QQQ	ETF	709.3	709.3	707.0	708.02	1428962.0
2026-09-01 14:00:00	QQQ	ETF	708.0	708.27	704.66	706.4232	2850016.0
2026-09-01 15:00:00	QQQ	ETF	706.445	708.55	706.31	707.67	3947753.0
2026-09-01 16:00:00	QQQ	ETF	707.69	710.8	707.3646	707.85	2306439.0
2026-09-01 17:00:00	QQQ	ETF	707.82	708.04	707.65	707.7024	92616.0
2026-09-01 18:00:00	QQQ	ETF	707.79	708.15	707.1	707.78	104956.0
2026-09-01 19:00:00	QQQ	ETF	707.73	708.05	707.5	707.8299	39955.0
2026-09-01 04:00:00	IWM	ETF	293.78	294.5	292.3	292.5	64158.0
2026-09-01 05:00:00	IWM	ETF	292.45	292.71	292.23	292.32	43968.0
2026-09-01 06:00:00	IWM	ETF	292.35	293.05	292.2	292.57	61545.0
2026-09-01 07:00:00	IWM	ETF	292.6	292.771	292.22	292.22	186032.0
2026-09-01 08:00:00	IWM	ETF	292.22	292.4	291.94	292.05	153076.0
2026-09-01 09:00:00	IWM	ETF	292.02	292.94	291.23	291.53	2987282.0
2026-09-01 10:00:00	IWM	ETF	291.52	292.82	291.24	292.14	2550165.0
2026-09-01 11:00:00	IWM	ETF	292.15	292.335	291.81	292.03	1436552.0
2026-09-01 12:00:00	IWM	ETF	292.03	292.105	290.37	290.93	2262770.0
2026-09-01 13:00:00	IWM	ETF	290.935	290.97	290.47	290.695	1719228.0
2026-09-01 14:00:00	IWM	ETF	290.69	290.76	289.97	290.435	1856428.0
2026-09-01 15:00:00	IWM	ETF	290.435	290.875	290.165	290.6	3892680.0
2026-09-01 16:00:00	IWM	ETF	290.62	290.76	290.36	290.61	1080518.0
2026-09-01 17:00:00	IWM	ETF	290.76	290.81	290.51	290.51	20032.0
2026-09-01 18:00:00	IWM	ETF	290.68	290.68	290.46	290.51	21020.0
2026-09-01 19:00:00	IWM	ETF	290.52	290.59	290.49	290.57	10575.0
2026-09-01 04:00:00	DIA	ETF	531.62	532.0	529.16	529.16	6340.0
2026-09-01 05:00:00	DIA	ETF	529.01	529.01	528.24	528.44	2414.0

> showing 50 of 29,232 rows — these rows as CSV

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