PREVIEW / etf_1hour / 2026-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-26.parquet
  size:    754 KB
  rows:    29,516

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-26 04:00:00	SPY	ETF	688.62	689.74	686.97	687.61	101092.0
2026-01-26 05:00:00	SPY	ETF	687.57	688.58	687.55	688.21	24546.0
2026-01-26 06:00:00	SPY	ETF	688.2	688.47	687.98	688.47	20030.0
2026-01-26 07:00:00	SPY	ETF	688.38	689.16	688.38	688.75	198722.0
2026-01-26 08:00:00	SPY	ETF	689.65	689.96	686.9989	689.88	428387.0
2026-01-26 09:00:00	SPY	ETF	689.88	692.63	689.82	692.265	7757163.0
2026-01-26 10:00:00	SPY	ETF	692.26	693.4	691.75	692.975	7754477.0
2026-01-26 11:00:00	SPY	ETF	692.98	693.36	692.23	693.12	4498201.0
2026-01-26 12:00:00	SPY	ETF	693.1	693.7099	693.03	693.24	3742898.0
2026-01-26 13:00:00	SPY	ETF	693.24	694.13	692.9	693.59	3834756.0
2026-01-26 14:00:00	SPY	ETF	693.58	694.0	693.46	693.59	4627239.0
2026-01-26 15:00:00	SPY	ETF	693.6	693.87	692.62	692.71	12731193.0
2026-01-26 16:00:00	SPY	ETF	692.71	692.9485	692.32	692.4	3513348.0
2026-01-26 17:00:00	SPY	ETF	692.56	692.6093	692.21	692.31	153171.0
2026-01-26 18:00:00	SPY	ETF	692.31	692.99	691.88	692.73	147011.0
2026-01-26 19:00:00	SPY	ETF	692.73	693.04	692.3908	692.97	32458.0
2026-01-26 04:00:00	QQQ	ETF	621.67	622.84	619.32	620.06	180024.0
2026-01-26 05:00:00	QQQ	ETF	620.03	621.4	619.96	620.85	68811.0
2026-01-26 06:00:00	QQQ	ETF	620.89	621.34	620.62	621.32	38277.0
2026-01-26 07:00:00	QQQ	ETF	621.31	622.32	621.25	621.78	68097.0
2026-01-26 08:00:00	QQQ	ETF	622.59	622.95	619.4	622.44	543757.0
2026-01-26 09:00:00	QQQ	ETF	622.44	625.69	622.12	625.2949	4855523.0
2026-01-26 10:00:00	QQQ	ETF	625.28	626.75	624.455	626.335	4984630.0
2026-01-26 11:00:00	QQQ	ETF	626.33	627.44	625.62	626.935	3921652.0
2026-01-26 12:00:00	QQQ	ETF	626.94	627.61	626.36	626.5699	2676200.0
2026-01-26 13:00:00	QQQ	ETF	626.575	627.55	626.17	626.8	2668635.0
2026-01-26 14:00:00	QQQ	ETF	626.79	627.13	626.31	626.32	2282656.0
2026-01-26 15:00:00	QQQ	ETF	626.33	626.72	625.4001	625.48	5607675.0
2026-01-26 16:00:00	QQQ	ETF	625.48	626.12	625.25	625.83	881555.0
2026-01-26 17:00:00	QQQ	ETF	625.91	625.96	625.5	625.6005	46079.0
2026-01-26 18:00:00	QQQ	ETF	625.65	626.71	625.42	626.5401	73546.0
2026-01-26 19:00:00	QQQ	ETF	626.57	626.87	626.25	626.82	72700.0
2026-01-26 04:00:00	IWM	ETF	264.49	264.72	263.74	264.04	56970.0
2026-01-26 05:00:00	IWM	ETF	263.95	264.24	263.77	264.06	56902.0
2026-01-26 06:00:00	IWM	ETF	264.18	264.18	264.0	264.1	19511.0
2026-01-26 07:00:00	IWM	ETF	264.09	264.52	264.09	264.45	51205.0
2026-01-26 08:00:00	IWM	ETF	264.52	265.15	263.47	265.07	307614.0
2026-01-26 09:00:00	IWM	ETF	265.13	266.69	264.37	265.83	5861821.0
2026-01-26 10:00:00	IWM	ETF	265.815	265.85	263.72	264.165	4400346.0
2026-01-26 11:00:00	IWM	ETF	264.15	264.26	263.49	263.755	2587506.0
2026-01-26 12:00:00	IWM	ETF	263.76	264.685	263.66	264.185	1719872.0
2026-01-26 13:00:00	IWM	ETF	264.18	264.49	263.915	264.225	1192817.0
2026-01-26 14:00:00	IWM	ETF	264.23	264.445	263.79	263.905	1487295.0
2026-01-26 15:00:00	IWM	ETF	263.91	264.35	263.72	263.97	3461903.0
2026-01-26 16:00:00	IWM	ETF	263.98	264.13	263.84	263.96	843434.0
2026-01-26 17:00:00	IWM	ETF	263.98	263.98	263.58	263.78	24600.0
2026-01-26 18:00:00	IWM	ETF	263.73	263.9407	263.6	263.94	19760.0
2026-01-26 19:00:00	IWM	ETF	263.81	263.96	263.75	263.85	9267.0
2026-01-26 04:00:00	DIA	ETF	491.25	491.6	490.3	490.59	40772.0
2026-01-26 05:00:00	DIA	ETF	490.6	491.08	490.6	491.03	2477.0

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

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