PREVIEW / etf_1hour / 2026-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-13.parquet
  size:    738 KB
  rows:    28,920

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-13 04:00:00	SPY	ETF	694.31	694.97	694.31	694.63	32916.0
2026-01-13 05:00:00	SPY	ETF	694.57	694.6	694.01	694.25	17762.0
2026-01-13 06:00:00	SPY	ETF	694.23	694.75	694.15	694.68	53847.0
2026-01-13 07:00:00	SPY	ETF	694.73	694.85	694.31	694.38	85452.0
2026-01-13 08:00:00	SPY	ETF	694.59	697.3	694.0396	695.67	1134978.0
2026-01-13 09:00:00	SPY	ETF	695.67	696.42	694.23	694.245	9535945.0
2026-01-13 10:00:00	SPY	ETF	694.23	694.51	692.09	693.76	10329544.0
2026-01-13 11:00:00	SPY	ETF	693.76	695.2	692.41	694.92	7475501.0
2026-01-13 12:00:00	SPY	ETF	694.92	695.12	692.525	692.94	6530555.0
2026-01-13 13:00:00	SPY	ETF	692.92	693.65	692.42	692.8	5833524.0
2026-01-13 14:00:00	SPY	ETF	692.8	693.205	692.23	692.92	6704553.0
2026-01-13 15:00:00	SPY	ETF	692.92	693.96	691.35	693.75	15789849.0
2026-01-13 16:00:00	SPY	ETF	693.75	694.05	693.44	693.6	4075883.0
2026-01-13 17:00:00	SPY	ETF	693.51	693.78	693.1	693.53	68126.0
2026-01-13 18:00:00	SPY	ETF	693.52	693.76	693.29	693.37	58230.0
2026-01-13 19:00:00	SPY	ETF	693.35	693.86	693.28	693.5987	28292.0
2026-01-13 04:00:00	QQQ	ETF	626.5	626.93	625.94	626.36	68613.0
2026-01-13 05:00:00	QQQ	ETF	626.36	626.42	625.44	625.54	42503.0
2026-01-13 06:00:00	QQQ	ETF	625.64	626.06	625.4	626.03	54632.0
2026-01-13 07:00:00	QQQ	ETF	626.11	626.52	625.83	625.95	151010.0
2026-01-13 08:00:00	QQQ	ETF	626.06	629.51	625.42	627.75	1052681.0
2026-01-13 09:00:00	QQQ	ETF	627.75	629.47	626.79	627.2	5836741.0
2026-01-13 10:00:00	QQQ	ETF	627.18	627.7	623.88	625.95	6642455.0
2026-01-13 11:00:00	QQQ	ETF	625.92	629.04	624.8	628.62	4682268.0
2026-01-13 12:00:00	QQQ	ETF	628.62	628.84	625.01	625.46	4437766.0
2026-01-13 13:00:00	QQQ	ETF	625.44	626.29	624.43	624.5981	3670503.0
2026-01-13 14:00:00	QQQ	ETF	624.61	625.69	624.14	625.24	3178221.0
2026-01-13 15:00:00	QQQ	ETF	625.23	626.29	623.695	626.13	5387371.0
2026-01-13 16:00:00	QQQ	ETF	626.12	626.64	625.9	625.96	1174104.0
2026-01-13 17:00:00	QQQ	ETF	626.01	626.1	625.57	626.07	22730.0
2026-01-13 18:00:00	QQQ	ETF	625.96	626.3062	625.7	625.7845	39185.0
2026-01-13 19:00:00	QQQ	ETF	625.78	626.55	625.68	626.2	36349.0
2026-01-13 04:00:00	IWM	ETF	261.19	261.33	260.95	261.14	21317.0
2026-01-13 05:00:00	IWM	ETF	261.09	261.09	260.67	261.05	10307.0
2026-01-13 06:00:00	IWM	ETF	261.0	261.1	260.91	261.02	15707.0
2026-01-13 07:00:00	IWM	ETF	261.05	261.28	260.98	261.07	50131.0
2026-01-13 08:00:00	IWM	ETF	261.08	264.15	260.81	262.7	846718.0
2026-01-13 09:00:00	IWM	ETF	262.65	262.885	261.07	261.35	4353628.0
2026-01-13 10:00:00	IWM	ETF	261.34	262.15	260.53	261.815	4452920.0
2026-01-13 11:00:00	IWM	ETF	261.81	261.86	260.46	261.42	3825352.0
2026-01-13 12:00:00	IWM	ETF	261.445	262.18	261.402	261.89	2411583.0
2026-01-13 13:00:00	IWM	ETF	261.88	262.425	261.64	262.13	2092638.0
2026-01-13 14:00:00	IWM	ETF	262.15	262.225	261.455	262.125	2379939.0
2026-01-13 15:00:00	IWM	ETF	262.12	262.12	260.7836	261.36	4801664.0
2026-01-13 16:00:00	IWM	ETF	261.36	261.5	261.0	261.31	956162.0
2026-01-13 17:00:00	IWM	ETF	261.32	261.35	261.2	261.35	9740.0
2026-01-13 18:00:00	IWM	ETF	261.35	261.5	261.3	261.36	27371.0
2026-01-13 19:00:00	IWM	ETF	261.38	261.55	261.35	261.48	10927.0
2026-01-13 04:00:00	DIA	ETF	495.36	495.36	495.36	495.36	340.0
2026-01-13 05:00:00	DIA	ETF	495.07	495.23	495.07	495.23	211.0

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

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