PREVIEW / etf_1hour / 2026-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-07.parquet
  size:    752 KB
  rows:    29,427

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-07-07 04:00:00	SPY	ETF	749.39	750.45	748.5	750.01	130821.0
2026-07-07 05:00:00	SPY	ETF	750.01	750.41	749.8	750.3	18319.0
2026-07-07 06:00:00	SPY	ETF	750.42	750.56	749.52	749.91	47148.0
2026-07-07 07:00:00	SPY	ETF	749.93	750.12	749.44	750.03	114395.0
2026-07-07 08:00:00	SPY	ETF	750.1	750.89	750.059	750.26	133681.0
2026-07-07 09:00:00	SPY	ETF	750.28	750.96	748.25	748.85	3979605.0
2026-07-07 10:00:00	SPY	ETF	748.8504	749.2	745.21	746.445	6127721.0
2026-07-07 11:00:00	SPY	ETF	746.46	747.45	745.43	747.36	3326672.0
2026-07-07 12:00:00	SPY	ETF	747.38	749.13	747.25	748.96	3434498.0
2026-07-07 13:00:00	SPY	ETF	748.96	749.34	748.42	749.18	2189449.0
2026-07-07 14:00:00	SPY	ETF	749.18	749.3	747.42	747.51	3405241.0
2026-07-07 15:00:00	SPY	ETF	747.5	747.97	746.0	747.69	9186200.0
2026-07-07 16:00:00	SPY	ETF	747.66	747.78	747.03	747.47	1868073.0
2026-07-07 17:00:00	SPY	ETF	747.59	747.66	745.95	746.47	302506.0
2026-07-07 18:00:00	SPY	ETF	746.57	747.08	746.11	747.08	88516.0
2026-07-07 19:00:00	SPY	ETF	747.0	747.5	746.11	746.16	82627.0
2026-07-07 04:00:00	QQQ	ETF	715.38	717.73	713.39	715.82	269988.0
2026-07-07 05:00:00	QQQ	ETF	715.66	716.56	714.9	715.86	50042.0
2026-07-07 06:00:00	QQQ	ETF	715.84	716.44	714.9	715.72	197374.0
2026-07-07 07:00:00	QQQ	ETF	715.71	715.7888	714.17	715.37	369488.0
2026-07-07 08:00:00	QQQ	ETF	715.31	722.278	714.9	715.35	386031.0
2026-07-07 09:00:00	QQQ	ETF	715.34	716.35	709.97	711.1728	5200975.0
2026-07-07 10:00:00	QQQ	ETF	711.12	712.025	704.9	707.19	7096373.0
2026-07-07 11:00:00	QQQ	ETF	707.17	709.26	705.84	709.2	3234782.0
2026-07-07 12:00:00	QQQ	ETF	709.21	713.31	708.99	712.87	3716526.0
2026-07-07 13:00:00	QQQ	ETF	712.81	713.87	712.2	713.56	2404944.0
2026-07-07 14:00:00	QQQ	ETF	713.58	713.74	709.15	709.31	2400992.0
2026-07-07 15:00:00	QQQ	ETF	709.35	709.79	706.41	709.495	5254307.0
2026-07-07 16:00:00	QQQ	ETF	709.52	710.419	709.3	710.08	1638597.0
2026-07-07 17:00:00	QQQ	ETF	710.0	710.1	707.88	708.29	234800.0
2026-07-07 18:00:00	QQQ	ETF	708.44	709.69	707.71	709.24	298892.0
2026-07-07 19:00:00	QQQ	ETF	709.14	709.65	706.96	707.0836	93963.0
2026-07-07 04:00:00	IWM	ETF	298.63	299.22	297.92	299.1	23241.0
2026-07-07 05:00:00	IWM	ETF	298.93	299.49	298.93	299.49	10060.0
2026-07-07 06:00:00	IWM	ETF	299.61	299.69	299.34	299.42	34681.0
2026-07-07 07:00:00	IWM	ETF	299.46	300.2	299.21	300.11	28031.0
2026-07-07 08:00:00	IWM	ETF	300.09	300.41	299.88	299.92	79974.0
2026-07-07 09:00:00	IWM	ETF	299.84	299.972	296.39	297.02	2427254.0
2026-07-07 10:00:00	IWM	ETF	297.01	297.12	295.18	296.42	2873628.0
2026-07-07 11:00:00	IWM	ETF	296.41	297.19	296.22	296.67	1735810.0
2026-07-07 12:00:00	IWM	ETF	296.68	297.82	296.67	297.435	1539846.0
2026-07-07 13:00:00	IWM	ETF	297.4501	297.77	297.055	297.5	738844.0
2026-07-07 14:00:00	IWM	ETF	297.51	297.59	296.34	296.44	927951.0
2026-07-07 15:00:00	IWM	ETF	296.42	296.66	295.52	296.2	3456951.0
2026-07-07 16:00:00	IWM	ETF	296.19	296.22	295.88	296.02	791074.0
2026-07-07 17:00:00	IWM	ETF	295.95	296.12	294.83	295.28	116698.0
2026-07-07 18:00:00	IWM	ETF	295.29	295.8999	295.28	295.78	25819.0
2026-07-07 19:00:00	IWM	ETF	295.78	295.991	295.48	295.5196	12972.0
2026-07-07 04:00:00	DIA	ETF	530.12	531.22	529.76	531.0542	4879.0
2026-07-07 05:00:00	DIA	ETF	530.78	531.25	530.78	531.25	2638.0

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

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