PREVIEW / etf_1hour / 2026-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-17.parquet
  size:    713 KB
  rows:    28,718

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-17 04:00:00	SPY	ETF	745.82	745.82	742.58	743.4199	156251.0
2026-07-17 05:00:00	SPY	ETF	743.37	744.54	743.19	744.51	101742.0
2026-07-17 06:00:00	SPY	ETF	744.49	745.68	744.23	745.24	140368.0
2026-07-17 07:00:00	SPY	ETF	745.251	745.64	744.47	745.36	137588.0
2026-07-17 08:00:00	SPY	ETF	745.34	745.45	743.77	743.94	288496.0
2026-07-17 09:00:00	SPY	ETF	743.89	744.83	740.8	744.8101	7304277.0
2026-07-17 10:00:00	SPY	ETF	744.81	747.29	744.6701	745.05	5845135.0
2026-07-17 11:00:00	SPY	ETF	745.05	747.06	743.96	746.87	3854363.0
2026-07-17 12:00:00	SPY	ETF	746.88	747.27	744.83	746.32	3476309.0
2026-07-17 13:00:00	SPY	ETF	746.37	747.17	744.38	744.58	3121654.0
2026-07-17 14:00:00	SPY	ETF	744.58	745.14	743.095	744.37	3773168.0
2026-07-17 15:00:00	SPY	ETF	744.39	744.47	742.13	743.23	9130526.0
2026-07-17 16:00:00	SPY	ETF	743.18	743.29	742.0	743.18	5642751.0
2026-07-17 17:00:00	SPY	ETF	743.13	743.34	742.75	743.16	262021.0
2026-07-17 18:00:00	SPY	ETF	743.19	743.76	743.02	743.57	31384.0
2026-07-17 19:00:00	SPY	ETF	743.36	743.5	742.42	742.5	49496.0
2026-07-17 04:00:00	QQQ	ETF	693.48	698.9	690.28	692.08	575040.0
2026-07-17 05:00:00	QQQ	ETF	691.99	694.5	691.88	694.04	182656.0
2026-07-17 06:00:00	QQQ	ETF	693.94	696.8	693.65	695.8979	378721.0
2026-07-17 07:00:00	QQQ	ETF	695.88	696.44	694.22	694.78	243101.0
2026-07-17 08:00:00	QQQ	ETF	694.82	694.93	692.51	693.09	380480.0
2026-07-17 09:00:00	QQQ	ETF	692.9	693.54	686.76	693.35	7872280.0
2026-07-17 10:00:00	QQQ	ETF	693.42	698.57	693.04	694.47	6532877.0
2026-07-17 11:00:00	QQQ	ETF	694.54	699.87	693.13	699.49	3783746.0
2026-07-17 12:00:00	QQQ	ETF	699.49	701.77	697.35	700.5	3741877.0
2026-07-17 13:00:00	QQQ	ETF	700.53	702.3	698.28	698.6001	3044524.0
2026-07-17 14:00:00	QQQ	ETF	698.64	699.53	696.12	697.7	2668803.0
2026-07-17 15:00:00	QQQ	ETF	697.69	697.85	694.22	695.3	4641371.0
2026-07-17 16:00:00	QQQ	ETF	695.33	695.69	694.14	695.53	3113622.0
2026-07-17 17:00:00	QQQ	ETF	695.5	695.5	694.6	694.63	106922.0
2026-07-17 18:00:00	QQQ	ETF	694.716	695.3	694.5	694.76	42294.0
2026-07-17 19:00:00	QQQ	ETF	694.76	694.76	693.5	693.6	77778.0
2026-07-17 04:00:00	IWM	ETF	293.77	294.19	292.84	293.27	60621.0
2026-07-17 05:00:00	IWM	ETF	293.31	293.87	293.17	293.87	8217.0
2026-07-17 06:00:00	IWM	ETF	293.94	294.24	293.65	294.11	121314.0
2026-07-17 07:00:00	IWM	ETF	294.08	294.17	293.69	294.01	67472.0
2026-07-17 08:00:00	IWM	ETF	293.98	294.01	293.05	293.12	115607.0
2026-07-17 09:00:00	IWM	ETF	293.1	294.97	291.64	294.68	4050540.0
2026-07-17 10:00:00	IWM	ETF	294.7	296.13	294.43	294.57	2772004.0
2026-07-17 11:00:00	IWM	ETF	294.55	294.678	293.4	294.39	3486483.0
2026-07-17 12:00:00	IWM	ETF	294.37	295.04	293.84	294.82	1721045.0
2026-07-17 13:00:00	IWM	ETF	294.83	295.48	294.2	294.27	1719412.0
2026-07-17 14:00:00	IWM	ETF	294.29	294.45	293.38	293.825	2463851.0
2026-07-17 15:00:00	IWM	ETF	293.83	294.35	292.955	294.09	2984754.0
2026-07-17 16:00:00	IWM	ETF	294.08	294.2571	293.53	293.87	793252.0
2026-07-17 17:00:00	IWM	ETF	293.99	294.0	293.57	293.57	32147.0
2026-07-17 18:00:00	IWM	ETF	293.58	294.05	293.4	293.86	22680.0
2026-07-17 19:00:00	IWM	ETF	293.99	293.9999	293.49	293.49	5942.0
2026-07-17 04:00:00	DIA	ETF	522.29	522.48	520.81	521.1	4698.0
2026-07-17 05:00:00	DIA	ETF	520.85	521.48	520.76	521.05	2185.0

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

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