PREVIEW / etf_1hour / 2025-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-17.parquet
  size:    686 KB
  rows:    26,865

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-09-17 04:00:00	SPY	ETF	660.22	660.26	658.57	659.59	30773.0
2025-09-17 05:00:00	SPY	ETF	659.72	660.05	659.67	659.81	10981.0
2025-09-17 06:00:00	SPY	ETF	659.8	659.86	659.19	659.19	14144.0
2025-09-17 07:00:00	SPY	ETF	659.37	659.72	659.14	659.45	39261.0
2025-09-17 08:00:00	SPY	ETF	659.57	660.39	659.0	659.87	283171.0
2025-09-17 09:00:00	SPY	ETF	659.86	660.655	659.64	659.88	5682119.0
2025-09-17 10:00:00	SPY	ETF	659.88	659.96	659.04	659.32	6152848.0
2025-09-17 11:00:00	SPY	ETF	659.32	659.67	658.865	659.265	2985004.0
2025-09-17 12:00:00	SPY	ETF	659.26	659.34	658.13	658.32	3033508.0
2025-09-17 13:00:00	SPY	ETF	658.31	659.66	658.295	659.66	3545375.0
2025-09-17 14:00:00	SPY	ETF	659.658	661.72	654.3	657.715	24679475.0
2025-09-17 15:00:00	SPY	ETF	657.69	660.68	657.505	659.18	19345545.0
2025-09-17 16:00:00	SPY	ETF	659.15	660.01	659.13	659.71	3574812.0
2025-09-17 17:00:00	SPY	ETF	659.66	659.7	659.5504	659.65	21982.0
2025-09-17 18:00:00	SPY	ETF	659.7	661.39	659.55	661.18	187943.0
2025-09-17 19:00:00	SPY	ETF	661.21	661.77	661.2	661.49	115896.0
2025-09-17 04:00:00	QQQ	ETF	591.78	591.8	589.64	590.92	63363.0
2025-09-17 05:00:00	QQQ	ETF	591.0	591.29	590.81	590.92	18146.0
2025-09-17 06:00:00	QQQ	ETF	590.84	591.06	590.1	590.59	46281.0
2025-09-17 07:00:00	QQQ	ETF	590.61	590.969	590.3	590.63	57177.0
2025-09-17 08:00:00	QQQ	ETF	590.7	591.82	590.33	591.15	123137.0
2025-09-17 09:00:00	QQQ	ETF	591.14	591.57	589.63	589.99	5001651.0
2025-09-17 10:00:00	QQQ	ETF	590.0	590.07	588.38	588.61	4444049.0
2025-09-17 11:00:00	QQQ	ETF	588.61	589.17	588.15	588.3936	2964372.0
2025-09-17 12:00:00	QQQ	ETF	588.4	588.64	587.525	587.88	2778842.0
2025-09-17 13:00:00	QQQ	ETF	587.86	589.47	587.845	589.34	2420434.0
2025-09-17 14:00:00	QQQ	ETF	589.488	591.1	584.365	587.99	18862672.0
2025-09-17 15:00:00	QQQ	ETF	587.94	591.75	587.76	589.93	14819301.0
2025-09-17 16:00:00	QQQ	ETF	589.92	591.05	589.85	590.57	1165196.0
2025-09-17 17:00:00	QQQ	ETF	590.53	590.59	590.1302	590.42	33779.0
2025-09-17 18:00:00	QQQ	ETF	590.4	592.25	590.38	592.159	147708.0
2025-09-17 19:00:00	QQQ	ETF	592.18	592.6098	592.17	592.59	125205.0
2025-09-17 04:00:00	IWM	ETF	238.72	238.72	238.19	238.43	30843.0
2025-09-17 05:00:00	IWM	ETF	238.43	238.48	238.38	238.45	6311.0
2025-09-17 06:00:00	IWM	ETF	238.44	238.44	238.06	238.07	10957.0
2025-09-17 07:00:00	IWM	ETF	238.14	238.524	238.09	238.41	19769.0
2025-09-17 08:00:00	IWM	ETF	238.44	239.14	238.0559	239.14	156779.0
2025-09-17 09:00:00	IWM	ETF	239.13	240.39	238.69	240.23	3879720.0
2025-09-17 10:00:00	IWM	ETF	240.25	240.73	239.83	240.69	4182336.0
2025-09-17 11:00:00	IWM	ETF	240.7	241.1	240.4	240.93	3061662.0
2025-09-17 12:00:00	IWM	ETF	240.93	241.03	239.67	239.7675	2684954.0
2025-09-17 13:00:00	IWM	ETF	239.76	240.65	239.7	240.45	3005998.0
2025-09-17 14:00:00	IWM	ETF	240.45	244.28	237.02	239.53	26931866.0
2025-09-17 15:00:00	IWM	ETF	239.55	240.61	238.5	238.91	14756670.0
2025-09-17 16:00:00	IWM	ETF	238.89	239.22	238.65	239.06	977067.0
2025-09-17 17:00:00	IWM	ETF	239.06	239.09	238.9363	239.05	9135.0
2025-09-17 18:00:00	IWM	ETF	239.08	239.969	239.02	239.8	29554.0
2025-09-17 19:00:00	IWM	ETF	239.94	239.99	239.77	239.93	53115.0
2025-09-17 04:00:00	DIA	ETF	458.76	458.92	458.45	458.92	2400.0
2025-09-17 05:00:00	DIA	ETF	459.12	459.12	459.04	459.04	325.0

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

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