PREVIEW / etf_1hour / 2026-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-14.parquet
  size:    728 KB
  rows:    28,742

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-14 04:00:00	SPY	ETF	692.71	693.18	692.5	692.83	17281.0
2026-01-14 05:00:00	SPY	ETF	692.78	692.79	690.54	690.99	151101.0
2026-01-14 06:00:00	SPY	ETF	690.94	691.51	690.48	691.19	69221.0
2026-01-14 07:00:00	SPY	ETF	691.07	691.92	690.23	691.44	142827.0
2026-01-14 08:00:00	SPY	ETF	691.12	693.65	690.27	690.88	524324.0
2026-01-14 09:00:00	SPY	ETF	690.91	691.72	688.66	688.72	10181966.0
2026-01-14 10:00:00	SPY	ETF	688.72	690.85	686.51	687.16	13866000.0
2026-01-14 11:00:00	SPY	ETF	687.16	689.47	686.13	686.59	9224652.0
2026-01-14 12:00:00	SPY	ETF	686.58	687.45	686.04	686.6377	6230455.0
2026-01-14 13:00:00	SPY	ETF	686.63	688.24	686.26	688.11	5762717.0
2026-01-14 14:00:00	SPY	ETF	688.11	688.59	687.61	688.06	6047348.0
2026-01-14 15:00:00	SPY	ETF	688.05	690.64	687.32	690.44	19602033.0
2026-01-14 16:00:00	SPY	ETF	690.44	693.8932	688.19	689.7	4285840.0
2026-01-14 17:00:00	SPY	ETF	689.68	690.3	689.28	689.52	113985.0
2026-01-14 18:00:00	SPY	ETF	689.51	689.75	688.64	689.62	162410.0
2026-01-14 19:00:00	SPY	ETF	689.55	689.65	689.22	689.52	43956.0
2026-01-14 04:00:00	QQQ	ETF	625.1	625.61	624.6	624.93	62297.0
2026-01-14 05:00:00	QQQ	ETF	624.95	624.96	621.6	622.21	218690.0
2026-01-14 06:00:00	QQQ	ETF	622.3	622.88	621.63	622.35	105129.0
2026-01-14 07:00:00	QQQ	ETF	622.32	623.33	621.36	623.2	163447.0
2026-01-14 08:00:00	QQQ	ETF	622.17	625.771	621.39	622.58	540534.0
2026-01-14 09:00:00	QQQ	ETF	622.59	623.45	618.44	618.52	10141629.0
2026-01-14 10:00:00	QQQ	ETF	618.54	621.08	615.75	616.26	13712556.0
2026-01-14 11:00:00	QQQ	ETF	616.26	618.63	615.03	615.5	8880768.0
2026-01-14 12:00:00	QQQ	ETF	615.49	616.6599	614.86	615.25	5552171.0
2026-01-14 13:00:00	QQQ	ETF	615.24	617.05	614.56	616.8	5328488.0
2026-01-14 14:00:00	QQQ	ETF	616.8	617.24	616.11	616.45	4463586.0
2026-01-14 15:00:00	QQQ	ETF	616.43	619.8	615.52	619.65	9703970.0
2026-01-14 16:00:00	QQQ	ETF	619.6	620.16	617.7	619.0	1745731.0
2026-01-14 17:00:00	QQQ	ETF	619.07	619.14	618.24	618.46	105464.0
2026-01-14 18:00:00	QQQ	ETF	618.54	619.08	617.91	618.87	148839.0
2026-01-14 19:00:00	QQQ	ETF	618.82	618.95	618.43	618.81	74774.0
2026-01-14 04:00:00	IWM	ETF	261.6	261.93	261.6	261.81	10209.0
2026-01-14 05:00:00	IWM	ETF	261.8	261.87	260.76	260.89	18204.0
2026-01-14 06:00:00	IWM	ETF	260.9	260.98	260.63	260.77	76366.0
2026-01-14 07:00:00	IWM	ETF	260.82	261.04	260.48	260.78	32342.0
2026-01-14 08:00:00	IWM	ETF	260.6291	261.76	260.3	260.55	193742.0
2026-01-14 09:00:00	IWM	ETF	260.56	261.63	260.19	260.87	3581552.0
2026-01-14 10:00:00	IWM	ETF	260.87	262.3	260.21	261.11	5585852.0
2026-01-14 11:00:00	IWM	ETF	261.1	262.49	260.755	261.025	3846909.0
2026-01-14 12:00:00	IWM	ETF	261.02	261.81	260.71	261.055	2697157.0
2026-01-14 13:00:00	IWM	ETF	261.055	262.075	260.95	261.83	2726293.0
2026-01-14 14:00:00	IWM	ETF	261.82	262.58	261.71	262.45	2216208.0
2026-01-14 15:00:00	IWM	ETF	262.44	263.46	262.03	263.215	6622548.0
2026-01-14 16:00:00	IWM	ETF	263.21	263.3	262.12	262.7	1287414.0
2026-01-14 17:00:00	IWM	ETF	262.6	262.97	262.35	262.73	43584.0
2026-01-14 18:00:00	IWM	ETF	262.7	262.7	262.12	262.59	38460.0
2026-01-14 19:00:00	IWM	ETF	262.56	262.8	262.45	262.65	21944.0
2026-01-14 04:00:00	DIA	ETF	490.98	491.23	490.98	491.19	1270.0
2026-01-14 05:00:00	DIA	ETF	491.13	491.18	490.26	490.35	6149.0

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

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