PREVIEW / etf_1hour / 2026-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-09.parquet
  size:    733 KB
  rows:    28,396

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-09 04:00:00	SPY	ETF	689.43	690.4	689.37	690.38	26337.0
2026-01-09 05:00:00	SPY	ETF	690.46	690.54	690.24	690.33	16528.0
2026-01-09 06:00:00	SPY	ETF	690.35	690.93	690.21	690.44	31527.0
2026-01-09 07:00:00	SPY	ETF	690.4	690.93	690.14	690.84	72589.0
2026-01-09 08:00:00	SPY	ETF	690.41	692.42	689.33	692.23	781801.0
2026-01-09 09:00:00	SPY	ETF	692.24	692.5	690.42	691.51	8933270.0
2026-01-09 10:00:00	SPY	ETF	691.56	693.45	689.18	691.93	14088881.0
2026-01-09 11:00:00	SPY	ETF	691.94	694.03	691.93	693.89	8087455.0
2026-01-09 12:00:00	SPY	ETF	693.88	694.5	693.72	693.975	4800890.0
2026-01-09 13:00:00	SPY	ETF	693.96	694.8899	693.36	694.53	5038868.0
2026-01-09 14:00:00	SPY	ETF	694.52	695.23	694.36	694.8999	4859849.0
2026-01-09 15:00:00	SPY	ETF	694.89	695.31	693.9	693.99	13156370.0
2026-01-09 16:00:00	SPY	ETF	694.02	694.13	689.6022	694.03	7649119.0
2026-01-09 17:00:00	SPY	ETF	694.0292	694.14	693.9252	694.14	992842.0
2026-01-09 18:00:00	SPY	ETF	694.12	694.52	694.069	694.33	60824.0
2026-01-09 19:00:00	SPY	ETF	694.3394	694.5	694.18	694.48	24452.0
2026-01-09 04:00:00	QQQ	ETF	620.46	621.73	620.22	621.65	55102.0
2026-01-09 05:00:00	QQQ	ETF	621.72	622.03	621.56	621.85	45853.0
2026-01-09 06:00:00	QQQ	ETF	621.86	622.71	621.64	622.1	51928.0
2026-01-09 07:00:00	QQQ	ETF	622.05	622.34	621.44	622.24	70679.0
2026-01-09 08:00:00	QQQ	ETF	622.14	623.6	620.0	623.56	662039.0
2026-01-09 09:00:00	QQQ	ETF	623.61	624.02	619.84	621.9215	6752430.0
2026-01-09 10:00:00	QQQ	ETF	621.95	625.34	619.06	623.76	9351705.0
2026-01-09 11:00:00	QQQ	ETF	623.8	626.33	623.77	626.09	4970275.0
2026-01-09 12:00:00	QQQ	ETF	626.07	626.69	625.505	626.4	3531648.0
2026-01-09 13:00:00	QQQ	ETF	626.4	627.46	625.44	627.31	3811178.0
2026-01-09 14:00:00	QQQ	ETF	627.31	627.58	627.005	627.14	2463685.0
2026-01-09 15:00:00	QQQ	ETF	627.14	627.89	626.62	626.67	7168921.0
2026-01-09 16:00:00	QQQ	ETF	626.67	626.9	626.45	626.68	1458237.0
2026-01-09 17:00:00	QQQ	ETF	626.6834	626.84	626.59	626.7	417695.0
2026-01-09 18:00:00	QQQ	ETF	626.7	627.0	626.65	626.82	49521.0
2026-01-09 19:00:00	QQQ	ETF	626.87	627.049	626.75	626.87	15054.0
2026-01-09 04:00:00	IWM	ETF	258.15	258.79	258.02	258.79	17231.0
2026-01-09 05:00:00	IWM	ETF	258.74	258.9	258.66	258.71	14251.0
2026-01-09 06:00:00	IWM	ETF	258.74	259.1	258.74	258.82	47471.0
2026-01-09 07:00:00	IWM	ETF	258.79	259.11	258.79	259.04	14057.0
2026-01-09 08:00:00	IWM	ETF	258.98	260.22	258.17	259.68	257530.0
2026-01-09 09:00:00	IWM	ETF	259.68	261.19	259.1805	260.39	4464991.0
2026-01-09 10:00:00	IWM	ETF	260.43	260.74	258.09	260.34	6921737.0
2026-01-09 11:00:00	IWM	ETF	260.335	261.4976	260.25	261.435	2818022.0
2026-01-09 12:00:00	IWM	ETF	261.44	261.56	260.875	260.875	1915789.0
2026-01-09 13:00:00	IWM	ETF	260.87	261.055	260.35	260.66	2298675.0
2026-01-09 14:00:00	IWM	ETF	260.65	260.72	260.03	260.185	2095480.0
2026-01-09 15:00:00	IWM	ETF	260.18	260.52	259.81	260.22	5046425.0
2026-01-09 16:00:00	IWM	ETF	260.23	260.35	260.01	260.35	833183.0
2026-01-09 17:00:00	IWM	ETF	260.3175	260.3175	260.23	260.3	11522.0
2026-01-09 18:00:00	IWM	ETF	260.39	260.6	260.29	260.41	3741.0
2026-01-09 19:00:00	IWM	ETF	260.54	260.55	260.44	260.5442	2797.0
2026-01-09 04:00:00	DIA	ETF	492.45	492.95	492.45	492.95	5160.0
2026-01-09 05:00:00	DIA	ETF	492.89	492.89	492.82	492.83	1045.0

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

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