PREVIEW / etf_1hour / 2025-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-23.parquet
  size:    691 KB
  rows:    26,931

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-23 04:00:00	SPY	ETF	668.88	669.14	668.46	668.73	64903.0
2025-10-23 05:00:00	SPY	ETF	668.66	668.85	667.61	668.1	20936.0
2025-10-23 06:00:00	SPY	ETF	668.19	668.41	668.05	668.3	10852.0
2025-10-23 07:00:00	SPY	ETF	668.18	668.2	666.58	666.74	122115.0
2025-10-23 08:00:00	SPY	ETF	667.97	669.34	666.02	667.81	321791.0
2025-10-23 09:00:00	SPY	ETF	667.77	670.74	666.6	669.96	5762844.0
2025-10-23 10:00:00	SPY	ETF	670.0	670.39	668.12	670.205	6461565.0
2025-10-23 11:00:00	SPY	ETF	670.21	670.72	668.73	670.25	3980660.0
2025-10-23 12:00:00	SPY	ETF	670.26	671.53	670.14	671.435	3830518.0
2025-10-23 13:00:00	SPY	ETF	671.43	672.4601	670.4	672.355	5256551.0
2025-10-23 14:00:00	SPY	ETF	672.37	672.7101	671.72	672.5401	3476324.0
2025-10-23 15:00:00	SPY	ETF	672.55	672.7	671.3	671.63	10940278.0
2025-10-23 16:00:00	SPY	ETF	671.6	672.0	670.8	671.94	3293983.0
2025-10-23 17:00:00	SPY	ETF	672.04	672.16	671.89	672.0001	52658.0
2025-10-23 18:00:00	SPY	ETF	672.02	672.37	671.92	672.1188	37854.0
2025-10-23 19:00:00	SPY	ETF	672.26	672.36	672.2	672.3	13555.0
2025-10-23 04:00:00	QQQ	ETF	607.33	607.33	606.26	606.56	77519.0
2025-10-23 05:00:00	QQQ	ETF	606.54	606.72	605.16	605.95	121108.0
2025-10-23 06:00:00	QQQ	ETF	605.96	606.14	605.38	605.7	83222.0
2025-10-23 07:00:00	QQQ	ETF	605.71	605.76	603.64	603.91	254282.0
2025-10-23 08:00:00	QQQ	ETF	603.87	607.55	603.0	604.72	558987.0
2025-10-23 09:00:00	QQQ	ETF	604.7	608.83	603.1001	608.34	4432792.0
2025-10-23 10:00:00	QQQ	ETF	608.38	609.27	606.51	609.06	4825604.0
2025-10-23 11:00:00	QQQ	ETF	609.06	609.69	607.4	609.1707	2857980.0
2025-10-23 12:00:00	QQQ	ETF	609.17	610.28	608.94	610.26	2510482.0
2025-10-23 13:00:00	QQQ	ETF	610.2801	611.3	609.06	611.1899	3248281.0
2025-10-23 14:00:00	QQQ	ETF	611.21	611.37	610.36	611.0999	1715827.0
2025-10-23 15:00:00	QQQ	ETF	611.1	611.32	610.08	610.6	3673071.0
2025-10-23 16:00:00	QQQ	ETF	610.6	611.61	610.5	611.18	3312149.0
2025-10-23 17:00:00	QQQ	ETF	611.17	611.64	611.0	611.45	131525.0
2025-10-23 18:00:00	QQQ	ETF	611.45	611.8	611.21	611.56	93202.0
2025-10-23 19:00:00	QQQ	ETF	611.7	611.81	611.59	611.75	48229.0
2025-10-23 04:00:00	IWM	ETF	244.85	245.1	244.61	244.79	78646.0
2025-10-23 05:00:00	IWM	ETF	244.78	244.87	244.14	244.73	44027.0
2025-10-23 06:00:00	IWM	ETF	244.74	244.82	244.4	244.54	28195.0
2025-10-23 07:00:00	IWM	ETF	244.54	244.54	243.74	243.8	76120.0
2025-10-23 08:00:00	IWM	ETF	243.8	244.85	243.47	244.2	276198.0
2025-10-23 09:00:00	IWM	ETF	244.19	245.62	243.85	245.62	2775108.0
2025-10-23 10:00:00	IWM	ETF	245.64	245.77	243.68	245.56	3518649.0
2025-10-23 11:00:00	IWM	ETF	245.56	245.69	244.585	245.41	2301286.0
2025-10-23 12:00:00	IWM	ETF	245.41	246.02	245.25	245.84	1581230.0
2025-10-23 13:00:00	IWM	ETF	245.83	247.02	245.09	246.995	2969419.0
2025-10-23 14:00:00	IWM	ETF	247.02	247.12	246.68	246.92	1857865.0
2025-10-23 15:00:00	IWM	ETF	246.93	247.05	246.17	246.39	3741609.0
2025-10-23 16:00:00	IWM	ETF	246.39	246.48	246.16	246.42	1552173.0
2025-10-23 17:00:00	IWM	ETF	246.48	246.6	246.34	246.5	20946.0
2025-10-23 18:00:00	IWM	ETF	246.57	246.79	246.54	246.7	21348.0
2025-10-23 19:00:00	IWM	ETF	246.81	246.919	246.78	246.9	38275.0
2025-10-23 04:00:00	DIA	ETF	465.55	465.55	465.29	465.54	800.0
2025-10-23 05:00:00	DIA	ETF	465.03	465.03	464.61	464.91	4650.0

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

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