PREVIEW / etf_1hour / 2026-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-18.parquet
  size:    723 KB
  rows:    28,381

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-18 04:00:00	SPY	ETF	746.05	747.0	744.35	745.11	162150.0
2026-06-18 05:00:00	SPY	ETF	745.0	746.58	744.92	746.43	27706.0
2026-06-18 06:00:00	SPY	ETF	746.51	746.65	745.43	745.47	73264.0
2026-06-18 07:00:00	SPY	ETF	745.5005	746.0	743.35	744.43	236994.0
2026-06-18 08:00:00	SPY	ETF	744.44	746.59	744.24	746.14	323184.0
2026-06-18 09:00:00	SPY	ETF	746.13	748.2	743.86	744.75	5594550.0
2026-06-18 10:00:00	SPY	ETF	744.81	747.31	744.25	746.84	5991038.0
2026-06-18 11:00:00	SPY	ETF	746.86	747.07	744.331	746.2501	4257597.0
2026-06-18 12:00:00	SPY	ETF	746.26	747.25	745.75	746.64	2759672.0
2026-06-18 13:00:00	SPY	ETF	746.66	748.13	746.42	747.01	3128384.0
2026-06-18 14:00:00	SPY	ETF	747.02	747.08	746.16	746.385	3023628.0
2026-06-18 15:00:00	SPY	ETF	746.39	748.23	745.2	746.56	11112024.0
2026-06-18 16:00:00	SPY	ETF	746.56	748.499	746.4	747.7	5442337.0
2026-06-18 17:00:00	SPY	ETF	747.7	748.17	746.74	747.98	341396.0
2026-06-18 18:00:00	SPY	ETF	747.92	748.18	746.34	746.51	127911.0
2026-06-18 19:00:00	SPY	ETF	746.51	747.14	746.43	746.94	28632.0
2026-06-18 04:00:00	QQQ	ETF	733.51	734.91	729.0	732.59	278256.0
2026-06-18 05:00:00	QQQ	ETF	732.39	734.88	732.39	734.74	130096.0
2026-06-18 06:00:00	QQQ	ETF	734.73	734.88	733.11	733.35	154972.0
2026-06-18 07:00:00	QQQ	ETF	733.39	733.94	731.61	733.16	280703.0
2026-06-18 08:00:00	QQQ	ETF	733.17	735.76	721.969	735.22	511159.0
2026-06-18 09:00:00	QQQ	ETF	735.2188	737.65	732.51	734.205	5902049.0
2026-06-18 10:00:00	QQQ	ETF	734.31	738.8	733.87	737.88	5126273.0
2026-06-18 11:00:00	QQQ	ETF	737.9	739.14	734.94	738.3	3414011.0
2026-06-18 12:00:00	QQQ	ETF	738.28	739.85	737.98	739.335	2618068.0
2026-06-18 13:00:00	QQQ	ETF	739.34	740.62	738.67	739.93	1807870.0
2026-06-18 14:00:00	QQQ	ETF	739.96	740.22	738.911	739.475	1637276.0
2026-06-18 15:00:00	QQQ	ETF	739.49	741.82	738.43	739.66	6623580.0
2026-06-18 16:00:00	QQQ	ETF	739.66	744.3665	739.35	740.33	4242515.0
2026-06-18 17:00:00	QQQ	ETF	740.17	741.31	740.17	741.2133	308325.0
2026-06-18 18:00:00	QQQ	ETF	741.06	741.48	738.82	739.18	210580.0
2026-06-18 19:00:00	QQQ	ETF	739.1381	739.93	739.02	739.8285	97966.0
2026-06-18 04:00:00	IWM	ETF	293.47	293.91	292.26	292.53	93945.0
2026-06-18 05:00:00	IWM	ETF	292.51	293.63	292.45	293.46	70412.0
2026-06-18 06:00:00	IWM	ETF	293.52	293.55	293.21	293.4	158631.0
2026-06-18 07:00:00	IWM	ETF	293.3304	293.49	292.13	292.7	127305.0
2026-06-18 08:00:00	IWM	ETF	292.7	294.05	292.33	293.86	241300.0
2026-06-18 09:00:00	IWM	ETF	293.83	295.11	292.745	293.0	3614238.0
2026-06-18 10:00:00	IWM	ETF	293.0	294.4	291.42	294.25	3104912.0
2026-06-18 11:00:00	IWM	ETF	294.25	294.31	292.7	293.85	2142821.0
2026-06-18 12:00:00	IWM	ETF	293.85	294.3	293.74	294.02	925038.0
2026-06-18 13:00:00	IWM	ETF	294.015	294.81	293.79	294.57	1042345.0
2026-06-18 14:00:00	IWM	ETF	294.57	294.91	294.225	294.66	1288095.0
2026-06-18 15:00:00	IWM	ETF	294.65	295.97	294.0	295.52	4013803.0
2026-06-18 16:00:00	IWM	ETF	295.59	296.14	295.28	295.44	2709206.0
2026-06-18 17:00:00	IWM	ETF	295.51	295.81	295.5	295.63	172834.0
2026-06-18 18:00:00	IWM	ETF	295.63	295.86	294.92	295.08	45592.0
2026-06-18 19:00:00	IWM	ETF	295.01	295.23	294.92	295.18	23986.0
2026-06-18 04:00:00	DIA	ETF	518.07	518.09	517.26	517.26	6340.0
2026-06-18 05:00:00	DIA	ETF	517.26	518.13	517.24	518.13	734.0

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

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