PREVIEW / etf_1hour / 2026-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-08.parquet
  size:    736 KB
  rows:    28,455

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-08 04:00:00	SPY	ETF	688.68	688.93	688.0	688.4	26973.0
2026-01-08 05:00:00	SPY	ETF	688.37	688.47	687.92	688.47	17407.0
2026-01-08 06:00:00	SPY	ETF	688.43	688.78	687.83	688.44	44039.0
2026-01-08 07:00:00	SPY	ETF	688.32	688.62	687.95	688.36	84895.0
2026-01-08 08:00:00	SPY	ETF	688.01	689.3746	687.0	689.1	321734.0
2026-01-08 09:00:00	SPY	ETF	689.07	689.3	687.49	688.28	9015237.0
2026-01-08 10:00:00	SPY	ETF	688.28	690.02	687.85	689.84	11201489.0
2026-01-08 11:00:00	SPY	ETF	689.85	690.085	688.44	689.9	7311556.0
2026-01-08 12:00:00	SPY	ETF	689.89	690.615	689.12	690.09	4654323.0
2026-01-08 13:00:00	SPY	ETF	690.09	690.19	688.76	688.89	5058477.0
2026-01-08 14:00:00	SPY	ETF	688.89	689.35	688.28	688.86	4746659.0
2026-01-08 15:00:00	SPY	ETF	688.85	690.055	688.71	689.44	10392680.0
2026-01-08 16:00:00	SPY	ETF	689.45	691.06	689.45	690.4	1941556.0
2026-01-08 17:00:00	SPY	ETF	690.4699	690.81	690.17	690.6198	92187.0
2026-01-08 18:00:00	SPY	ETF	690.61	690.7	689.65	689.75	118646.0
2026-01-08 19:00:00	SPY	ETF	689.7488	690.05	689.471	689.4714	40294.0
2026-01-08 04:00:00	QQQ	ETF	622.83	623.2	622.15	622.58	57974.0
2026-01-08 05:00:00	QQQ	ETF	622.57	622.69	621.97	622.64	42100.0
2026-01-08 06:00:00	QQQ	ETF	622.73	623.0	621.9	622.6	66070.0
2026-01-08 07:00:00	QQQ	ETF	622.65	622.8	622.1	622.57	81046.0
2026-01-08 08:00:00	QQQ	ETF	622.23	623.7787	620.29	623.35	391551.0
2026-01-08 09:00:00	QQQ	ETF	623.29	623.62	618.468	618.62	8422972.0
2026-01-08 10:00:00	QQQ	ETF	618.6	621.25	617.8	620.54	8801559.0
2026-01-08 11:00:00	QQQ	ETF	620.55	620.59	618.12	620.19	5197923.0
2026-01-08 12:00:00	QQQ	ETF	620.19	620.99	619.13	620.4211	3790189.0
2026-01-08 13:00:00	QQQ	ETF	620.42	620.515	618.96	619.2345	3841147.0
2026-01-08 14:00:00	QQQ	ETF	619.23	619.86	618.4	619.29	3508197.0
2026-01-08 15:00:00	QQQ	ETF	619.27	620.85	619.085	620.43	5500689.0
2026-01-08 16:00:00	QQQ	ETF	620.43	621.83	620.4	621.1	1139485.0
2026-01-08 17:00:00	QQQ	ETF	621.0634	621.67	620.98	621.37	61455.0
2026-01-08 18:00:00	QQQ	ETF	621.26	621.47	620.211	620.3	94155.0
2026-01-08 19:00:00	QQQ	ETF	620.29	620.74	620.08	620.1	54144.0
2026-01-08 04:00:00	IWM	ETF	254.96	255.08	254.36	254.46	13408.0
2026-01-08 05:00:00	IWM	ETF	254.45	254.48	254.17	254.48	40167.0
2026-01-08 06:00:00	IWM	ETF	254.48	254.58	254.22	254.47	87136.0
2026-01-08 07:00:00	IWM	ETF	254.47	254.58	254.3	254.58	26835.0
2026-01-08 08:00:00	IWM	ETF	254.91	255.04	254.03	254.72	137190.0
2026-01-08 09:00:00	IWM	ETF	254.6882	257.21	254.36	256.78	5042271.0
2026-01-08 10:00:00	IWM	ETF	256.79	257.9	256.12	257.11	5925329.0
2026-01-08 11:00:00	IWM	ETF	257.115	258.3	256.7	258.265	3622166.0
2026-01-08 12:00:00	IWM	ETF	258.26	258.87	257.8001	258.83	2777177.0
2026-01-08 13:00:00	IWM	ETF	258.82	258.93	257.97	258.095	2445254.0
2026-01-08 14:00:00	IWM	ETF	258.1	258.46	257.76	258.12	2475508.0
2026-01-08 15:00:00	IWM	ETF	258.12	258.395	257.95	258.28	5323131.0
2026-01-08 16:00:00	IWM	ETF	258.27	259.07	258.2438	258.94	1055309.0
2026-01-08 17:00:00	IWM	ETF	258.9	258.99	258.81	258.81	6118.0
2026-01-08 18:00:00	IWM	ETF	258.95	258.97	258.5	258.52	16937.0
2026-01-08 19:00:00	IWM	ETF	258.6	258.74	258.5	258.54	10222.0
2026-01-08 04:00:00	DIA	ETF	488.85	489.06	488.57	488.61	40528.0
2026-01-08 05:00:00	DIA	ETF	488.6	488.65	488.35	488.5	3250.0

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

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