PREVIEW / etf_1hour / 2025-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-03.parquet
  size:    700 KB
  rows:    26,840

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
2025-10-03 04:00:00	SPY	ETF	671.08	671.24	670.6	671.15	28366.0
2025-10-03 05:00:00	SPY	ETF	671.24	671.45	671.06	671.45	12533.0
2025-10-03 06:00:00	SPY	ETF	671.48	671.48	670.82	670.85	13234.0
2025-10-03 07:00:00	SPY	ETF	670.73	670.97	669.98	670.13	65229.0
2025-10-03 08:00:00	SPY	ETF	671.14	671.44	669.47	669.86	242509.0
2025-10-03 09:00:00	SPY	ETF	669.7878	671.57	669.61	670.8899	5350426.0
2025-10-03 10:00:00	SPY	ETF	670.81	672.28	669.97	672.11	7048741.0
2025-10-03 11:00:00	SPY	ETF	672.115	672.615	671.35	672.5	5009593.0
2025-10-03 12:00:00	SPY	ETF	672.5	672.675	672.0001	672.24	3082220.0
2025-10-03 13:00:00	SPY	ETF	672.2003	672.2003	668.16	669.19	10383351.0
2025-10-03 14:00:00	SPY	ETF	669.19	670.705	668.27	669.87	7755001.0
2025-10-03 15:00:00	SPY	ETF	669.865	670.26	668.77	669.18	10150861.0
2025-10-03 16:00:00	SPY	ETF	669.2	669.35	668.6	669.02	2127942.0
2025-10-03 17:00:00	SPY	ETF	669.05	669.5	668.97	669.2501	52386.0
2025-10-03 18:00:00	SPY	ETF	669.36	669.95	669.26	669.57	47615.0
2025-10-03 19:00:00	SPY	ETF	669.68	669.73	669.42	669.56	10509.0
2025-10-03 04:00:00	QQQ	ETF	605.86	607.8	605.86	607.7	58950.0
2025-10-03 05:00:00	QQQ	ETF	607.75	607.84	607.47	607.78	31948.0
2025-10-03 06:00:00	QQQ	ETF	607.96	608.04	607.11	607.23	50891.0
2025-10-03 07:00:00	QQQ	ETF	607.22	607.42	606.5	606.55	93301.0
2025-10-03 08:00:00	QQQ	ETF	606.63	607.9896	605.83	606.22	267620.0
2025-10-03 09:00:00	QQQ	ETF	606.19	607.3255	605.71	605.8856	3691945.0
2025-10-03 10:00:00	QQQ	ETF	605.89	606.34	604.52	606.1	4301308.0
2025-10-03 11:00:00	QQQ	ETF	606.11	606.9294	605.68	606.775	3160739.0
2025-10-03 12:00:00	QQQ	ETF	606.76	607.015	605.88	606.1	2250402.0
2025-10-03 13:00:00	QQQ	ETF	606.06	606.06	601.385	602.6195	7181036.0
2025-10-03 14:00:00	QQQ	ETF	602.61	604.3	601.45	603.46	5414822.0
2025-10-03 15:00:00	QQQ	ETF	603.44	603.96	602.77	603.155	5496165.0
2025-10-03 16:00:00	QQQ	ETF	603.17	603.4	602.64	602.87	1285565.0
2025-10-03 17:00:00	QQQ	ETF	602.8	603.14	602.58	603.13	33651.0
2025-10-03 18:00:00	QQQ	ETF	603.13	603.4074	602.96	603.3	7188.0
2025-10-03 19:00:00	QQQ	ETF	603.22	603.33	602.9	602.97	17897.0
2025-10-03 04:00:00	IWM	ETF	245.04	245.24	244.76	245.15	38869.0
2025-10-03 05:00:00	IWM	ETF	245.16	245.25	245.04	245.17	16903.0
2025-10-03 06:00:00	IWM	ETF	245.19	245.19	244.95	244.99	16135.0
2025-10-03 07:00:00	IWM	ETF	244.96	245.13	244.83	245.06	32740.0
2025-10-03 08:00:00	IWM	ETF	245.05	245.23	244.61	244.95	123351.0
2025-10-03 09:00:00	IWM	ETF	244.94	247.29	244.74	246.88	4447416.0
2025-10-03 10:00:00	IWM	ETF	246.86	248.09	246.18	247.965	4475042.0
2025-10-03 11:00:00	IWM	ETF	247.965	247.97	246.73	247.68	2846015.0
2025-10-03 12:00:00	IWM	ETF	247.68	247.83	247.53	247.7	1519956.0
2025-10-03 13:00:00	IWM	ETF	247.7	247.7	245.44	245.85	3481151.0
2025-10-03 14:00:00	IWM	ETF	245.855	246.47	245.22	245.8	3379732.0
2025-10-03 15:00:00	IWM	ETF	245.8	246.18	245.695	245.82	4602392.0
2025-10-03 16:00:00	IWM	ETF	245.83	245.85	245.38	245.52	1734444.0
2025-10-03 17:00:00	IWM	ETF	245.53	246.1899	245.47	245.94	21626.0
2025-10-03 18:00:00	IWM	ETF	246.02	246.23	246.02	246.11	4031.0
2025-10-03 19:00:00	IWM	ETF	246.17	246.19	245.92	246.08	12002.0
2025-10-03 04:00:00	DIA	ETF	466.48	466.48	466.27	466.31	1455.0
2025-10-03 05:00:00	DIA	ETF	466.74	466.74	466.74	466.74	100.0

> showing 50 of 26,840 rows — these rows as CSV

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