PREVIEW / etf_1hour / 2025-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-17.parquet
  size:    704 KB
  rows:    27,729

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-17 04:00:00	SPY	ETF	656.83	656.83	651.41	653.41	174520.0
2025-10-17 05:00:00	SPY	ETF	653.21	654.96	653.17	653.36	88599.0
2025-10-17 06:00:00	SPY	ETF	653.5	655.71	653.32	655.71	214597.0
2025-10-17 07:00:00	SPY	ETF	655.74	659.67	655.42	659.33	838031.0
2025-10-17 08:00:00	SPY	ETF	654.37	661.25	651.56	659.91	1104498.0
2025-10-17 09:00:00	SPY	ETF	659.86	662.48	658.23	660.68	10765965.0
2025-10-17 10:00:00	SPY	ETF	660.67	663.715	659.33	659.58	8832901.0
2025-10-17 11:00:00	SPY	ETF	659.56	662.24	658.14	661.71	7423561.0
2025-10-17 12:00:00	SPY	ETF	661.7	663.635	661.25	662.0	5269256.0
2025-10-17 13:00:00	SPY	ETF	662.02	663.06	660.55	662.885	4662521.0
2025-10-17 14:00:00	SPY	ETF	662.87	665.1	662.87	664.38	5716594.0
2025-10-17 15:00:00	SPY	ETF	664.39	665.755	664.03	664.32	10345997.0
2025-10-17 16:00:00	SPY	ETF	664.32	665.24	664.13	665.07	3154277.0
2025-10-17 17:00:00	SPY	ETF	665.09	665.3499	664.93	665.17	155993.0
2025-10-17 18:00:00	SPY	ETF	665.17	665.3	664.72	664.77	64625.0
2025-10-17 19:00:00	SPY	ETF	664.81	665.35	664.5	665.28	42079.0
2025-10-17 04:00:00	QQQ	ETF	591.56	592.92	590.11	592.06	330299.0
2025-10-17 05:00:00	QQQ	ETF	591.98	593.72	591.9	592.18	255021.0
2025-10-17 06:00:00	QQQ	ETF	592.2	594.08	591.86	594.05	269822.0
2025-10-17 07:00:00	QQQ	ETF	594.06	598.07	593.9	597.75	624700.0
2025-10-17 08:00:00	QQQ	ETF	597.71	599.541	590.41	597.99	858228.0
2025-10-17 09:00:00	QQQ	ETF	597.93	601.61	596.37	600.0	5660765.0
2025-10-17 10:00:00	QQQ	ETF	599.97	603.32	598.2	598.57	6211512.0
2025-10-17 11:00:00	QQQ	ETF	598.55	601.19	596.424	600.6007	4962370.0
2025-10-17 12:00:00	QQQ	ETF	600.62	603.58	600.6	601.87	4818824.0
2025-10-17 13:00:00	QQQ	ETF	601.89	602.93	600.12	602.7063	3164720.0
2025-10-17 14:00:00	QQQ	ETF	602.68	604.94	602.68	604.145	3510939.0
2025-10-17 15:00:00	QQQ	ETF	604.12	605.51	603.72	603.88	4729890.0
2025-10-17 16:00:00	QQQ	ETF	603.93	605.23	603.6	604.97	1811163.0
2025-10-17 17:00:00	QQQ	ETF	604.9207	604.96	604.5	604.7	54476.0
2025-10-17 18:00:00	QQQ	ETF	604.84	604.84	604.01	604.25	33979.0
2025-10-17 19:00:00	QQQ	ETF	604.25	605.35	603.93	604.99	59994.0
2025-10-17 04:00:00	IWM	ETF	241.93	241.93	240.19	241.03	388494.0
2025-10-17 05:00:00	IWM	ETF	240.99	241.88	240.93	241.15	320347.0
2025-10-17 06:00:00	IWM	ETF	241.15	242.31	240.88	242.21	388901.0
2025-10-17 07:00:00	IWM	ETF	242.25	244.01	242.02	243.74	722714.0
2025-10-17 08:00:00	IWM	ETF	243.71	245.32	240.26	244.46	1302357.0
2025-10-17 09:00:00	IWM	ETF	244.49	245.025	242.7	244.21	4579832.0
2025-10-17 10:00:00	IWM	ETF	244.19	245.16	242.53	242.68	5279099.0
2025-10-17 11:00:00	IWM	ETF	242.68	243.42	241.47	243.1	4574084.0
2025-10-17 12:00:00	IWM	ETF	243.12	243.71	241.97	242.35	2658159.0
2025-10-17 13:00:00	IWM	ETF	242.355	243.09	241.84	242.86	3018686.0
2025-10-17 14:00:00	IWM	ETF	242.85	243.715	242.78	243.195	3330099.0
2025-10-17 15:00:00	IWM	ETF	243.2	243.83	243.19	243.4	6991835.0
2025-10-17 16:00:00	IWM	ETF	243.41	243.99	243.41	243.9	1412738.0
2025-10-17 17:00:00	IWM	ETF	243.73	243.98	243.73	243.85	11687.0
2025-10-17 18:00:00	IWM	ETF	243.91	243.94	243.74	243.89	15977.0
2025-10-17 19:00:00	IWM	ETF	243.88	243.9	243.76	243.7601	7593.0
2025-10-17 04:00:00	DIA	ETF	455.19	455.71	454.48	455.56	2562.0
2025-10-17 05:00:00	DIA	ETF	455.82	456.61	455.77	456.01	2451.0

> showing 50 of 27,729 rows — these rows as CSV

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