PREVIEW / etf_1hour / 2026-06-08

all etf 1-hour files

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

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-08 04:00:00	SPY	ETF	739.17	740.52	736.32	739.16	207599.0
2026-06-08 05:00:00	SPY	ETF	739.04	740.64	738.47	740.36	83518.0
2026-06-08 06:00:00	SPY	ETF	740.4	741.2	739.15	740.47	142905.0
2026-06-08 07:00:00	SPY	ETF	740.441	743.35	739.92	742.33	553956.0
2026-06-08 08:00:00	SPY	ETF	742.29	744.42	742.16	743.53	630807.0
2026-06-08 09:00:00	SPY	ETF	743.55	744.73	740.8	740.85	5708490.0
2026-06-08 10:00:00	SPY	ETF	740.8	745.02	740.6	744.995	5873628.0
2026-06-08 11:00:00	SPY	ETF	744.98	745.34	741.87	742.765	4068699.0
2026-06-08 12:00:00	SPY	ETF	742.75	743.97	741.51	741.91	2853623.0
2026-06-08 13:00:00	SPY	ETF	741.92	742.39	740.08	741.13	3881648.0
2026-06-08 14:00:00	SPY	ETF	741.13	742.45	740.75	740.97	3348565.0
2026-06-08 15:00:00	SPY	ETF	740.97	741.16	738.19	739.31	7699291.0
2026-06-08 16:00:00	SPY	ETF	739.3	739.58	738.47	739.04	2620483.0
2026-06-08 17:00:00	SPY	ETF	739.05	739.13	738.95	739.1	57762.0
2026-06-08 18:00:00	SPY	ETF	739.02	739.4	736.91	738.8401	116564.0
2026-06-08 19:00:00	SPY	ETF	738.9096	739.5	738.1	738.72	43162.0
2026-06-08 04:00:00	QQQ	ETF	710.64	711.74	704.46	709.4	571226.0
2026-06-08 05:00:00	QQQ	ETF	709.4	711.1	708.65	710.85	197808.0
2026-06-08 06:00:00	QQQ	ETF	710.88	711.7	709.31	710.95	214467.0
2026-06-08 07:00:00	QQQ	ETF	710.9	715.64	710.27	714.24	690689.0
2026-06-08 08:00:00	QQQ	ETF	714.18	717.48	713.91	716.84	785822.0
2026-06-08 09:00:00	QQQ	ETF	716.83	719.72	713.35	713.54	6927075.0
2026-06-08 10:00:00	QQQ	ETF	713.56	721.52	713.07	721.43	6033296.0
2026-06-08 11:00:00	QQQ	ETF	721.44	723.03	718.57	719.8204	4828070.0
2026-06-08 12:00:00	QQQ	ETF	719.89	721.82	718.48	719.1	2411077.0
2026-06-08 13:00:00	QQQ	ETF	719.125	720.14	716.8	718.57	3343285.0
2026-06-08 14:00:00	QQQ	ETF	718.59	720.005	717.87	718.21	2184645.0
2026-06-08 15:00:00	QQQ	ETF	718.21	718.3399	714.23	716.02	5666266.0
2026-06-08 16:00:00	QQQ	ETF	716.01	716.45	714.84	715.35	1696910.0
2026-06-08 17:00:00	QQQ	ETF	715.6	716.01	715.2	715.87	53391.0
2026-06-08 18:00:00	QQQ	ETF	715.78	716.3432	712.87	715.35	259968.0
2026-06-08 19:00:00	QQQ	ETF	715.18	716.7	714.4602	715.41	160692.0
2026-06-08 04:00:00	IWM	ETF	283.16	283.73	280.99	282.97	202796.0
2026-06-08 05:00:00	IWM	ETF	282.99	284.18	282.81	283.85	80574.0
2026-06-08 06:00:00	IWM	ETF	283.89	284.46	283.42	283.96	73577.0
2026-06-08 07:00:00	IWM	ETF	284.0383	285.8	283.84	285.18	460326.0
2026-06-08 08:00:00	IWM	ETF	285.19	286.2	285.19	285.6	430139.0
2026-06-08 09:00:00	IWM	ETF	285.63	286.15	283.99	284.165	4231367.0
2026-06-08 10:00:00	IWM	ETF	284.17	286.52	284.145	286.49	3552222.0
2026-06-08 11:00:00	IWM	ETF	286.48	286.84	285.31	285.63	2237470.0
2026-06-08 12:00:00	IWM	ETF	285.67	286.06	285.01	285.12	2101690.0
2026-06-08 13:00:00	IWM	ETF	285.12	285.14	283.575	284.38	2582272.0
2026-06-08 14:00:00	IWM	ETF	284.405	285.38	284.405	284.64	1777035.0
2026-06-08 15:00:00	IWM	ETF	284.64	284.91	283.7	284.12	3435036.0
2026-06-08 16:00:00	IWM	ETF	284.13	284.52	283.97	284.1	785180.0
2026-06-08 17:00:00	IWM	ETF	284.15	284.29	283.87	284.05	28289.0
2026-06-08 18:00:00	IWM	ETF	284.05	284.16	282.9218	283.69	55406.0
2026-06-08 19:00:00	IWM	ETF	283.72	284.17	283.28	283.68	28147.0
2026-06-08 04:00:00	DIA	ETF	508.75	508.81	507.41	508.18	12713.0
2026-06-08 05:00:00	DIA	ETF	508.33	509.57	508.2	509.23	10280.0

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

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