PREVIEW / etf_1hour / 2025-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-11-19.parquet
  size:    726 KB
  rows:    27,674

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-11-19 04:00:00	SPY	ETF	660.2	662.36	660.0	662.28	102389.0
2025-11-19 05:00:00	SPY	ETF	662.29	662.9	662.0	662.83	37280.0
2025-11-19 06:00:00	SPY	ETF	662.78	664.0	662.57	662.65	66107.0
2025-11-19 07:00:00	SPY	ETF	662.58	663.18	662.2	662.71	123845.0
2025-11-19 08:00:00	SPY	ETF	662.72	663.23	658.01	661.7925	421978.0
2025-11-19 09:00:00	SPY	ETF	661.77	665.84	660.11	665.67	8958947.0
2025-11-19 10:00:00	SPY	ETF	665.67	667.34	662.6	662.97	12410642.0
2025-11-19 11:00:00	SPY	ETF	662.9604	663.53	660.78	662.515	10052793.0
2025-11-19 12:00:00	SPY	ETF	662.5	662.98	658.745	661.36	9757685.0
2025-11-19 13:00:00	SPY	ETF	661.34	663.33	660.76	662.5292	8492515.0
2025-11-19 14:00:00	SPY	ETF	662.55	662.79	659.33	661.25	8147027.0
2025-11-19 15:00:00	SPY	ETF	661.25	664.76	661.0	662.65	13386795.0
2025-11-19 16:00:00	SPY	ETF	662.65	666.8	661.54	666.07	4883637.0
2025-11-19 17:00:00	SPY	ETF	666.0	666.75	665.27	665.9	360276.0
2025-11-19 18:00:00	SPY	ETF	665.89	669.52	662.62	669.52	507158.0
2025-11-19 19:00:00	SPY	ETF	669.53	670.67	669.05	670.0475	285581.0
2025-11-19 04:00:00	QQQ	ETF	595.72	598.77	595.72	598.61	134605.0
2025-11-19 05:00:00	QQQ	ETF	598.67	599.43	598.36	599.25	137383.0
2025-11-19 06:00:00	QQQ	ETF	599.21	600.0	598.96	599.07	119775.0
2025-11-19 07:00:00	QQQ	ETF	599.03	599.74	598.58	599.14	265518.0
2025-11-19 08:00:00	QQQ	ETF	599.12	599.86	593.05	598.36	741851.0
2025-11-19 09:00:00	QQQ	ETF	598.29	604.08	596.14	603.9	7038245.0
2025-11-19 10:00:00	QQQ	ETF	603.89	606.16	600.38	600.915	12260135.0
2025-11-19 11:00:00	QQQ	ETF	600.905	601.31	597.99	599.6	8243152.0
2025-11-19 12:00:00	QQQ	ETF	599.6	599.74	594.59	597.64	6792613.0
2025-11-19 13:00:00	QQQ	ETF	597.62	599.63	596.4909	598.93	5201397.0
2025-11-19 14:00:00	QQQ	ETF	598.87	599.22	596.1	598.21	4870750.0
2025-11-19 15:00:00	QQQ	ETF	598.2	602.3399	597.88	599.76	8207960.0
2025-11-19 16:00:00	QQQ	ETF	599.77	605.87	598.2982	605.35	3478360.0
2025-11-19 17:00:00	QQQ	ETF	605.52	606.9	604.26	605.4	690102.0
2025-11-19 18:00:00	QQQ	ETF	605.47	609.0698	605.41	609.02	482969.0
2025-11-19 19:00:00	QQQ	ETF	609.02	610.31	608.642	609.54	280769.0
2025-11-19 04:00:00	IWM	ETF	233.01	234.44	233.01	234.41	95343.0
2025-11-19 05:00:00	IWM	ETF	234.46	234.79	234.33	234.68	24409.0
2025-11-19 06:00:00	IWM	ETF	234.67	234.88	234.55	234.62	41596.0
2025-11-19 07:00:00	IWM	ETF	234.6	234.76	234.41	234.53	51939.0
2025-11-19 08:00:00	IWM	ETF	233.73	234.65	232.57	234.19	94640.0
2025-11-19 09:00:00	IWM	ETF	234.2	235.04	233.44	234.98	5257187.0
2025-11-19 10:00:00	IWM	ETF	234.99	236.37	233.955	234.16	6998137.0
2025-11-19 11:00:00	IWM	ETF	234.16	234.38	233.1	233.84	6719225.0
2025-11-19 12:00:00	IWM	ETF	233.84	234.09	232.43	233.37	6430055.0
2025-11-19 13:00:00	IWM	ETF	233.38	234.22	233.08	233.865	5277665.0
2025-11-19 14:00:00	IWM	ETF	233.86	233.9899	232.47	233.18	6047724.0
2025-11-19 15:00:00	IWM	ETF	233.17	234.475	232.98	233.46	9428413.0
2025-11-19 16:00:00	IWM	ETF	233.46	234.66	233.09	234.63	1263204.0
2025-11-19 17:00:00	IWM	ETF	234.69	234.74	234.03	234.29	29319.0
2025-11-19 18:00:00	IWM	ETF	234.34	235.15	234.34	235.11	51109.0
2025-11-19 19:00:00	IWM	ETF	235.13	235.68	234.97	235.4412	20225.0
2025-11-19 04:00:00	DIA	ETF	461.09	462.01	461.09	462.01	1060.0
2025-11-19 05:00:00	DIA	ETF	462.03	462.21	461.98	462.03	918.0

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

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