PREVIEW / etf_1hour / 2026-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-09.parquet
  size:    726 KB
  rows:    29,141

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-04-09 04:00:00	SPY	ETF	673.97	675.27	672.88	673.2	170725.0
2026-04-09 05:00:00	SPY	ETF	673.18	673.81	672.87	673.77	22498.0
2026-04-09 06:00:00	SPY	ETF	673.75	674.0	673.34	673.41	68814.0
2026-04-09 07:00:00	SPY	ETF	673.41	674.46	673.01	674.247	289914.0
2026-04-09 08:00:00	SPY	ETF	674.213	674.88	673.64	674.27	430893.0
2026-04-09 09:00:00	SPY	ETF	674.27	675.79	673.99	675.12	4354906.0
2026-04-09 10:00:00	SPY	ETF	675.115	675.69	673.77	675.24	6301717.0
2026-04-09 11:00:00	SPY	ETF	675.25	678.9	674.61	678.81	8316700.0
2026-04-09 12:00:00	SPY	ETF	678.805	680.75	678.69	679.85	6075010.0
2026-04-09 13:00:00	SPY	ETF	679.85	681.16	679.66	680.41	4336201.0
2026-04-09 14:00:00	SPY	ETF	680.425	680.61	678.44	679.23	5264309.0
2026-04-09 15:00:00	SPY	ETF	679.24	680.67	678.95	680.08	6964582.0
2026-04-09 16:00:00	SPY	ETF	680.07	680.22	679.27	679.47	3308352.0
2026-04-09 17:00:00	SPY	ETF	679.55	679.8	678.199	679.41	288810.0
2026-04-09 18:00:00	SPY	ETF	679.41	679.81	678.9	678.921	148294.0
2026-04-09 19:00:00	SPY	ETF	679.01	679.42	678.7	679.121	64476.0
2026-04-09 20:00:00	SPY	ETF	679.179	679.28	679.15	679.28	1370.0
2026-04-09 04:00:00	QQQ	ETF	603.3	605.39	602.9	603.4	352660.0
2026-04-09 05:00:00	QQQ	ETF	603.43	604.44	603.18	604.36	56346.0
2026-04-09 06:00:00	QQQ	ETF	604.44	604.67	603.8	603.93	104382.0
2026-04-09 07:00:00	QQQ	ETF	603.97	604.91	603.48	604.83	210566.0
2026-04-09 08:00:00	QQQ	ETF	604.83	605.5	604.41	604.73	317104.0
2026-04-09 09:00:00	QQQ	ETF	604.6	606.67	604.12	604.61	3913042.0
2026-04-09 10:00:00	QQQ	ETF	604.58	605.33	603.03	604.92	4726143.0
2026-04-09 11:00:00	QQQ	ETF	604.98	608.76	604.379	608.555	5055684.0
2026-04-09 12:00:00	QQQ	ETF	608.54	610.36	607.911	608.73	4363784.0
2026-04-09 13:00:00	QQQ	ETF	608.7	610.16	608.52	609.375	2754418.0
2026-04-09 14:00:00	QQQ	ETF	609.38	609.565	607.5	608.505	3152731.0
2026-04-09 15:00:00	QQQ	ETF	608.508	610.5	608.27	610.09	4301669.0
2026-04-09 16:00:00	QQQ	ETF	610.07	610.21	607.211	609.73	2549897.0
2026-04-09 17:00:00	QQQ	ETF	609.85	610.1	609.171	609.7	82947.0
2026-04-09 18:00:00	QQQ	ETF	609.59	610.17	608.98	609.05	139278.0
2026-04-09 19:00:00	QQQ	ETF	609.02	609.67	608.722	609.337	68218.0
2026-04-09 20:00:00	QQQ	ETF	609.45	609.47	609.4	609.4	1161.0
2026-04-09 04:00:00	IWM	ETF	258.98	260.18	258.55	258.69	42262.0
2026-04-09 05:00:00	IWM	ETF	258.7	258.92	258.47	258.91	13030.0
2026-04-09 06:00:00	IWM	ETF	258.92	259.03	258.47	258.48	56318.0
2026-04-09 07:00:00	IWM	ETF	258.6	258.99	258.29	258.86	155711.0
2026-04-09 08:00:00	IWM	ETF	258.9	258.99	258.35	258.696	246636.0
2026-04-09 09:00:00	IWM	ETF	258.65	260.57	258.448	260.28	2456764.0
2026-04-09 10:00:00	IWM	ETF	260.27	260.39	259.0	260.055	2046798.0
2026-04-09 11:00:00	IWM	ETF	260.08	261.66	259.55	261.64	2679530.0
2026-04-09 12:00:00	IWM	ETF	261.64	262.435	261.59	262.43	1824657.0
2026-04-09 13:00:00	IWM	ETF	262.42	262.9	262.35	262.58	1308462.0
2026-04-09 14:00:00	IWM	ETF	262.575	262.66	261.39	261.62	1828247.0
2026-04-09 15:00:00	IWM	ETF	261.62	262.4	261.53	261.94	2940633.0
2026-04-09 16:00:00	IWM	ETF	261.945	262.06	261.72	261.82	1213760.0
2026-04-09 17:00:00	IWM	ETF	261.7	261.88	261.35	261.75	47699.0
2026-04-09 18:00:00	IWM	ETF	261.77	261.81	261.32	261.35	65936.0
2026-04-09 19:00:00	IWM	ETF	261.35	261.46	261.19	261.244	108313.0

> showing 50 of 29,141 rows — these rows as CSV

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