PREVIEW / etf_1hour / 2025-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-16.parquet
  size:    729 KB
  rows:    28,063

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-16 04:00:00	SPY	ETF	666.89	667.35	666.35	666.61	62745.0
2025-10-16 05:00:00	SPY	ETF	666.65	667.36	666.55	667.31	30589.0
2025-10-16 06:00:00	SPY	ETF	667.36	667.99	667.29	667.59	91637.0
2025-10-16 07:00:00	SPY	ETF	667.55	668.17	667.52	667.66	219175.0
2025-10-16 08:00:00	SPY	ETF	667.62	668.32	664.8	667.85	432010.0
2025-10-16 09:00:00	SPY	ETF	667.9	668.08	666.11	666.635	6379190.0
2025-10-16 10:00:00	SPY	ETF	666.635	668.71	665.42	667.09	8889619.0
2025-10-16 11:00:00	SPY	ETF	667.09	668.04	663.93	664.52	8253035.0
2025-10-16 12:00:00	SPY	ETF	664.51	665.15	659.33	663.37	11965464.0
2025-10-16 13:00:00	SPY	ETF	663.37	664.26	661.12	661.81	8535648.0
2025-10-16 14:00:00	SPY	ETF	661.81	661.9495	657.11	660.523	11225588.0
2025-10-16 15:00:00	SPY	ETF	660.51	661.25	657.99	660.65	14939988.0
2025-10-16 16:00:00	SPY	ETF	660.67	661.15	658.92	659.73	3385928.0
2025-10-16 17:00:00	SPY	ETF	659.71	660.15	659.06	659.5	108210.0
2025-10-16 18:00:00	SPY	ETF	659.45	660.6704	658.31	658.3299	122752.0
2025-10-16 19:00:00	SPY	ETF	658.27	658.98	658.07	658.96	69848.0
2025-10-16 04:00:00	QQQ	ETF	605.0	605.42	604.17	604.51	134178.0
2025-10-16 05:00:00	QQQ	ETF	604.62	605.14	604.2	605.05	96716.0
2025-10-16 06:00:00	QQQ	ETF	605.07	605.74	605.0	605.33	182942.0
2025-10-16 07:00:00	QQQ	ETF	605.32	606.05	605.15	605.63	118219.0
2025-10-16 08:00:00	QQQ	ETF	605.57	606.37	601.769	605.93	654376.0
2025-10-16 09:00:00	QQQ	ETF	605.93	607.02	604.66	605.5151	4255030.0
2025-10-16 10:00:00	QQQ	ETF	605.52	608.31	604.36	606.589	5165601.0
2025-10-16 11:00:00	QQQ	ETF	606.64	607.16	602.76	603.375	4583104.0
2025-10-16 12:00:00	QQQ	ETF	603.34	603.96	597.64	602.33	6622299.0
2025-10-16 13:00:00	QQQ	ETF	602.29	603.21	599.89	600.81	4091676.0
2025-10-16 14:00:00	QQQ	ETF	600.78	600.96	595.5	599.2113	5104183.0
2025-10-16 15:00:00	QQQ	ETF	599.22	600.33	596.66	599.97	5746403.0
2025-10-16 16:00:00	QQQ	ETF	599.97	600.55	597.95	599.08	1806951.0
2025-10-16 17:00:00	QQQ	ETF	599.04	599.04	598.62	598.87	76871.0
2025-10-16 18:00:00	QQQ	ETF	599.0	600.61	597.77	597.78	243073.0
2025-10-16 19:00:00	QQQ	ETF	597.85	598.47	597.36	598.23	176781.0
2025-10-16 04:00:00	IWM	ETF	251.05	251.3	250.86	250.91	66379.0
2025-10-16 05:00:00	IWM	ETF	250.93	251.33	250.87	251.26	78132.0
2025-10-16 06:00:00	IWM	ETF	251.29	251.4	251.05	251.23	81581.0
2025-10-16 07:00:00	IWM	ETF	251.22	251.68	251.22	251.33	61888.0
2025-10-16 08:00:00	IWM	ETF	251.34	251.64	250.16	251.38	396484.0
2025-10-16 09:00:00	IWM	ETF	251.41	251.48	249.2	249.58	3292646.0
2025-10-16 10:00:00	IWM	ETF	249.58	249.92	248.59	248.95	4556604.0
2025-10-16 11:00:00	IWM	ETF	248.98	249.61	247.63	247.85	3797367.0
2025-10-16 12:00:00	IWM	ETF	247.85	248.12	245.72	247.3994	5567699.0
2025-10-16 13:00:00	IWM	ETF	247.37	247.9	246.16	246.46	3174892.0
2025-10-16 14:00:00	IWM	ETF	246.46	246.54	244.01	245.3	5268099.0
2025-10-16 15:00:00	IWM	ETF	245.32	245.36	244.0	245.07	6535132.0
2025-10-16 16:00:00	IWM	ETF	245.06	245.22	244.4	244.73	1270380.0
2025-10-16 17:00:00	IWM	ETF	244.79	244.79	244.5	244.58	41311.0
2025-10-16 18:00:00	IWM	ETF	244.61	245.1809	244.16	244.16	49780.0
2025-10-16 19:00:00	IWM	ETF	244.17	244.49	243.93	244.25	125401.0
2025-10-16 04:00:00	DIA	ETF	463.8	464.02	463.49	463.67	3150.0
2025-10-16 05:00:00	DIA	ETF	463.73	464.36	463.71	464.36	1100.0

> showing 50 of 28,063 rows — these rows as CSV

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