PREVIEW / etf_1hour / 2026-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-22.parquet
  size:    707 KB
  rows:    28,148

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-22 04:00:00	SPY	ETF	746.94	747.75	745.11	746.36	66242.0
2026-07-22 05:00:00	SPY	ETF	746.33	747.01	745.91	746.36	23764.0
2026-07-22 06:00:00	SPY	ETF	746.58	747.13	746.37	746.81	51060.0
2026-07-22 07:00:00	SPY	ETF	746.879	746.88	745.05	745.61	215957.0
2026-07-22 08:00:00	SPY	ETF	745.61	746.12	744.3	745.32	315884.0
2026-07-22 09:00:00	SPY	ETF	745.36	748.785	745.35	748.78	2873838.0
2026-07-22 10:00:00	SPY	ETF	748.77	749.38	746.68	747.935	3543472.0
2026-07-22 11:00:00	SPY	ETF	747.93	749.79	747.89	749.76	2463432.0
2026-07-22 12:00:00	SPY	ETF	749.76	750.02	749.48	749.83	1825686.0
2026-07-22 13:00:00	SPY	ETF	749.835	749.96	748.39	748.52	1966619.0
2026-07-22 14:00:00	SPY	ETF	748.515	748.71	748.01	748.41	2427412.0
2026-07-22 15:00:00	SPY	ETF	748.44	748.46	747.295	747.39	5994637.0
2026-07-22 16:00:00	SPY	ETF	747.34	749.06	746.89	747.8	2146929.0
2026-07-22 17:00:00	SPY	ETF	747.81	748.26	746.33	746.84	410290.0
2026-07-22 18:00:00	SPY	ETF	747.0	747.21	745.34	745.96	130050.0
2026-07-22 19:00:00	SPY	ETF	745.9	746.68	745.44	746.68	45973.0
2026-07-22 04:00:00	QQQ	ETF	703.85	707.15	702.22	704.07	333420.0
2026-07-22 05:00:00	QQQ	ETF	704.1	705.01	703.57	704.46	76076.0
2026-07-22 06:00:00	QQQ	ETF	704.52	705.59	704.19	705.16	116608.0
2026-07-22 07:00:00	QQQ	ETF	705.19	705.44	701.87	702.7	385256.0
2026-07-22 08:00:00	QQQ	ETF	702.88	708.439	700.5	701.88	610206.0
2026-07-22 09:00:00	QQQ	ETF	701.9	708.1	701.88	708.1	3466629.0
2026-07-22 10:00:00	QQQ	ETF	708.09	708.24	705.58	707.19	3102258.0
2026-07-22 11:00:00	QQQ	ETF	707.2	709.65	707.2	709.37	2528903.0
2026-07-22 12:00:00	QQQ	ETF	709.35	709.4876	708.07	708.87	1230382.0
2026-07-22 13:00:00	QQQ	ETF	708.88	709.35	707.04	707.2738	1141939.0
2026-07-22 14:00:00	QQQ	ETF	707.27	707.93	706.39	707.34	1117587.0
2026-07-22 15:00:00	QQQ	ETF	707.34	707.68	705.19	705.22	2784426.0
2026-07-22 16:00:00	QQQ	ETF	705.27	707.64	703.35	705.4251	1341418.0
2026-07-22 17:00:00	QQQ	ETF	705.7	706.52	703.07	704.1303	381718.0
2026-07-22 18:00:00	QQQ	ETF	704.16	704.71	702.34	703.1099	187044.0
2026-07-22 19:00:00	QQQ	ETF	703.0203	704.81	702.04	704.81	124720.0
2026-07-22 04:00:00	IWM	ETF	295.57	296.06	294.78	295.93	82774.0
2026-07-22 05:00:00	IWM	ETF	295.93	296.1	295.3	295.73	45587.0
2026-07-22 06:00:00	IWM	ETF	295.76	295.95	295.58	295.78	32819.0
2026-07-22 07:00:00	IWM	ETF	295.6523	295.96	294.75	295.05	289501.0
2026-07-22 08:00:00	IWM	ETF	295.06	295.55	294.61	295.1	157163.0
2026-07-22 09:00:00	IWM	ETF	295.1	296.44	295.1	296.02	1927097.0
2026-07-22 10:00:00	IWM	ETF	296.02	296.16	293.95	294.09	3000804.0
2026-07-22 11:00:00	IWM	ETF	294.09	295.19	294.09	294.79	1302303.0
2026-07-22 12:00:00	IWM	ETF	294.79	295.0	294.395	294.6003	942448.0
2026-07-22 13:00:00	IWM	ETF	294.6	294.69	294.2434	294.39	1017755.0
2026-07-22 14:00:00	IWM	ETF	294.4	294.49	293.9	294.05	1376174.0
2026-07-22 15:00:00	IWM	ETF	294.05	294.06	293.41	293.77	3076098.0
2026-07-22 16:00:00	IWM	ETF	293.79	294.25	293.74	294.17	920768.0
2026-07-22 17:00:00	IWM	ETF	294.15	294.15	293.62	293.73	47114.0
2026-07-22 18:00:00	IWM	ETF	293.86	294.27	293.05	293.33	116228.0
2026-07-22 19:00:00	IWM	ETF	293.33	293.6	293.08	293.6	16932.0
2026-07-22 04:00:00	DIA	ETF	521.05	521.52	519.95	521.21	7328.0
2026-07-22 05:00:00	DIA	ETF	521.56	521.56	521.06	521.13	2409.0

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

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