PREVIEW / etf_1hour / 2026-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-20.parquet
  size:    711 KB
  rows:    28,300

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-05-20 04:00:00	SPY	ETF	734.3	736.5	732.5	736.0	75842.0
2026-05-20 05:00:00	SPY	ETF	735.95	736.7	735.46	736.32	38415.0
2026-05-20 06:00:00	SPY	ETF	736.43	737.32	736.12	736.12	50565.0
2026-05-20 07:00:00	SPY	ETF	736.21	736.95	735.78	736.0	254251.0
2026-05-20 08:00:00	SPY	ETF	735.9416	737.72	735.941	736.45	264666.0
2026-05-20 09:00:00	SPY	ETF	736.39	737.23	734.27	736.13	4111069.0
2026-05-20 10:00:00	SPY	ETF	736.14	739.48	733.89	739.2	6722478.0
2026-05-20 11:00:00	SPY	ETF	739.19	741.87	738.59	740.24	5505225.0
2026-05-20 12:00:00	SPY	ETF	740.26	740.53	738.5112	739.365	2920915.0
2026-05-20 13:00:00	SPY	ETF	739.4	740.72	738.74	739.85	2649342.0
2026-05-20 14:00:00	SPY	ETF	739.86	740.85	739.3	740.165	3176474.0
2026-05-20 15:00:00	SPY	ETF	740.165	741.61	740.02	741.3	7487117.0
2026-05-20 16:00:00	SPY	ETF	741.3	741.43	739.0395	739.55	2280507.0
2026-05-20 17:00:00	SPY	ETF	739.67	740.19	738.9	739.9	207332.0
2026-05-20 18:00:00	SPY	ETF	739.57	739.57	737.08	738.14	317234.0
2026-05-20 19:00:00	SPY	ETF	738.0918	738.79	737.81	738.305	32105.0
2026-05-20 04:00:00	QQQ	ETF	704.21	706.87	700.49	705.95	279031.0
2026-05-20 05:00:00	QQQ	ETF	705.96	707.17	705.2	706.52	70473.0
2026-05-20 06:00:00	QQQ	ETF	706.59	707.29	706.1	706.14	72640.0
2026-05-20 07:00:00	QQQ	ETF	706.185	706.66	705.15	705.5016	137564.0
2026-05-20 08:00:00	QQQ	ETF	705.5	707.5796	701.004	706.07	338948.0
2026-05-20 09:00:00	QQQ	ETF	706.03	708.23	704.11	706.0	4198442.0
2026-05-20 10:00:00	QQQ	ETF	705.99	710.31	703.79	709.905	5504669.0
2026-05-20 11:00:00	QQQ	ETF	709.84	713.13	709.165	711.5702	3776149.0
2026-05-20 12:00:00	QQQ	ETF	711.61	711.7	708.61	709.87	2906578.0
2026-05-20 13:00:00	QQQ	ETF	709.91	711.44	709.09	710.87	2019373.0
2026-05-20 14:00:00	QQQ	ETF	710.9	711.9	710.2603	710.83	2004390.0
2026-05-20 15:00:00	QQQ	ETF	710.86	713.12	710.8	713.07	4653604.0
2026-05-20 16:00:00	QQQ	ETF	713.07	713.15	709.55	710.34	2020461.0
2026-05-20 17:00:00	QQQ	ETF	710.47	711.3	709.8	710.3	170303.0
2026-05-20 18:00:00	QQQ	ETF	710.28	710.28	706.45	708.29	350742.0
2026-05-20 19:00:00	QQQ	ETF	708.2	709.06	707.66	708.25	131353.0
2026-05-20 04:00:00	IWM	ETF	273.39	274.2	272.24	273.99	47298.0
2026-05-20 05:00:00	IWM	ETF	273.94	274.13	273.65	274.01	17195.0
2026-05-20 06:00:00	IWM	ETF	274.12	274.67	274.11	274.13	63161.0
2026-05-20 07:00:00	IWM	ETF	274.21	274.47	273.92	274.15	112006.0
2026-05-20 08:00:00	IWM	ETF	274.12	275.15	274.12	274.65	67053.0
2026-05-20 09:00:00	IWM	ETF	274.61	276.08	273.41	275.705	3177914.0
2026-05-20 10:00:00	IWM	ETF	275.71	278.58	274.79	278.45	5406556.0
2026-05-20 11:00:00	IWM	ETF	278.41	279.92	277.92	279.235	4758952.0
2026-05-20 12:00:00	IWM	ETF	279.23	279.5	278.2	278.76	2269627.0
2026-05-20 13:00:00	IWM	ETF	278.77	279.53	278.355	278.94	1485495.0
2026-05-20 14:00:00	IWM	ETF	278.93	279.47	278.67	278.98	1771077.0
2026-05-20 15:00:00	IWM	ETF	278.99	280.09	278.99	279.84	4522913.0
2026-05-20 16:00:00	IWM	ETF	279.87	279.91	279.49	279.67	1141166.0
2026-05-20 17:00:00	IWM	ETF	279.74	279.74	279.29	279.44	95763.0
2026-05-20 18:00:00	IWM	ETF	279.47	279.66	278.53	278.7548	101015.0
2026-05-20 19:00:00	IWM	ETF	278.75	278.9	278.6	278.79	45559.0
2026-05-20 04:00:00	DIA	ETF	493.83	494.58	493.6	494.57	1623.0
2026-05-20 05:00:00	DIA	ETF	494.53	494.63	494.33	494.63	2961.0

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

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