PREVIEW / etf_1hour / 2026-01-12

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-12.parquet
  size:    752 KB
  rows:    29,464

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-12 04:00:00	SPY	ETF	689.02	689.63	688.88	689.54	90296.0
2026-01-12 05:00:00	SPY	ETF	689.57	689.81	689.31	689.6	53237.0
2026-01-12 06:00:00	SPY	ETF	689.56	690.2	689.5	689.8	76531.0
2026-01-12 07:00:00	SPY	ETF	689.83	690.78	689.77	690.6	327299.0
2026-01-12 08:00:00	SPY	ETF	689.12	690.751	688.79	690.46	453535.0
2026-01-12 09:00:00	SPY	ETF	690.43	693.9	690.2	693.63	9390215.0
2026-01-12 10:00:00	SPY	ETF	693.64	694.06	692.96	693.91	9057966.0
2026-01-12 11:00:00	SPY	ETF	693.915	694.86	693.66	694.56	6519688.0
2026-01-12 12:00:00	SPY	ETF	694.56	694.8399	694.1	694.6601	4297435.0
2026-01-12 13:00:00	SPY	ETF	694.67	695.39	694.585	695.215	4538809.0
2026-01-12 14:00:00	SPY	ETF	695.21	696.03	694.945	695.945	5455571.0
2026-01-12 15:00:00	SPY	ETF	695.945	696.09	695.14	695.16	10718150.0
2026-01-12 16:00:00	SPY	ETF	695.155	695.45	694.58	694.72	2019624.0
2026-01-12 17:00:00	SPY	ETF	694.7301	695.19	694.73	695.09	219153.0
2026-01-12 18:00:00	SPY	ETF	695.09	695.09	694.21	694.24	159965.0
2026-01-12 19:00:00	SPY	ETF	694.21	694.33	693.86	693.87	71089.0
2026-01-12 04:00:00	QQQ	ETF	620.26	621.3	620.25	621.16	141689.0
2026-01-12 05:00:00	QQQ	ETF	621.15	621.68	620.88	621.36	92979.0
2026-01-12 06:00:00	QQQ	ETF	621.34	621.96	621.32	621.55	86130.0
2026-01-12 07:00:00	QQQ	ETF	621.6	622.64	621.48	622.47	221498.0
2026-01-12 08:00:00	QQQ	ETF	621.64	622.69	619.6	622.24	625625.0
2026-01-12 09:00:00	QQQ	ETF	622.21	626.54	621.67	625.97	6832950.0
2026-01-12 10:00:00	QQQ	ETF	625.99	626.76	625.09	626.325	6500544.0
2026-01-12 11:00:00	QQQ	ETF	626.32	627.61	625.99	627.4	3491885.0
2026-01-12 12:00:00	QQQ	ETF	627.4	627.71	626.87	627.585	2224108.0
2026-01-12 13:00:00	QQQ	ETF	627.59	628.275	627.51	627.825	2030836.0
2026-01-12 14:00:00	QQQ	ETF	627.82	628.74	627.44	628.7	2615795.0
2026-01-12 15:00:00	QQQ	ETF	628.705	628.845	627.17	627.19	5115395.0
2026-01-12 16:00:00	QQQ	ETF	627.21	627.7017	626.74	626.9	1093153.0
2026-01-12 17:00:00	QQQ	ETF	627.02	627.2094	626.96	627.2094	52819.0
2026-01-12 18:00:00	QQQ	ETF	627.13	627.13	625.83	625.86	101055.0
2026-01-12 19:00:00	QQQ	ETF	625.8	625.9	625.308	625.42	138942.0
2026-01-12 04:00:00	IWM	ETF	258.88	259.08	258.78	258.9	36616.0
2026-01-12 05:00:00	IWM	ETF	258.92	259.25	258.85	259.12	18270.0
2026-01-12 06:00:00	IWM	ETF	259.12	259.62	259.09	259.33	34164.0
2026-01-12 07:00:00	IWM	ETF	259.36	260.03	259.35	259.86	46796.0
2026-01-12 08:00:00	IWM	ETF	259.59	260.0141	258.66	259.5	147803.0
2026-01-12 09:00:00	IWM	ETF	259.5	260.01	258.24	259.9	4305419.0
2026-01-12 10:00:00	IWM	ETF	259.91	260.4479	258.68	260.415	3847111.0
2026-01-12 11:00:00	IWM	ETF	260.41	261.05	260.0	260.73	3280381.0
2026-01-12 12:00:00	IWM	ETF	260.735	260.945	260.435	260.59	1665172.0
2026-01-12 13:00:00	IWM	ETF	260.58	261.41	260.475	261.4	1601854.0
2026-01-12 14:00:00	IWM	ETF	261.39	261.46	261.02	261.44	1508767.0
2026-01-12 15:00:00	IWM	ETF	261.445	261.66	260.975	261.5	3635617.0
2026-01-12 16:00:00	IWM	ETF	261.5	261.5	260.91	261.0	1110613.0
2026-01-12 17:00:00	IWM	ETF	261.0	261.28	261.0	261.15	7953.0
2026-01-12 18:00:00	IWM	ETF	261.14	261.15	260.7	261.0	28291.0
2026-01-12 19:00:00	IWM	ETF	260.88	261.05	260.74	260.8	23815.0
2026-01-12 04:00:00	DIA	ETF	493.78	493.78	491.2	491.51	3586.0
2026-01-12 05:00:00	DIA	ETF	491.52	491.59	491.41	491.41	463.0

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

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