PREVIEW / etf_1hour / 2026-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-20.parquet
  size:    795 KB
  rows:    31,236

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-20 04:00:00	SPY	ETF	680.68	685.86	679.05	679.54	288653.0
2026-01-20 05:00:00	SPY	ETF	679.56	681.25	679.15	680.6	122070.0
2026-01-20 06:00:00	SPY	ETF	680.63	681.71	680.54	681.26	380890.0
2026-01-20 07:00:00	SPY	ETF	681.33	683.0	680.98	682.44	408550.0
2026-01-20 08:00:00	SPY	ETF	681.39	685.18	679.0595	680.99	1490407.0
2026-01-20 09:00:00	SPY	ETF	680.98	683.31	680.82	682.18	14644418.0
2026-01-20 10:00:00	SPY	ETF	682.16	684.77	680.91	683.8	14640779.0
2026-01-20 11:00:00	SPY	ETF	683.81	684.56	682.32	683.69	8538127.0
2026-01-20 12:00:00	SPY	ETF	683.67	683.905	680.45	681.08	7896801.0
2026-01-20 13:00:00	SPY	ETF	681.08	681.48	678.025	678.72	7735539.0
2026-01-20 14:00:00	SPY	ETF	678.73	679.27	677.29	677.83	8641162.0
2026-01-20 15:00:00	SPY	ETF	677.85	678.15	676.57	677.61	20401189.0
2026-01-20 16:00:00	SPY	ETF	677.63	678.32	676.87	677.98	3662374.0
2026-01-20 17:00:00	SPY	ETF	678.0	678.3	677.97	678.09	170815.0
2026-01-20 18:00:00	SPY	ETF	678.1	678.67	677.21	677.41	135963.0
2026-01-20 19:00:00	SPY	ETF	677.56	678.7998	677.56	678.6602	146173.0
2026-01-20 04:00:00	QQQ	ETF	614.3	614.3	607.05	608.02	488984.0
2026-01-20 05:00:00	QQQ	ETF	607.95	609.7	607.38	608.96	192991.0
2026-01-20 06:00:00	QQQ	ETF	608.93	610.22	608.9	609.62	199095.0
2026-01-20 07:00:00	QQQ	ETF	609.71	611.58	609.37	610.95	356903.0
2026-01-20 08:00:00	QQQ	ETF	610.98	621.725	607.06	609.78	1531274.0
2026-01-20 09:00:00	QQQ	ETF	609.78	613.595	609.49	612.5	11554406.0
2026-01-20 10:00:00	QQQ	ETF	612.48	614.78	610.88	613.48	12924379.0
2026-01-20 11:00:00	QQQ	ETF	613.48	615.055	612.77	614.3	8175307.0
2026-01-20 12:00:00	QQQ	ETF	614.29	614.5	610.9	611.77	7017714.0
2026-01-20 13:00:00	QQQ	ETF	611.77	612.21	608.8205	609.5255	6180440.0
2026-01-20 14:00:00	QQQ	ETF	609.52	610.13	607.78	608.78	6675319.0
2026-01-20 15:00:00	QQQ	ETF	608.79	608.79	607.05	608.04	11056412.0
2026-01-20 16:00:00	QQQ	ETF	608.08	611.551	607.6	608.12	1817306.0
2026-01-20 17:00:00	QQQ	ETF	608.14	608.2	607.9	608.14	90930.0
2026-01-20 18:00:00	QQQ	ETF	608.16	608.85	607.18	607.3407	157914.0
2026-01-20 19:00:00	QQQ	ETF	607.48	609.11	607.48	608.97	141733.0
2026-01-20 04:00:00	IWM	ETF	260.56	263.41	259.98	260.12	139562.0
2026-01-20 05:00:00	IWM	ETF	260.0	260.92	259.87	260.84	60937.0
2026-01-20 06:00:00	IWM	ETF	260.85	261.5	260.85	261.4	110010.0
2026-01-20 07:00:00	IWM	ETF	261.36	262.15	261.3	261.81	178521.0
2026-01-20 08:00:00	IWM	ETF	261.1086	262.83	259.95	260.69	499302.0
2026-01-20 09:00:00	IWM	ETF	260.66	263.32	260.51	262.75	5653168.0
2026-01-20 10:00:00	IWM	ETF	262.73	264.46	261.82	264.255	4701859.0
2026-01-20 11:00:00	IWM	ETF	264.24	264.88	263.55	264.7	2806623.0
2026-01-20 12:00:00	IWM	ETF	264.7	265.0799	263.485	263.63	3758665.0
2026-01-20 13:00:00	IWM	ETF	263.62	264.3	262.3	262.73	3370193.0
2026-01-20 14:00:00	IWM	ETF	262.73	263.34	261.84	262.505	4102060.0
2026-01-20 15:00:00	IWM	ETF	262.5	262.88	262.15	262.64	6741198.0
2026-01-20 16:00:00	IWM	ETF	262.65	263.17	262.5	263.12	1115241.0
2026-01-20 17:00:00	IWM	ETF	263.19	263.19	262.81	262.98	33866.0
2026-01-20 18:00:00	IWM	ETF	263.0	263.25	262.63	262.63	42608.0
2026-01-20 19:00:00	IWM	ETF	262.75	263.24	262.7	263.1262	23979.0
2026-01-20 04:00:00	DIA	ETF	489.47	489.47	485.24	485.37	3861.0
2026-01-20 05:00:00	DIA	ETF	485.26	486.35	485.0	486.35	11135.0

> showing 50 of 31,236 rows — these rows as CSV

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