PREVIEW / etf_1hour / 2026-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-06.parquet
  size:    754 KB
  rows:    30,004

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-06 04:00:00	SPY	ETF	725.16	729.31	725.16	728.74	150832.0
2026-05-06 05:00:00	SPY	ETF	728.56	729.37	727.48	729.3	85506.0
2026-05-06 06:00:00	SPY	ETF	729.3479	731.5	729.15	730.8385	244052.0
2026-05-06 07:00:00	SPY	ETF	730.82	731.7	729.67	729.86	450634.0
2026-05-06 08:00:00	SPY	ETF	729.89	729.95	727.7	728.97	660298.0
2026-05-06 09:00:00	SPY	ETF	728.96	729.8	727.82	729.65	4092086.0
2026-05-06 10:00:00	SPY	ETF	729.67	732.56	728.71	732.1501	5445150.0
2026-05-06 11:00:00	SPY	ETF	732.16	732.49	730.94	731.64	3831039.0
2026-05-06 12:00:00	SPY	ETF	731.63	732.05	730.5288	730.985	2190429.0
2026-05-06 13:00:00	SPY	ETF	730.99	732.13	730.66	732.125	2430653.0
2026-05-06 14:00:00	SPY	ETF	732.13	733.46	732.03	732.96	3736745.0
2026-05-06 15:00:00	SPY	ETF	732.953	734.59	732.93	733.79	10873887.0
2026-05-06 16:00:00	SPY	ETF	733.76	734.57	733.5	733.76	4742977.0
2026-05-06 17:00:00	SPY	ETF	733.7249	733.9	732.97	733.12	131914.0
2026-05-06 18:00:00	SPY	ETF	733.07	733.3896	732.714	732.86	83289.0
2026-05-06 19:00:00	SPY	ETF	732.81	733.24	732.81	733.0	30942.0
2026-05-06 04:00:00	QQQ	ETF	686.7	690.79	685.72	690.0	283508.0
2026-05-06 05:00:00	QQQ	ETF	689.98	690.78	688.4	690.6	305653.0
2026-05-06 06:00:00	QQQ	ETF	690.65	693.14	690.52	692.48	336276.0
2026-05-06 07:00:00	QQQ	ETF	692.46	693.69	690.82	691.36	500501.0
2026-05-06 08:00:00	QQQ	ETF	691.32	691.38	688.75	689.42	514688.0
2026-05-06 09:00:00	QQQ	ETF	689.41	690.52	686.48	689.63	5022423.0
2026-05-06 10:00:00	QQQ	ETF	689.63	691.59	687.62	691.28	5372132.0
2026-05-06 11:00:00	QQQ	ETF	691.28	692.47	690.83	691.88	3166403.0
2026-05-06 12:00:00	QQQ	ETF	691.88	692.86	690.74	691.33	2165122.0
2026-05-06 13:00:00	QQQ	ETF	691.37	693.05	691.1	692.81	1730820.0
2026-05-06 14:00:00	QQQ	ETF	692.805	694.39	692.63	693.77	2556518.0
2026-05-06 15:00:00	QQQ	ETF	693.743	695.93	693.7	695.575	6942054.0
2026-05-06 16:00:00	QQQ	ETF	695.54	697.64	694.8313	695.55	2050685.0
2026-05-06 17:00:00	QQQ	ETF	695.5	696.35	693.55	693.78	282959.0
2026-05-06 18:00:00	QQQ	ETF	693.75	695.19	693.75	694.5	170679.0
2026-05-06 19:00:00	QQQ	ETF	694.5418	695.06	694.24	694.51	60561.0
2026-05-06 04:00:00	IWM	ETF	283.47	285.51	282.9	285.23	153271.0
2026-05-06 05:00:00	IWM	ETF	285.13	286.77	284.58	286.73	100508.0
2026-05-06 06:00:00	IWM	ETF	286.71	289.0	286.7	288.67	556164.0
2026-05-06 07:00:00	IWM	ETF	288.67	289.19	287.42	287.5	667031.0
2026-05-06 08:00:00	IWM	ETF	287.49	287.55	285.83	286.01	471605.0
2026-05-06 09:00:00	IWM	ETF	285.85	286.06	283.99	284.2	4040326.0
2026-05-06 10:00:00	IWM	ETF	284.17	285.65	283.36	285.4	3127866.0
2026-05-06 11:00:00	IWM	ETF	285.4	286.135	284.86	285.15	1928762.0
2026-05-06 12:00:00	IWM	ETF	285.14	285.51	284.88	285.14	1053363.0
2026-05-06 13:00:00	IWM	ETF	285.1492	286.06	285.05	285.72	1063069.0
2026-05-06 14:00:00	IWM	ETF	285.73	286.39	285.65	286.085	1456251.0
2026-05-06 15:00:00	IWM	ETF	286.08	287.045	286.07	286.81	2963374.0
2026-05-06 16:00:00	IWM	ETF	286.8	286.91	286.25	286.47	653249.0
2026-05-06 17:00:00	IWM	ETF	286.43	286.43	285.97	286.26	31947.0
2026-05-06 18:00:00	IWM	ETF	286.3	286.6	286.21	286.32	93556.0
2026-05-06 19:00:00	IWM	ETF	286.3035	286.33	286.15	286.29	16217.0
2026-05-06 04:00:00	DIA	ETF	494.05	496.55	493.53	496.16	11507.0
2026-05-06 05:00:00	DIA	ETF	496.12	497.02	495.39	497.02	7060.0

> showing 50 of 30,004 rows — these rows as CSV

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