PREVIEW / etf_1hour / 2026-06-09

all etf 1-hour files

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

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-09 04:00:00	SPY	ETF	741.12	742.62	740.7	742.05	95763.0
2026-06-09 05:00:00	SPY	ETF	741.94	742.875	741.94	742.72	14452.0
2026-06-09 06:00:00	SPY	ETF	742.75	743.39	741.21	742.95	111368.0
2026-06-09 07:00:00	SPY	ETF	742.86	743.19	742.11	742.149	133417.0
2026-06-09 08:00:00	SPY	ETF	742.22	743.41	741.96	743.33	174193.0
2026-06-09 09:00:00	SPY	ETF	743.37	746.9	742.72	744.38	4636743.0
2026-06-09 10:00:00	SPY	ETF	744.3638	745.045	734.65	737.75	10626976.0
2026-06-09 11:00:00	SPY	ETF	737.79	738.42	728.96	729.06	8954771.0
2026-06-09 12:00:00	SPY	ETF	729.08	730.57	722.59	726.62	13954584.0
2026-06-09 13:00:00	SPY	ETF	726.62	733.95	726.4	732.56	8505317.0
2026-06-09 14:00:00	SPY	ETF	732.65	737.13	732.14	736.74	6101955.0
2026-06-09 15:00:00	SPY	ETF	736.74	737.69	732.53	737.05	11747629.0
2026-06-09 16:00:00	SPY	ETF	737.07	737.729	736.1304	736.7	2893913.0
2026-06-09 17:00:00	SPY	ETF	736.75	736.75	735.2	735.5	204776.0
2026-06-09 18:00:00	SPY	ETF	735.64	736.49	734.26	734.8	222636.0
2026-06-09 19:00:00	SPY	ETF	734.85	735.75	734.33	735.7	62759.0
2026-06-09 04:00:00	QQQ	ETF	719.4	721.85	718.98	720.74	240784.0
2026-06-09 05:00:00	QQQ	ETF	720.77	722.05	720.67	721.93	73832.0
2026-06-09 06:00:00	QQQ	ETF	721.8	722.15	720.23	721.81	135187.0
2026-06-09 07:00:00	QQQ	ETF	721.75	722.77	721.43	721.6999	244208.0
2026-06-09 08:00:00	QQQ	ETF	721.75	723.01	715.533	722.92	406227.0
2026-06-09 09:00:00	QQQ	ETF	722.97	725.66	720.49	721.505	5098046.0
2026-06-09 10:00:00	QQQ	ETF	721.47	722.4	707.16	710.9401	11193981.0
2026-06-09 11:00:00	QQQ	ETF	710.99	712.43	697.4	697.71	11297391.0
2026-06-09 12:00:00	QQQ	ETF	697.75	699.94	686.37	692.565	15915010.0
2026-06-09 13:00:00	QQQ	ETF	692.55	703.37	692.2	701.02	9911989.0
2026-06-09 14:00:00	QQQ	ETF	701.03	707.31	699.92	706.74	6510706.0
2026-06-09 15:00:00	QQQ	ETF	706.7	708.6	701.18	707.88	10329656.0
2026-06-09 16:00:00	QQQ	ETF	707.94	709.84	707.16	708.44	1918985.0
2026-06-09 17:00:00	QQQ	ETF	708.48	708.63	705.58	706.1	205581.0
2026-06-09 18:00:00	QQQ	ETF	706.2	707.81	704.7	705.62	409254.0
2026-06-09 19:00:00	QQQ	ETF	705.69	707.5	704.6009	706.67	313554.0
2026-06-09 04:00:00	IWM	ETF	285.23	286.44	284.89	286.21	74295.0
2026-06-09 05:00:00	IWM	ETF	286.18	286.85	286.16	286.85	31874.0
2026-06-09 06:00:00	IWM	ETF	286.65	287.18	285.81	287.02	156745.0
2026-06-09 07:00:00	IWM	ETF	286.941	287.1	286.4	286.59	55440.0
2026-06-09 08:00:00	IWM	ETF	286.55	287.35	286.55	287.03	168140.0
2026-06-09 09:00:00	IWM	ETF	287.04	290.87	286.59	290.44	3543917.0
2026-06-09 10:00:00	IWM	ETF	290.45	290.65	284.15	285.93	6834468.0
2026-06-09 11:00:00	IWM	ETF	285.92	286.02	280.97	280.97	4553828.0
2026-06-09 12:00:00	IWM	ETF	280.99	281.79	277.62	279.555	6837459.0
2026-06-09 13:00:00	IWM	ETF	279.6	283.77	279.4	283.13	3753832.0
2026-06-09 14:00:00	IWM	ETF	283.13	285.46	282.82	285.27	3013441.0
2026-06-09 15:00:00	IWM	ETF	285.255	285.68	283.72	284.98	5021374.0
2026-06-09 16:00:00	IWM	ETF	285.02	285.33	284.52	285.03	1153063.0
2026-06-09 17:00:00	IWM	ETF	285.04	285.17	283.93	284.38	56083.0
2026-06-09 18:00:00	IWM	ETF	284.54	284.85	283.35	283.77	185575.0
2026-06-09 19:00:00	IWM	ETF	283.8	284.29	283.48	284.2	36529.0
2026-06-09 04:00:00	DIA	ETF	509.66	510.09	508.94	509.77	3402.0
2026-06-09 05:00:00	DIA	ETF	510.35	510.35	510.35	510.35	60.0

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

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