PREVIEW / etf_1hour / 2026-01-21

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-21.parquet
  size:    766 KB
  rows:    29,738

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-21 04:00:00	SPY	ETF	679.73	679.89	678.07	678.07	90236.0
2026-01-21 05:00:00	SPY	ETF	678.06	679.26	677.94	678.57	52462.0
2026-01-21 06:00:00	SPY	ETF	678.5	678.61	676.29	676.39	124904.0
2026-01-21 07:00:00	SPY	ETF	676.38	677.25	675.88	676.96	332090.0
2026-01-21 08:00:00	SPY	ETF	676.51	680.04	675.8877	676.86	765399.0
2026-01-21 09:00:00	SPY	ETF	676.84	682.675	676.58	682.49	14665560.0
2026-01-21 10:00:00	SPY	ETF	682.48	685.13	681.65	684.7321	11136137.0
2026-01-21 11:00:00	SPY	ETF	684.73	684.84	679.91	680.045	12693208.0
2026-01-21 12:00:00	SPY	ETF	680.05	680.97	678.13	680.63	11028366.0
2026-01-21 13:00:00	SPY	ETF	680.62	681.5	678.63	680.99	7484507.0
2026-01-21 14:00:00	SPY	ETF	680.99	688.71	679.87	688.475	20848628.0
2026-01-21 15:00:00	SPY	ETF	688.475	688.735	684.63	685.33	21236032.0
2026-01-21 16:00:00	SPY	ETF	685.32	686.18	685.2116	685.79	3375701.0
2026-01-21 17:00:00	SPY	ETF	685.76	686.22	685.62	686.09	58167.0
2026-01-21 18:00:00	SPY	ETF	686.16	687.0102	686.16	686.74	82751.0
2026-01-21 19:00:00	SPY	ETF	686.7	687.19	686.49	686.9	40506.0
2026-01-21 04:00:00	QQQ	ETF	610.5	610.5	607.9	607.91	159512.0
2026-01-21 05:00:00	QQQ	ETF	607.91	609.3	607.75	608.48	72312.0
2026-01-21 06:00:00	QQQ	ETF	608.43	608.62	605.76	605.91	194775.0
2026-01-21 07:00:00	QQQ	ETF	605.9	606.97	605.5	606.88	254265.0
2026-01-21 08:00:00	QQQ	ETF	606.06	610.6	605.46	606.85	890750.0
2026-01-21 09:00:00	QQQ	ETF	606.79	612.93	606.51	612.6	9739699.0
2026-01-21 10:00:00	QQQ	ETF	612.6	616.49	611.89	616.055	8521887.0
2026-01-21 11:00:00	QQQ	ETF	616.05	616.6198	610.09	610.302	9207444.0
2026-01-21 12:00:00	QQQ	ETF	610.31	611.09	608.22	610.67	7803590.0
2026-01-21 13:00:00	QQQ	ETF	610.69	611.86	608.41	611.57	5378663.0
2026-01-21 14:00:00	QQQ	ETF	611.55	620.3	610.36	620.09	13613857.0
2026-01-21 15:00:00	QQQ	ETF	620.09	620.42	615.51	616.12	10775956.0
2026-01-21 16:00:00	QQQ	ETF	616.09	617.54	616.09	617.0	1199876.0
2026-01-21 17:00:00	QQQ	ETF	617.02	617.38	616.7	617.33	110372.0
2026-01-21 18:00:00	QQQ	ETF	617.46	618.48	617.3799	618.05	120892.0
2026-01-21 19:00:00	QQQ	ETF	618.14	618.7351	617.9	618.1975	58018.0
2026-01-21 04:00:00	IWM	ETF	263.57	263.77	262.96	262.96	29641.0
2026-01-21 05:00:00	IWM	ETF	262.91	263.47	262.88	263.2	10550.0
2026-01-21 06:00:00	IWM	ETF	263.15	263.27	262.03	262.03	18562.0
2026-01-21 07:00:00	IWM	ETF	262.05	262.86	261.96	262.84	44307.0
2026-01-21 08:00:00	IWM	ETF	261.98	264.25	261.93	263.74	237963.0
2026-01-21 09:00:00	IWM	ETF	262.82	266.13	262.6	265.93	4512186.0
2026-01-21 10:00:00	IWM	ETF	265.92	266.895	265.495	266.635	3935121.0
2026-01-21 11:00:00	IWM	ETF	266.63	266.74	264.1	264.24	3937220.0
2026-01-21 12:00:00	IWM	ETF	264.22	264.46	262.92	264.25	4855052.0
2026-01-21 13:00:00	IWM	ETF	264.24	264.78	263.3	264.5899	2733937.0
2026-01-21 14:00:00	IWM	ETF	264.59	268.59	263.98	268.035	7725134.0
2026-01-21 15:00:00	IWM	ETF	268.03	268.12	266.795	267.76	8952155.0
2026-01-21 16:00:00	IWM	ETF	267.77	268.06	265.9902	267.89	1400611.0
2026-01-21 17:00:00	IWM	ETF	267.98	268.04	267.83	268.0	12397.0
2026-01-21 18:00:00	IWM	ETF	268.07	268.264	267.94	268.1	32828.0
2026-01-21 19:00:00	IWM	ETF	268.07	268.3	267.94	268.1692	24729.0
2026-01-21 04:00:00	DIA	ETF	485.96	485.96	485.01	485.02	2387.0
2026-01-21 05:00:00	DIA	ETF	484.88	485.62	484.88	485.5	1940.0

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

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