PREVIEW / etf_1hour / 2025-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-17.parquet
  size:    718 KB
  rows:    27,851

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-12-17 04:00:00	SPY	ETF	679.5	681.08	679.5	680.9	106198.0
2025-12-17 05:00:00	SPY	ETF	680.85	681.5	680.78	681.34	36926.0
2025-12-17 06:00:00	SPY	ETF	681.32	681.5	680.94	681.36	69884.0
2025-12-17 07:00:00	SPY	ETF	681.38	681.5	681.0	681.14	219821.0
2025-12-17 08:00:00	SPY	ETF	681.37	681.5	677.71	680.72	621750.0
2025-12-17 09:00:00	SPY	ETF	680.68	681.09	677.6	679.26	9324670.0
2025-12-17 10:00:00	SPY	ETF	679.265	679.68	674.02	674.56	13351952.0
2025-12-17 11:00:00	SPY	ETF	674.55	675.7	673.07	674.23	10693594.0
2025-12-17 12:00:00	SPY	ETF	674.22	675.07	673.0	673.8	6890815.0
2025-12-17 13:00:00	SPY	ETF	673.81	674.8766	672.08	672.555	7785663.0
2025-12-17 14:00:00	SPY	ETF	672.555	673.2978	672.055	673.13	9091988.0
2025-12-17 15:00:00	SPY	ETF	673.12	673.32	671.195	671.3	18057139.0
2025-12-17 16:00:00	SPY	ETF	671.31	673.09	671.2617	672.13	3047471.0
2025-12-17 17:00:00	SPY	ETF	672.29	672.66	671.93	672.66	171495.0
2025-12-17 18:00:00	SPY	ETF	672.66	672.87	671.7	671.88	127770.0
2025-12-17 19:00:00	SPY	ETF	671.84	672.8826	671.26	672.84	79054.0
2025-12-17 04:00:00	QQQ	ETF	612.86	614.19	612.3	614.04	153992.0
2025-12-17 05:00:00	QQQ	ETF	614.03	614.72	613.86	614.51	93042.0
2025-12-17 06:00:00	QQQ	ETF	614.51	614.88	614.15	614.78	76010.0
2025-12-17 07:00:00	QQQ	ETF	614.79	615.13	614.31	614.719	232912.0
2025-12-17 08:00:00	QQQ	ETF	612.86	615.11	609.95	614.11	1182864.0
2025-12-17 09:00:00	QQQ	ETF	614.11	614.48	608.89	611.06	7267115.0
2025-12-17 10:00:00	QQQ	ETF	611.05	611.36	603.91	604.51	9215064.0
2025-12-17 11:00:00	QQQ	ETF	604.48	606.03	602.77	603.99	7895671.0
2025-12-17 12:00:00	QQQ	ETF	603.98	605.15	602.72	603.68	6509785.0
2025-12-17 13:00:00	QQQ	ETF	603.73	605.01	601.58	602.16	5564096.0
2025-12-17 14:00:00	QQQ	ETF	602.14	602.83	601.3	602.59	5640186.0
2025-12-17 15:00:00	QQQ	ETF	602.58	602.77	600.28	600.36	9504885.0
2025-12-17 16:00:00	QQQ	ETF	600.36	603.0	600.36	602.05	2266719.0
2025-12-17 17:00:00	QQQ	ETF	602.02	602.85	601.91	602.72	142385.0
2025-12-17 18:00:00	QQQ	ETF	602.71	602.92	601.32	601.4	135344.0
2025-12-17 19:00:00	QQQ	ETF	601.45	602.97	600.75	602.7468	190868.0
2025-12-17 04:00:00	IWM	ETF	250.2	250.65	250.14	250.62	22865.0
2025-12-17 05:00:00	IWM	ETF	250.55	250.78	250.5	250.76	17908.0
2025-12-17 06:00:00	IWM	ETF	250.79	250.79	250.47	250.72	40513.0
2025-12-17 07:00:00	IWM	ETF	250.75	251.21	250.61	251.06	147059.0
2025-12-17 08:00:00	IWM	ETF	250.5121	251.28	249.4	250.98	343534.0
2025-12-17 09:00:00	IWM	ETF	250.94	251.815	250.2448	251.69	3307669.0
2025-12-17 10:00:00	IWM	ETF	251.69	252.16	248.875	249.085	4241184.0
2025-12-17 11:00:00	IWM	ETF	249.07	249.73	248.17	248.83	2942549.0
2025-12-17 12:00:00	IWM	ETF	248.84	249.675	248.32	248.51	1870948.0
2025-12-17 13:00:00	IWM	ETF	248.52	248.99	247.46	247.75	2014711.0
2025-12-17 14:00:00	IWM	ETF	247.75	247.9	247.37	247.85	2422684.0
2025-12-17 15:00:00	IWM	ETF	247.87	248.0839	246.695	247.2	5996003.0
2025-12-17 16:00:00	IWM	ETF	247.24	247.9	247.1095	247.63	1768995.0
2025-12-17 17:00:00	IWM	ETF	247.68	247.99	247.52	247.99	53778.0
2025-12-17 18:00:00	IWM	ETF	247.94	247.94	247.44	247.44	55783.0
2025-12-17 19:00:00	IWM	ETF	247.45	247.9	247.39	247.83	25055.0
2025-12-17 04:00:00	DIA	ETF	482.39	482.9	482.33	482.89	6828.0
2025-12-17 05:00:00	DIA	ETF	482.97	483.13	482.97	483.13	1484.0

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

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