PREVIEW / etf_1hour / 2026-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-16.parquet
  size:    704 KB
  rows:    27,761

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-16 04:00:00	SPY	ETF	754.32	754.91	753.42	754.53	76435.0
2026-06-16 05:00:00	SPY	ETF	754.51	754.72	753.79	753.92	19366.0
2026-06-16 06:00:00	SPY	ETF	753.93	754.94	753.93	754.88	21330.0
2026-06-16 07:00:00	SPY	ETF	754.871	755.35	754.69	755.04	126574.0
2026-06-16 08:00:00	SPY	ETF	755.0001	755.36	754.0	754.37	232327.0
2026-06-16 09:00:00	SPY	ETF	754.37	755.44	753.9	754.09	3156687.0
2026-06-16 10:00:00	SPY	ETF	754.11	755.29	752.27	752.93	4967784.0
2026-06-16 11:00:00	SPY	ETF	752.94	753.738	751.71	752.75	4251524.0
2026-06-16 12:00:00	SPY	ETF	752.74	753.97	752.332	752.73	2926959.0
2026-06-16 13:00:00	SPY	ETF	752.72	752.8	751.45	752.12	2377031.0
2026-06-16 14:00:00	SPY	ETF	752.105	752.35	751.63	751.78	2857836.0
2026-06-16 15:00:00	SPY	ETF	751.765	751.86	749.88	750.39	13089862.0
2026-06-16 16:00:00	SPY	ETF	750.39	750.46	749.0	749.92	2927068.0
2026-06-16 17:00:00	SPY	ETF	750.0	750.43	749.99	750.0	139403.0
2026-06-16 18:00:00	SPY	ETF	750.0	751.29	750.0	751.27	61497.0
2026-06-16 19:00:00	SPY	ETF	751.26	751.26	750.62	750.75	39377.0
2026-06-16 04:00:00	QQQ	ETF	741.75	745.61	741.75	745.23	260588.0
2026-06-16 05:00:00	QQQ	ETF	745.15	745.27	743.7	743.82	78043.0
2026-06-16 06:00:00	QQQ	ETF	743.86	745.35	743.86	745.32	55179.0
2026-06-16 07:00:00	QQQ	ETF	745.27	746.28	745.07	745.48	174566.0
2026-06-16 08:00:00	QQQ	ETF	745.48	745.75	742.32	742.7	420690.0
2026-06-16 09:00:00	QQQ	ETF	742.72	744.22	740.82	742.21	3592325.0
2026-06-16 10:00:00	QQQ	ETF	742.26	743.42	736.2875	737.2	6480764.0
2026-06-16 11:00:00	QQQ	ETF	737.2	738.7296	732.51	733.95	5161078.0
2026-06-16 12:00:00	QQQ	ETF	733.96	736.54	733.43	734.6699	3284827.0
2026-06-16 13:00:00	QQQ	ETF	734.62	735.06	732.27	734.04	2962084.0
2026-06-16 14:00:00	QQQ	ETF	734.0488	734.47	732.76	733.18	2420062.0
2026-06-16 15:00:00	QQQ	ETF	733.17	734.0401	729.64	729.76	6984918.0
2026-06-16 16:00:00	QQQ	ETF	729.82	732.2838	729.02	729.75	1744050.0
2026-06-16 17:00:00	QQQ	ETF	729.79	730.92	729.79	730.57	136506.0
2026-06-16 18:00:00	QQQ	ETF	730.51	731.85	730.06	731.729	154177.0
2026-06-16 19:00:00	QQQ	ETF	731.6522	731.6522	730.06	730.4413	123175.0
2026-06-16 04:00:00	IWM	ETF	295.25	295.46	294.72	295.11	72635.0
2026-06-16 05:00:00	IWM	ETF	295.08	295.16	294.63	294.64	16037.0
2026-06-16 06:00:00	IWM	ETF	294.67	294.98	294.67	294.98	11280.0
2026-06-16 07:00:00	IWM	ETF	295.01	295.27	294.84	295.209	20301.0
2026-06-16 08:00:00	IWM	ETF	295.21	295.5	294.88	295.12	213091.0
2026-06-16 09:00:00	IWM	ETF	295.1	296.68	294.91	296.0	2934843.0
2026-06-16 10:00:00	IWM	ETF	296.02	296.8	293.02	293.17	3229764.0
2026-06-16 11:00:00	IWM	ETF	293.18	294.07	292.63	293.41	2068580.0
2026-06-16 12:00:00	IWM	ETF	293.41	294.2	293.19	293.86	1433494.0
2026-06-16 13:00:00	IWM	ETF	293.86	293.93	293.07	293.69	1171653.0
2026-06-16 14:00:00	IWM	ETF	293.68	293.97	293.12	293.19	1086370.0
2026-06-16 15:00:00	IWM	ETF	293.17	293.25	291.58	292.13	3089148.0
2026-06-16 16:00:00	IWM	ETF	292.08	292.11	291.4	291.79	1437629.0
2026-06-16 17:00:00	IWM	ETF	291.73	291.96	291.64	291.95	19841.0
2026-06-16 18:00:00	IWM	ETF	291.85	292.37	291.56	292.35	44715.0
2026-06-16 19:00:00	IWM	ETF	292.31	292.31	292.04	292.09	32370.0
2026-06-16 04:00:00	DIA	ETF	519.13	519.41	518.69	518.69	14367.0
2026-06-16 05:00:00	DIA	ETF	518.9	519.04	518.5	518.5	3224.0

> showing 50 of 27,761 rows — these rows as CSV

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