PREVIEW / etf_1hour / 2026-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-27.parquet
  size:    719 KB
  rows:    28,827

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-27 04:00:00	SPY	ETF	753.56	753.56	750.24	752.45	81228.0
2026-05-27 05:00:00	SPY	ETF	752.37	752.76	752.27	752.66	19351.0
2026-05-27 06:00:00	SPY	ETF	752.7	753.11	752.62	752.84	48152.0
2026-05-27 07:00:00	SPY	ETF	752.9	753.29	751.7636	751.77	258774.0
2026-05-27 08:00:00	SPY	ETF	751.78	754.0	751.25	751.95	485849.0
2026-05-27 09:00:00	SPY	ETF	751.9666	752.05	749.23	750.49	5322024.0
2026-05-27 10:00:00	SPY	ETF	750.505	751.38	749.27	749.68	4511742.0
2026-05-27 11:00:00	SPY	ETF	749.69	750.2	748.37	749.105	3129965.0
2026-05-27 12:00:00	SPY	ETF	749.09	750.615	748.54	749.79	2409198.0
2026-05-27 13:00:00	SPY	ETF	749.79	750.05	748.22	749.72	2296085.0
2026-05-27 14:00:00	SPY	ETF	749.71	751.0501	749.3	750.81	2770206.0
2026-05-27 15:00:00	SPY	ETF	750.82	751.13	750.1	750.47	6487227.0
2026-05-27 16:00:00	SPY	ETF	750.49	752.18	750.2925	752.0	1996774.0
2026-05-27 17:00:00	SPY	ETF	751.9	751.93	751.4	751.84	106508.0
2026-05-27 18:00:00	SPY	ETF	751.89	752.25	750.46	751.18	495293.0
2026-05-27 19:00:00	SPY	ETF	751.2217	751.45	749.8	750.05	51405.0
2026-05-27 04:00:00	QQQ	ETF	732.57	733.65	729.85	733.2	208842.0
2026-05-27 05:00:00	QQQ	ETF	733.13	733.59	732.61	733.537	71799.0
2026-05-27 06:00:00	QQQ	ETF	733.5761	734.39	733.54	734.08	97070.0
2026-05-27 07:00:00	QQQ	ETF	734.12	735.59	734.09	734.8	188727.0
2026-05-27 08:00:00	QQQ	ETF	734.8	737.6	729.733	734.75	543904.0
2026-05-27 09:00:00	QQQ	ETF	734.8	734.97	726.86	729.9	6865155.0
2026-05-27 10:00:00	QQQ	ETF	729.84	730.83	725.44	726.92	5670038.0
2026-05-27 11:00:00	QQQ	ETF	726.94	727.9199	725.53	726.8	3184511.0
2026-05-27 12:00:00	QQQ	ETF	726.79	729.56	726.11	728.0996	2697744.0
2026-05-27 13:00:00	QQQ	ETF	728.1	728.31	725.855	727.74	1932930.0
2026-05-27 14:00:00	QQQ	ETF	727.72	729.85	727.5	729.3202	1689334.0
2026-05-27 15:00:00	QQQ	ETF	729.31	730.0699	728.59	729.49	3367371.0
2026-05-27 16:00:00	QQQ	ETF	729.47	731.4	729.2	731.4	1286543.0
2026-05-27 17:00:00	QQQ	ETF	731.25	731.38	730.48	730.69	227038.0
2026-05-27 18:00:00	QQQ	ETF	730.98	731.5	729.0	729.82	158714.0
2026-05-27 19:00:00	QQQ	ETF	729.73	730.17	727.51	727.817	129449.0
2026-05-27 04:00:00	IWM	ETF	290.99	292.51	290.97	292.42	34667.0
2026-05-27 05:00:00	IWM	ETF	292.46	292.8	292.31	292.51	55713.0
2026-05-27 06:00:00	IWM	ETF	292.52	292.8	292.45	292.48	102363.0
2026-05-27 07:00:00	IWM	ETF	292.4803	292.84	291.71	291.73	226733.0
2026-05-27 08:00:00	IWM	ETF	291.7	293.15	291.37	291.82	454720.0
2026-05-27 09:00:00	IWM	ETF	291.87	291.92	289.31	290.83	4342956.0
2026-05-27 10:00:00	IWM	ETF	290.85	291.72	290.03	290.21	3629179.0
2026-05-27 11:00:00	IWM	ETF	290.21	291.25	289.57	289.82	2439052.0
2026-05-27 12:00:00	IWM	ETF	289.825	291.215	289.52	290.955	1523092.0
2026-05-27 13:00:00	IWM	ETF	290.955	291.05	289.83	290.29	1176501.0
2026-05-27 14:00:00	IWM	ETF	290.27	290.86	290.13	290.44	1051882.0
2026-05-27 15:00:00	IWM	ETF	290.44	290.53	289.885	290.36	2498340.0
2026-05-27 16:00:00	IWM	ETF	290.37	290.94	290.29	290.82	983012.0
2026-05-27 17:00:00	IWM	ETF	290.83	290.83	290.57	290.77	11215.0
2026-05-27 18:00:00	IWM	ETF	290.8	291.0	290.45	290.6	53154.0
2026-05-27 19:00:00	IWM	ETF	290.62	290.83	289.89	290.09	65246.0
2026-05-27 04:00:00	DIA	ETF	506.07	507.3	505.74	507.3	4108.0
2026-05-27 05:00:00	DIA	ETF	507.38	507.58	507.38	507.57	3021.0

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

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