PREVIEW / etf_1hour / 2026-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-12.parquet
  size:    706 KB
  rows:    28,091

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-06-12 04:00:00	SPY	ETF	736.33	741.13	735.95	740.05	175032.0
2026-06-12 05:00:00	SPY	ETF	740.06	743.37	740.06	742.32	154133.0
2026-06-12 06:00:00	SPY	ETF	742.27	742.67	740.37	740.76	100767.0
2026-06-12 07:00:00	SPY	ETF	740.82	743.11	740.65	742.6894	195362.0
2026-06-12 08:00:00	SPY	ETF	742.72	742.8	738.55	738.85	441641.0
2026-06-12 09:00:00	SPY	ETF	738.86	740.89	735.03	736.62	5763921.0
2026-06-12 10:00:00	SPY	ETF	736.78	742.72	736.52	742.36	6248226.0
2026-06-12 11:00:00	SPY	ETF	742.39	744.44	738.44	738.89	5565827.0
2026-06-12 12:00:00	SPY	ETF	738.89	742.24	738.17	741.56	4492908.0
2026-06-12 13:00:00	SPY	ETF	741.58	743.0	740.87	741.3	3528478.0
2026-06-12 14:00:00	SPY	ETF	741.33	742.335	740.42	741.01	4427902.0
2026-06-12 15:00:00	SPY	ETF	740.99	742.21	740.07	741.63	7558733.0
2026-06-12 16:00:00	SPY	ETF	741.64	742.74	741.55	741.92	5212625.0
2026-06-12 17:00:00	SPY	ETF	742.04	742.2	741.75	742.14	203041.0
2026-06-12 18:00:00	SPY	ETF	742.19	742.39	741.95	742.32	88803.0
2026-06-12 19:00:00	SPY	ETF	742.32	742.49	742.2	742.45	47392.0
2026-06-12 04:00:00	QQQ	ETF	715.9	719.33	712.0	717.25	574973.0
2026-06-12 05:00:00	QQQ	ETF	717.25	721.81	717.2	720.69	187776.0
2026-06-12 06:00:00	QQQ	ETF	720.62	721.54	718.15	718.97	147766.0
2026-06-12 07:00:00	QQQ	ETF	719.01	721.63	719.0	721.13	284480.0
2026-06-12 08:00:00	QQQ	ETF	721.14	721.2	715.07	715.6499	694062.0
2026-06-12 09:00:00	QQQ	ETF	715.67	717.76	711.28	714.25	7043979.0
2026-06-12 10:00:00	QQQ	ETF	714.27	721.32	713.92	720.97	7244864.0
2026-06-12 11:00:00	QQQ	ETF	721.0799	724.01	715.58	716.275	6416878.0
2026-06-12 12:00:00	QQQ	ETF	716.26	722.12	715.57	721.92	4805728.0
2026-06-12 13:00:00	QQQ	ETF	721.97	723.9	721.29	722.14	3362002.0
2026-06-12 14:00:00	QQQ	ETF	722.17	723.02	720.35	721.23	3126181.0
2026-06-12 15:00:00	QQQ	ETF	721.15	722.78	719.59	721.27	4165159.0
2026-06-12 16:00:00	QQQ	ETF	721.29	723.21	718.0	721.91	1461492.0
2026-06-12 17:00:00	QQQ	ETF	722.0	722.3	721.34	722.18	121717.0
2026-06-12 18:00:00	QQQ	ETF	722.2	722.5	722.0	722.5	22884.0
2026-06-12 19:00:00	QQQ	ETF	722.6	723.3	722.5	723.25	39718.0
2026-06-12 04:00:00	IWM	ETF	291.16	292.85	289.44	292.03	74078.0
2026-06-12 05:00:00	IWM	ETF	292.17	293.75	291.95	292.87	65380.0
2026-06-12 06:00:00	IWM	ETF	292.85	293.14	292.1	292.43	188568.0
2026-06-12 07:00:00	IWM	ETF	292.5	293.24	292.37	292.85	75494.0
2026-06-12 08:00:00	IWM	ETF	292.9	292.96	290.62	290.9	192321.0
2026-06-12 09:00:00	IWM	ETF	290.91	292.52	290.31	292.33	4125204.0
2026-06-12 10:00:00	IWM	ETF	292.4	295.07	292.09	294.86	5103859.0
2026-06-12 11:00:00	IWM	ETF	294.89	295.72	292.6	292.81	3292049.0
2026-06-12 12:00:00	IWM	ETF	292.81	294.36	292.22	294.015	2985351.0
2026-06-12 13:00:00	IWM	ETF	294.02	294.6	293.46	293.78	1517087.0
2026-06-12 14:00:00	IWM	ETF	293.8	294.01	292.9	292.95	1400465.0
2026-06-12 15:00:00	IWM	ETF	292.95	293.82	292.69	292.92	3483160.0
2026-06-12 16:00:00	IWM	ETF	292.95	293.64	292.88	293.23	1217687.0
2026-06-12 17:00:00	IWM	ETF	293.17	293.5	293.17	293.45	3068.0
2026-06-12 18:00:00	IWM	ETF	293.49	293.64	293.31	293.34	11772.0
2026-06-12 19:00:00	IWM	ETF	293.4	293.8	293.34	293.589	15413.0
2026-06-12 04:00:00	DIA	ETF	510.55	512.78	509.44	512.24	11375.0
2026-06-12 05:00:00	DIA	ETF	512.82	514.05	512.78	513.59	5275.0

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

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