PREVIEW / etf_1hour / 2026-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-05.parquet
  size:    777 KB
  rows:    29,787

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-01-05 04:00:00	SPY	ETF	684.25	685.17	684.25	684.58	124489.0
2026-01-05 05:00:00	SPY	ETF	684.68	685.3	684.61	685.27	35265.0
2026-01-05 06:00:00	SPY	ETF	685.24	685.5	685.0	685.44	115943.0
2026-01-05 07:00:00	SPY	ETF	685.37	685.69	684.96	685.25	268401.0
2026-01-05 08:00:00	SPY	ETF	685.3	685.71	683.81	685.42	362417.0
2026-01-05 09:00:00	SPY	ETF	685.42	687.88	685.4	687.06	9800044.0
2026-01-05 10:00:00	SPY	ETF	687.08	688.82	686.63	688.32	9029200.0
2026-01-05 11:00:00	SPY	ETF	688.32	689.43	687.96	688.91	7710219.0
2026-01-05 12:00:00	SPY	ETF	688.91	689.13	688.203	688.58	4681893.0
2026-01-05 13:00:00	SPY	ETF	688.57	688.775	687.65	688.54	4749816.0
2026-01-05 14:00:00	SPY	ETF	688.54	688.715	687.29	687.6198	5429877.0
2026-01-05 15:00:00	SPY	ETF	687.615	688.24	687.16	687.73	13686236.0
2026-01-05 16:00:00	SPY	ETF	687.73	687.9764	687.38	687.52	2250070.0
2026-01-05 17:00:00	SPY	ETF	687.54	688.1	687.469	687.81	48102.0
2026-01-05 18:00:00	SPY	ETF	687.83	687.9458	687.34	687.41	58716.0
2026-01-05 19:00:00	SPY	ETF	687.43	687.56	687.2	687.38	83523.0
2026-01-05 04:00:00	QQQ	ETF	616.01	616.66	615.82	616.21	74671.0
2026-01-05 05:00:00	QQQ	ETF	616.25	617.28	616.19	617.19	61183.0
2026-01-05 06:00:00	QQQ	ETF	617.2	617.76	616.99	617.52	77668.0
2026-01-05 07:00:00	QQQ	ETF	617.54	617.97	616.989	617.25	146773.0
2026-01-05 08:00:00	QQQ	ETF	617.3	618.07	612.661	617.71	593370.0
2026-01-05 09:00:00	QQQ	ETF	617.73	619.98	616.72	618.06	9186422.0
2026-01-05 10:00:00	QQQ	ETF	618.1	620.39	617.41	619.78	6197996.0
2026-01-05 11:00:00	QQQ	ETF	619.78	620.81	619.4601	619.65	4898781.0
2026-01-05 12:00:00	QQQ	ETF	619.66	619.99	618.425	618.9	3778988.0
2026-01-05 13:00:00	QQQ	ETF	618.89	619.03	617.22	618.565	4032512.0
2026-01-05 14:00:00	QQQ	ETF	618.57	618.7	617.04	617.7	3074856.0
2026-01-05 15:00:00	QQQ	ETF	617.7	618.58	617.45	617.95	5123660.0
2026-01-05 16:00:00	QQQ	ETF	617.95	618.0517	617.6302	617.7766	1515046.0
2026-01-05 17:00:00	QQQ	ETF	617.78	618.6	617.65	617.79	96291.0
2026-01-05 18:00:00	QQQ	ETF	617.79	618.15	617.3662	617.4691	77760.0
2026-01-05 19:00:00	QQQ	ETF	617.48	617.82	617.19	617.4082	42935.0
2026-01-05 04:00:00	IWM	ETF	248.64	249.01	248.62	248.85	65378.0
2026-01-05 05:00:00	IWM	ETF	248.81	249.03	248.69	248.94	14081.0
2026-01-05 06:00:00	IWM	ETF	248.98	249.1	248.86	249.1	14429.0
2026-01-05 07:00:00	IWM	ETF	249.11	249.25	248.97	249.24	27762.0
2026-01-05 08:00:00	IWM	ETF	249.26	249.5	248.23	249.46	151283.0
2026-01-05 09:00:00	IWM	ETF	249.44	251.4	249.41	250.96	5108333.0
2026-01-05 10:00:00	IWM	ETF	251.01	252.32	250.6601	251.77	5450953.0
2026-01-05 11:00:00	IWM	ETF	251.78	252.775	251.51	252.74	3275661.0
2026-01-05 12:00:00	IWM	ETF	252.75	253.06	252.595	252.775	2948086.0
2026-01-05 13:00:00	IWM	ETF	252.81	253.3	252.71	253.285	2082638.0
2026-01-05 14:00:00	IWM	ETF	253.285	253.55	253.0	253.275	2619455.0
2026-01-05 15:00:00	IWM	ETF	253.27	253.375	252.62	252.74	5316932.0
2026-01-05 16:00:00	IWM	ETF	252.73	252.77	252.46	252.5	1009416.0
2026-01-05 17:00:00	IWM	ETF	252.51	252.9	252.5	252.72	82777.0
2026-01-05 18:00:00	IWM	ETF	252.73	252.85	252.43	252.4552	72752.0
2026-01-05 19:00:00	IWM	ETF	252.42	252.55	252.31	252.38	23608.0
2026-01-05 04:00:00	DIA	ETF	484.07	484.22	483.6	483.81	11669.0
2026-01-05 05:00:00	DIA	ETF	483.82	484.09	483.74	483.75	1897.0

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

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