PREVIEW / etf_1hour / 2026-05-22

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-22.parquet
  size:    707 KB
  rows:    28,165

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-22 04:00:00	SPY	ETF	745.45	746.6	744.77	745.1	118826.0
2026-05-22 05:00:00	SPY	ETF	745.06	745.14	743.88	744.89	19037.0
2026-05-22 06:00:00	SPY	ETF	744.82	744.9	743.63	744.11	39583.0
2026-05-22 07:00:00	SPY	ETF	744.07	745.2	743.88	744.72	98817.0
2026-05-22 08:00:00	SPY	ETF	744.72	746.93	744.5	746.8897	399075.0
2026-05-22 09:00:00	SPY	ETF	746.91	748.16	745.65	747.54	3648570.0
2026-05-22 10:00:00	SPY	ETF	747.55	747.56	744.48	746.49	3275680.0
2026-05-22 11:00:00	SPY	ETF	746.49	748.04	746.45	747.61	2346087.0
2026-05-22 12:00:00	SPY	ETF	747.6	747.75	746.85	747.28	1875145.0
2026-05-22 13:00:00	SPY	ETF	747.305	748.94	746.63	747.37	3734467.0
2026-05-22 14:00:00	SPY	ETF	747.3798	747.69	746.81	747.12	2502818.0
2026-05-22 15:00:00	SPY	ETF	747.12	747.27	744.955	745.59	6911970.0
2026-05-22 16:00:00	SPY	ETF	745.59	746.03	744.84	745.04	2007801.0
2026-05-22 17:00:00	SPY	ETF	745.01	745.17	744.81	745.17	245381.0
2026-05-22 18:00:00	SPY	ETF	745.11	745.16	744.38	744.64	45476.0
2026-05-22 19:00:00	SPY	ETF	744.55	744.69	743.73	743.73	47589.0
2026-05-22 04:00:00	QQQ	ETF	717.6	720.1036	716.87	717.73	224215.0
2026-05-22 05:00:00	QQQ	ETF	717.69	717.73	715.67	716.8	214360.0
2026-05-22 06:00:00	QQQ	ETF	716.67	716.67	714.67	715.43	174899.0
2026-05-22 07:00:00	QQQ	ETF	715.35	716.8	715.06	716.38	170058.0
2026-05-22 08:00:00	QQQ	ETF	716.43	718.48	713.975	718.35	259261.0
2026-05-22 09:00:00	QQQ	ETF	718.48	721.33	717.36	719.545	3940234.0
2026-05-22 10:00:00	QQQ	ETF	719.55	719.868	715.95	719.67	4167803.0
2026-05-22 11:00:00	QQQ	ETF	719.71	721.28	719.64	720.67	2660498.0
2026-05-22 12:00:00	QQQ	ETF	720.68	720.82	719.4	720.305	1570019.0
2026-05-22 13:00:00	QQQ	ETF	720.32	722.12	719.72	720.47	2792445.0
2026-05-22 14:00:00	QQQ	ETF	720.485	720.7	719.195	719.79	2313893.0
2026-05-22 15:00:00	QQQ	ETF	719.78	720.04	716.925	717.43	5134502.0
2026-05-22 16:00:00	QQQ	ETF	717.44	718.1	716.17	716.77	1514265.0
2026-05-22 17:00:00	QQQ	ETF	716.72	717.41	716.72	717.21	121226.0
2026-05-22 18:00:00	QQQ	ETF	717.21	717.3	716.4	716.48	46356.0
2026-05-22 19:00:00	QQQ	ETF	716.51	716.52	715.31	715.31	64153.0
2026-05-22 04:00:00	IWM	ETF	283.95	284.11	282.98	283.41	74847.0
2026-05-22 05:00:00	IWM	ETF	283.31	283.31	282.73	283.04	48306.0
2026-05-22 06:00:00	IWM	ETF	283.02	283.02	282.2	282.37	31350.0
2026-05-22 07:00:00	IWM	ETF	282.49	283.38	282.48	282.9	110287.0
2026-05-22 08:00:00	IWM	ETF	282.9	284.72	282.839	284.65	576853.0
2026-05-22 09:00:00	IWM	ETF	284.75	285.71	283.745	285.58	3076141.0
2026-05-22 10:00:00	IWM	ETF	285.58	285.61	283.67	284.71	2420170.0
2026-05-22 11:00:00	IWM	ETF	284.7	285.37	284.03	285.21	1230872.0
2026-05-22 12:00:00	IWM	ETF	285.22	285.47	284.67	285.1917	1242376.0
2026-05-22 13:00:00	IWM	ETF	285.19	286.61	284.81	285.55	2065053.0
2026-05-22 14:00:00	IWM	ETF	285.54	285.75	285.17	285.55	2187218.0
2026-05-22 15:00:00	IWM	ETF	285.54	285.55	284.475	285.11	4452051.0
2026-05-22 16:00:00	IWM	ETF	285.11	285.17	284.46	284.5	873421.0
2026-05-22 17:00:00	IWM	ETF	284.5	284.91	284.13	284.51	72448.0
2026-05-22 18:00:00	IWM	ETF	284.49	284.59	284.3	284.54	4147.0
2026-05-22 19:00:00	IWM	ETF	284.5	284.51	283.53	283.8	46573.0
2026-05-22 04:00:00	DIA	ETF	504.49	505.35	504.32	505.0	4736.0
2026-05-22 05:00:00	DIA	ETF	504.34	504.98	504.31	504.98	1692.0

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

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