PREVIEW / etf_1hour / 2025-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-11-17.parquet
  size:    730 KB
  rows:    27,833

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-17 04:00:00	SPY	ETF	676.14	676.24	674.56	675.01	131554.0
2025-11-17 05:00:00	SPY	ETF	674.89	674.95	672.73	673.01	73977.0
2025-11-17 06:00:00	SPY	ETF	673.13	674.16	672.66	673.44	73828.0
2025-11-17 07:00:00	SPY	ETF	673.38	673.44	671.84	672.14	228823.0
2025-11-17 08:00:00	SPY	ETF	673.4491	676.26	669.71	670.98	586031.0
2025-11-17 09:00:00	SPY	ETF	671.0	673.71	668.92	672.76	7535809.0
2025-11-17 10:00:00	SPY	ETF	672.76	673.15	670.14	670.705	8709774.0
2025-11-17 11:00:00	SPY	ETF	670.71	672.98	667.77	672.95	9322172.0
2025-11-17 12:00:00	SPY	ETF	672.94	673.0	669.15	669.22	5206354.0
2025-11-17 13:00:00	SPY	ETF	669.24	669.91	666.5	666.56	6890580.0
2025-11-17 14:00:00	SPY	ETF	666.57	666.9	662.73	662.79	11520033.0
2025-11-17 15:00:00	SPY	ETF	662.77	665.78	662.17	665.69	20168620.0
2025-11-17 16:00:00	SPY	ETF	665.68	666.38	665.51	666.03	3566021.0
2025-11-17 17:00:00	SPY	ETF	665.98	665.99	665.57	665.89	229947.0
2025-11-17 18:00:00	SPY	ETF	665.8	666.84	665.6	666.42	146746.0
2025-11-17 19:00:00	SPY	ETF	666.36	666.67	664.83	665.3	186203.0
2025-11-17 04:00:00	QQQ	ETF	613.62	615.07	612.78	613.29	161201.0
2025-11-17 05:00:00	QQQ	ETF	613.27	613.44	610.57	611.2	115190.0
2025-11-17 06:00:00	QQQ	ETF	611.16	612.27	610.52	611.28	121628.0
2025-11-17 07:00:00	QQQ	ETF	611.33	611.33	609.07	609.55	362058.0
2025-11-17 08:00:00	QQQ	ETF	610.05	615.07	606.6	608.25	702954.0
2025-11-17 09:00:00	QQQ	ETF	608.2	612.48	605.24	611.17	6849746.0
2025-11-17 10:00:00	QQQ	ETF	611.16	611.58	607.68	608.32	8232421.0
2025-11-17 11:00:00	QQQ	ETF	608.3	611.18	605.04	611.08	6944162.0
2025-11-17 12:00:00	QQQ	ETF	611.07	611.14	606.2899	606.37	4794248.0
2025-11-17 13:00:00	QQQ	ETF	606.37	607.6	603.62	603.81	6132634.0
2025-11-17 14:00:00	QQQ	ETF	603.83	604.23	600.4013	600.4591	6634895.0
2025-11-17 15:00:00	QQQ	ETF	600.44	603.74	599.87	603.65	10649997.0
2025-11-17 16:00:00	QQQ	ETF	603.67	604.55	603.41	604.05	1671746.0
2025-11-17 17:00:00	QQQ	ETF	604.09	604.1	603.57	603.66	57682.0
2025-11-17 18:00:00	QQQ	ETF	603.7	605.2	603.5297	604.36	231529.0
2025-11-17 19:00:00	QQQ	ETF	604.3	604.79	602.24	602.75	164300.0
2025-11-17 04:00:00	IWM	ETF	238.39	238.48	238.0	238.08	49753.0
2025-11-17 05:00:00	IWM	ETF	238.07	238.1	237.34	237.53	20245.0
2025-11-17 06:00:00	IWM	ETF	237.45	237.96	237.37	237.8	12233.0
2025-11-17 07:00:00	IWM	ETF	237.77	237.77	237.26	237.41	90110.0
2025-11-17 08:00:00	IWM	ETF	237.63	238.58	236.46	236.86	213176.0
2025-11-17 09:00:00	IWM	ETF	236.82	237.84	236.0	237.37	4263081.0
2025-11-17 10:00:00	IWM	ETF	237.375	237.65	236.055	236.39	5846098.0
2025-11-17 11:00:00	IWM	ETF	236.39	236.88	235.23	236.88	5889952.0
2025-11-17 12:00:00	IWM	ETF	236.87	236.98	235.62	235.72	4069199.0
2025-11-17 13:00:00	IWM	ETF	235.72	235.82	234.425	234.49	4887388.0
2025-11-17 14:00:00	IWM	ETF	234.505	234.61	232.2	232.25	7935794.0
2025-11-17 15:00:00	IWM	ETF	232.24	233.02	231.755	232.78	10777377.0
2025-11-17 16:00:00	IWM	ETF	232.79	235.2829	232.61	232.77	1580271.0
2025-11-17 17:00:00	IWM	ETF	232.8	232.8	232.48	232.51	14180.0
2025-11-17 18:00:00	IWM	ETF	232.56	233.11	232.56	232.9	36840.0
2025-11-17 19:00:00	IWM	ETF	232.86	233.0591	232.2	232.35	66614.0
2025-11-17 04:00:00	DIA	ETF	472.41	472.47	472.14	472.43	4872.0
2025-11-17 05:00:00	DIA	ETF	472.3	472.3	471.42	471.5	5837.0

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

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