PREVIEW / etf_1hour / 2026-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-20.parquet
  size:    704 KB
  rows:    28,414

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-20 04:00:00	SPY	ETF	744.07	745.69	742.81	744.9607	64143.0
2026-07-20 05:00:00	SPY	ETF	744.97	746.24	744.65	745.7	105442.0
2026-07-20 06:00:00	SPY	ETF	745.74	745.95	745.2	745.71	32813.0
2026-07-20 07:00:00	SPY	ETF	745.701	748.01	745.58	747.088	240390.0
2026-07-20 08:00:00	SPY	ETF	747.055	747.055	745.66	746.25	270548.0
2026-07-20 09:00:00	SPY	ETF	746.28	748.73	745.52	745.69	4050464.0
2026-07-20 10:00:00	SPY	ETF	745.68	746.36	743.69	744.11	3994514.0
2026-07-20 11:00:00	SPY	ETF	744.14	746.44	743.805	745.99	2829538.0
2026-07-20 12:00:00	SPY	ETF	746.0	747.005	744.47	745.0	3599319.0
2026-07-20 13:00:00	SPY	ETF	745.01	745.21	743.56	744.55	2897394.0
2026-07-20 14:00:00	SPY	ETF	744.55	745.38	742.43	742.72	3700935.0
2026-07-20 15:00:00	SPY	ETF	742.76	743.34	741.5103	742.1	8731091.0
2026-07-20 16:00:00	SPY	ETF	742.15	742.87	741.32	742.0	2425213.0
2026-07-20 17:00:00	SPY	ETF	741.95	742.05	741.45	742.05	91984.0
2026-07-20 18:00:00	SPY	ETF	742.07	742.1	740.96	741.1602	51644.0
2026-07-20 19:00:00	SPY	ETF	741.15	742.69	741.15	742.1377	40451.0
2026-07-20 04:00:00	QQQ	ETF	697.12	699.7	695.55	698.26	180492.0
2026-07-20 05:00:00	QQQ	ETF	698.38	701.09	697.65	700.01	98024.0
2026-07-20 06:00:00	QQQ	ETF	700.07	700.56	699.24	700.38	119107.0
2026-07-20 07:00:00	QQQ	ETF	700.37	703.75	700.3	702.83	439895.0
2026-07-20 08:00:00	QQQ	ETF	702.8	702.8	700.74	701.75	265923.0
2026-07-20 09:00:00	QQQ	ETF	701.8	705.8	700.66	701.09	4159208.0
2026-07-20 10:00:00	QQQ	ETF	701.07	702.37	698.11	698.54	3734727.0
2026-07-20 11:00:00	QQQ	ETF	698.51	702.72	698.08	702.38	2112857.0
2026-07-20 12:00:00	QQQ	ETF	702.4099	704.02	700.135	700.82	2366282.0
2026-07-20 13:00:00	QQQ	ETF	700.79	701.16	698.8	700.1499	1529336.0
2026-07-20 14:00:00	QQQ	ETF	700.16	701.42	697.72	698.07	1874991.0
2026-07-20 15:00:00	QQQ	ETF	698.09	698.68	695.51	696.0	4568904.0
2026-07-20 16:00:00	QQQ	ETF	695.98	701.78	695.15	695.78	712325.0
2026-07-20 17:00:00	QQQ	ETF	695.78	696.2	695.75	696.1	57654.0
2026-07-20 18:00:00	QQQ	ETF	696.1	696.37	694.06	694.4	135636.0
2026-07-20 19:00:00	QQQ	ETF	694.41	697.02	694.3	695.82	98232.0
2026-07-20 04:00:00	IWM	ETF	294.67	295.06	293.47	294.81	28705.0
2026-07-20 05:00:00	IWM	ETF	294.82	295.23	294.77	294.96	49027.0
2026-07-20 06:00:00	IWM	ETF	295.0	295.29	294.71	295.29	28048.0
2026-07-20 07:00:00	IWM	ETF	295.1303	296.55	295.1102	295.82	232412.0
2026-07-20 08:00:00	IWM	ETF	295.8	295.8	294.69	294.87	202013.0
2026-07-20 09:00:00	IWM	ETF	294.85	295.99	294.57	294.73	1928767.0
2026-07-20 10:00:00	IWM	ETF	294.72	294.98	292.54	292.83	2046881.0
2026-07-20 11:00:00	IWM	ETF	292.84	294.12	292.6	293.63	1678686.0
2026-07-20 12:00:00	IWM	ETF	293.64	294.45	293.18	293.6	1395524.0
2026-07-20 13:00:00	IWM	ETF	293.6	293.89	293.28	293.78	713046.0
2026-07-20 14:00:00	IWM	ETF	293.78	294.22	293.06	293.21	1561104.0
2026-07-20 15:00:00	IWM	ETF	293.19	293.334	292.18	292.31	3695885.0
2026-07-20 16:00:00	IWM	ETF	292.33	292.57	292.01	292.4	785717.0
2026-07-20 17:00:00	IWM	ETF	292.44	292.45	292.1476	292.44	7370.0
2026-07-20 18:00:00	IWM	ETF	292.31	292.32	291.9	292.17	16237.0
2026-07-20 19:00:00	IWM	ETF	292.2	292.7	292.2	292.47	14141.0
2026-07-20 04:00:00	DIA	ETF	520.46	521.67	520.15	521.67	380.0
2026-07-20 05:00:00	DIA	ETF	521.79	522.49	521.77	522.49	1854.0

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

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