PREVIEW / etf_1hour / 2026-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-04.parquet
  size:    723 KB
  rows:    29,061

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-04 04:00:00	SPY	ETF	751.72	753.0	751.0	751.45	409636.0
2026-06-04 05:00:00	SPY	ETF	751.1	752.22	750.54	751.99	82211.0
2026-06-04 06:00:00	SPY	ETF	752.05	752.0699	750.12	750.67	64750.0
2026-06-04 07:00:00	SPY	ETF	750.63	751.9	749.8	751.73	485083.0
2026-06-04 08:00:00	SPY	ETF	751.7235	752.54	751.06	752.3036	433991.0
2026-06-04 09:00:00	SPY	ETF	752.22	753.7	751.47	753.2	4386200.0
2026-06-04 10:00:00	SPY	ETF	753.18	754.29	752.23	754.21	4211384.0
2026-06-04 11:00:00	SPY	ETF	754.215	755.97	754.2	755.34	4195467.0
2026-06-04 12:00:00	SPY	ETF	755.35	756.93	755.2	756.795	3282717.0
2026-06-04 13:00:00	SPY	ETF	756.79	757.74	756.59	757.685	2281210.0
2026-06-04 14:00:00	SPY	ETF	757.68	758.0	757.5	757.62	3614443.0
2026-06-04 15:00:00	SPY	ETF	757.64	758.31	756.8	757.06	9316043.0
2026-06-04 16:00:00	SPY	ETF	757.05	757.31	755.88	756.0999	2599456.0
2026-06-04 17:00:00	SPY	ETF	756.0	756.8	755.94	756.0003	70292.0
2026-06-04 18:00:00	SPY	ETF	756.08	756.15	755.07	755.84	76157.0
2026-06-04 19:00:00	SPY	ETF	755.85	755.85	754.56	754.56	38467.0
2026-06-04 04:00:00	QQQ	ETF	740.61	742.15	736.93	737.3	268192.0
2026-06-04 05:00:00	QQQ	ETF	737.36	737.4	735.04	737.0	309722.0
2026-06-04 06:00:00	QQQ	ETF	736.92	737.01	733.93	734.92	248300.0
2026-06-04 07:00:00	QQQ	ETF	734.95	736.0	733.03	735.82	561907.0
2026-06-04 08:00:00	QQQ	ETF	735.77	743.652	734.44	736.47	538344.0
2026-06-04 09:00:00	QQQ	ETF	736.45	737.81	733.56	735.0	6291270.0
2026-06-04 10:00:00	QQQ	ETF	735.0	737.58	732.62	737.54	4690309.0
2026-06-04 11:00:00	QQQ	ETF	737.56	740.27	737.5	738.94	3400618.0
2026-06-04 12:00:00	QQQ	ETF	738.96	740.88	738.48	740.52	1934911.0
2026-06-04 13:00:00	QQQ	ETF	740.52	742.57	740.18	742.5	2118718.0
2026-06-04 14:00:00	QQQ	ETF	742.495	743.43	742.22	742.4021	2499073.0
2026-06-04 15:00:00	QQQ	ETF	742.44	743.4988	740.38	740.5	5283176.0
2026-06-04 16:00:00	QQQ	ETF	740.49	740.75	738.55	738.76	1726016.0
2026-06-04 17:00:00	QQQ	ETF	739.02	739.16	738.75	739.05	159785.0
2026-06-04 18:00:00	QQQ	ETF	739.1	739.1	736.6239	737.799	145332.0
2026-06-04 19:00:00	QQQ	ETF	737.8	737.84	735.2	735.38	149311.0
2026-06-04 04:00:00	IWM	ETF	288.46	288.87	287.46	287.94	69882.0
2026-06-04 05:00:00	IWM	ETF	287.74	288.63	287.54	288.39	30337.0
2026-06-04 06:00:00	IWM	ETF	288.33	288.33	287.22	287.46	27078.0
2026-06-04 07:00:00	IWM	ETF	287.45	288.89	287.45	288.82	242903.0
2026-06-04 08:00:00	IWM	ETF	288.89	289.22	288.16	288.51	246731.0
2026-06-04 09:00:00	IWM	ETF	288.45	289.15	286.66	289.01	3296670.0
2026-06-04 10:00:00	IWM	ETF	289.02	290.88	288.53	290.83	3557618.0
2026-06-04 11:00:00	IWM	ETF	290.83	291.95	290.441	290.88	2022641.0
2026-06-04 12:00:00	IWM	ETF	290.89	291.4901	290.56	291.435	1290765.0
2026-06-04 13:00:00	IWM	ETF	291.435	291.83	291.18	291.78	1286636.0
2026-06-04 14:00:00	IWM	ETF	291.785	292.675	291.7126	292.3	1471626.0
2026-06-04 15:00:00	IWM	ETF	292.31	292.875	291.93	291.97	2621901.0
2026-06-04 16:00:00	IWM	ETF	291.988	292.1	291.28	291.57	1224653.0
2026-06-04 17:00:00	IWM	ETF	291.46	291.7942	291.1499	291.39	48943.0
2026-06-04 18:00:00	IWM	ETF	291.39	291.45	291.07	291.39	48740.0
2026-06-04 19:00:00	IWM	ETF	291.4	291.42	290.69	290.73	23032.0
2026-06-04 04:00:00	DIA	ETF	507.99	510.25	507.99	509.41	10072.0
2026-06-04 05:00:00	DIA	ETF	509.3	510.61	509.3	510.61	2010.0

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

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