PREVIEW / etf_1hour / 2025-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-11-14.parquet
  size:    727 KB
  rows:    27,863

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-14 04:00:00	SPY	ETF	670.67	671.56	669.68	669.99	120834.0
2025-11-14 05:00:00	SPY	ETF	669.93	670.97	669.74	670.1	72272.0
2025-11-14 06:00:00	SPY	ETF	670.02	670.02	666.0	667.67	284001.0
2025-11-14 07:00:00	SPY	ETF	667.68	667.7	664.72	665.79	637057.0
2025-11-14 08:00:00	SPY	ETF	667.56	672.61	663.97	665.42	1036706.0
2025-11-14 09:00:00	SPY	ETF	665.5	668.845	663.265	668.69	13492076.0
2025-11-14 10:00:00	SPY	ETF	668.68	672.82	666.92	672.24	13765393.0
2025-11-14 11:00:00	SPY	ETF	672.25	675.02	670.89	674.74	8659567.0
2025-11-14 12:00:00	SPY	ETF	674.715	675.66	673.13	674.045	7291972.0
2025-11-14 13:00:00	SPY	ETF	674.05	674.36	671.49	673.25	9065612.0
2025-11-14 14:00:00	SPY	ETF	673.25	674.9	672.27	674.65	7128784.0
2025-11-14 15:00:00	SPY	ETF	674.64	675.12	671.17	671.95	13090125.0
2025-11-14 16:00:00	SPY	ETF	671.95	673.05	671.24	672.68	2652587.0
2025-11-14 17:00:00	SPY	ETF	672.64	672.98	672.6	672.78	75661.0
2025-11-14 18:00:00	SPY	ETF	672.7807	672.99	672.74	672.85	82274.0
2025-11-14 19:00:00	SPY	ETF	672.92	673.34	672.88	673.34	50532.0
2025-11-14 04:00:00	QQQ	ETF	606.0	607.13	604.54	604.83	275525.0
2025-11-14 05:00:00	QQQ	ETF	604.71	606.04	604.51	604.9	145848.0
2025-11-14 06:00:00	QQQ	ETF	604.8	604.8	600.85	602.24	605146.0
2025-11-14 07:00:00	QQQ	ETF	602.14	602.2	598.21	599.61	1153109.0
2025-11-14 08:00:00	QQQ	ETF	601.83	608.93	597.96	599.39	1431337.0
2025-11-14 09:00:00	QQQ	ETF	599.45	605.55	597.17	605.16	12521628.0
2025-11-14 10:00:00	QQQ	ETF	605.14	610.57	602.93	609.73	12397453.0
2025-11-14 11:00:00	QQQ	ETF	609.73	612.74	607.43	612.27	7073534.0
2025-11-14 12:00:00	QQQ	ETF	612.23	613.35	610.14	611.175	5783293.0
2025-11-14 13:00:00	QQQ	ETF	611.15	611.68	608.38	610.41	6703476.0
2025-11-14 14:00:00	QQQ	ETF	610.42	612.11	609.26	611.782	4416142.0
2025-11-14 15:00:00	QQQ	ETF	611.8	612.34	607.98	608.82	8685622.0
2025-11-14 16:00:00	QQQ	ETF	608.83	610.18	608.14	609.8	2092127.0
2025-11-14 17:00:00	QQQ	ETF	609.82	611.48	609.66	610.33	69613.0
2025-11-14 18:00:00	QQQ	ETF	610.38	610.79	610.14	610.76	44678.0
2025-11-14 19:00:00	QQQ	ETF	610.78	611.47	610.78	611.36	35673.0
2025-11-14 04:00:00	IWM	ETF	236.47	236.77	235.75	235.88	44205.0
2025-11-14 05:00:00	IWM	ETF	235.86	236.45	235.83	235.89	45131.0
2025-11-14 06:00:00	IWM	ETF	235.83	235.87	234.57	234.9	65326.0
2025-11-14 07:00:00	IWM	ETF	235.02	235.02	233.81	234.16	322941.0
2025-11-14 08:00:00	IWM	ETF	234.13	237.26	233.25	233.9	496083.0
2025-11-14 09:00:00	IWM	ETF	233.85	236.79	233.27	236.37	8186219.0
2025-11-14 10:00:00	IWM	ETF	236.37	237.565	235.15	237.0	8069202.0
2025-11-14 11:00:00	IWM	ETF	237.01	238.33	236.315	238.265	5535769.0
2025-11-14 12:00:00	IWM	ETF	238.26	238.725	237.545	238.0	5028523.0
2025-11-14 13:00:00	IWM	ETF	238.0	238.22	237.07	237.755	4865021.0
2025-11-14 14:00:00	IWM	ETF	237.75	238.23	237.33	238.17	4223906.0
2025-11-14 15:00:00	IWM	ETF	238.16	238.38	237.21	237.5	7386920.0
2025-11-14 16:00:00	IWM	ETF	237.51	237.7	237.18	237.7	1357429.0
2025-11-14 17:00:00	IWM	ETF	237.69	237.95	237.44	237.7797	33656.0
2025-11-14 18:00:00	IWM	ETF	237.83	238.0988	237.71	238.08	30345.0
2025-11-14 19:00:00	IWM	ETF	237.88	238.19	237.8425	238.0	8448.0
2025-11-14 04:00:00	DIA	ETF	474.56	474.81	473.8	473.95	5859.0
2025-11-14 05:00:00	DIA	ETF	474.08	474.12	473.64	473.64	668.0

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

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