PREVIEW / etf_1hour / 2026-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-28.parquet
  size:    757 KB
  rows:    29,778

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-28 04:00:00	SPY	ETF	697.5	698.04	697.42	697.95	82578.0
2026-01-28 05:00:00	SPY	ETF	697.85	698.35	697.7	698.26	16049.0
2026-01-28 06:00:00	SPY	ETF	698.23	698.25	697.65	698.0	118232.0
2026-01-28 07:00:00	SPY	ETF	698.04	698.08	697.0	697.07	194569.0
2026-01-28 08:00:00	SPY	ETF	697.07	698.96	696.56	697.02	302557.0
2026-01-28 09:00:00	SPY	ETF	696.97	697.84	696.61	697.12	7374510.0
2026-01-28 10:00:00	SPY	ETF	697.11	697.32	695.54	695.555	7078269.0
2026-01-28 11:00:00	SPY	ETF	695.56	696.33	694.495	694.7218	5468081.0
2026-01-28 12:00:00	SPY	ETF	694.72	695.68	694.52	694.85	4304614.0
2026-01-28 13:00:00	SPY	ETF	694.84	695.43	694.56	695.11	2941091.0
2026-01-28 14:00:00	SPY	ETF	695.09	696.07	693.94	694.91	8768168.0
2026-01-28 15:00:00	SPY	ETF	694.91	696.285	694.75	695.42	11226842.0
2026-01-28 16:00:00	SPY	ETF	695.43	697.05	692.49	696.42	3162833.0
2026-01-28 17:00:00	SPY	ETF	696.41	696.87	696.19	696.6858	198843.0
2026-01-28 18:00:00	SPY	ETF	696.75	696.9	694.22	694.39	221344.0
2026-01-28 19:00:00	SPY	ETF	694.3994	694.6899	693.31	694.6302	192471.0
2026-01-28 04:00:00	QQQ	ETF	636.13	636.38	635.43	636.27	92971.0
2026-01-28 05:00:00	QQQ	ETF	636.24	637.13	636.01	637.11	77399.0
2026-01-28 06:00:00	QQQ	ETF	637.08	637.29	636.35	637.07	99821.0
2026-01-28 07:00:00	QQQ	ETF	637.08	637.11	635.82	636.18	167945.0
2026-01-28 08:00:00	QQQ	ETF	636.99	637.61	630.657	635.99	551350.0
2026-01-28 09:00:00	QQQ	ETF	635.95	636.6	634.52	635.46	6778428.0
2026-01-28 10:00:00	QQQ	ETF	635.45	635.75	633.23	633.3	6726989.0
2026-01-28 11:00:00	QQQ	ETF	633.29	634.18	631.81	632.1901	4180517.0
2026-01-28 12:00:00	QQQ	ETF	632.19	633.35	632.04	632.78	3445949.0
2026-01-28 13:00:00	QQQ	ETF	632.78	633.73	632.33	633.51	2892407.0
2026-01-28 14:00:00	QQQ	ETF	633.46	634.44	632.1	633.252	6551077.0
2026-01-28 15:00:00	QQQ	ETF	633.27	634.49	632.59	632.97	6412709.0
2026-01-28 16:00:00	QQQ	ETF	632.96	636.3	629.0	635.86	2805743.0
2026-01-28 17:00:00	QQQ	ETF	635.7	636.72	635.5	636.27	284527.0
2026-01-28 18:00:00	QQQ	ETF	636.26	636.42	633.22	633.51	373674.0
2026-01-28 19:00:00	QQQ	ETF	633.6	633.62	631.87	633.22	180343.0
2026-01-28 04:00:00	IWM	ETF	265.16	265.94	265.16	265.93	65422.0
2026-01-28 05:00:00	IWM	ETF	265.83	266.31	265.83	266.2	16184.0
2026-01-28 06:00:00	IWM	ETF	266.23	266.28	265.93	266.12	20313.0
2026-01-28 07:00:00	IWM	ETF	266.0	266.23	265.47	265.8	91612.0
2026-01-28 08:00:00	IWM	ETF	266.05	266.28	265.12	265.5407	157977.0
2026-01-28 09:00:00	IWM	ETF	265.55	266.675	264.475	264.53	4077383.0
2026-01-28 10:00:00	IWM	ETF	264.52	264.745	262.935	263.55	4957666.0
2026-01-28 11:00:00	IWM	ETF	263.57	263.91	262.9	263.565	2575220.0
2026-01-28 12:00:00	IWM	ETF	263.57	263.89	263.045	263.38	1941538.0
2026-01-28 13:00:00	IWM	ETF	263.375	264.05	263.35	263.67	1726485.0
2026-01-28 14:00:00	IWM	ETF	263.61	264.94	262.56	263.68	4399430.0
2026-01-28 15:00:00	IWM	ETF	263.68	264.26	262.84	263.31	4557816.0
2026-01-28 16:00:00	IWM	ETF	263.31	264.0787	263.14	263.43	892841.0
2026-01-28 17:00:00	IWM	ETF	263.31	263.5	263.3	263.32	32892.0
2026-01-28 18:00:00	IWM	ETF	263.31	263.5078	262.63	262.77	42770.0
2026-01-28 19:00:00	IWM	ETF	262.74	262.74	262.07	262.3907	62605.0
2026-01-28 04:00:00	DIA	ETF	489.9	490.23	489.9	490.22	3566.0
2026-01-28 05:00:00	DIA	ETF	490.28	490.4	490.21	490.4	2394.0

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

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