PREVIEW / etf_1hour / 2025-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-08.parquet
  size:    718 KB
  rows:    27,224

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-10-08 04:00:00	SPY	ETF	670.11	670.44	669.65	669.92	25954.0
2025-10-08 05:00:00	SPY	ETF	670.07	670.22	669.88	670.12	9492.0
2025-10-08 06:00:00	SPY	ETF	670.1	670.38	669.5	670.38	9107.0
2025-10-08 07:00:00	SPY	ETF	670.4	670.56	669.72	670.34	170361.0
2025-10-08 08:00:00	SPY	ETF	670.08	670.55	668.93	670.03	182398.0
2025-10-08 09:00:00	SPY	ETF	670.08	670.59	669.42	670.28	6782827.0
2025-10-08 10:00:00	SPY	ETF	670.29	672.165	670.285	671.76	7781849.0
2025-10-08 11:00:00	SPY	ETF	671.76	672.96	671.685	672.77	4940477.0
2025-10-08 12:00:00	SPY	ETF	672.78	673.0985	672.23	672.715	3276715.0
2025-10-08 13:00:00	SPY	ETF	672.71	673.03	672.44	672.64	2918856.0
2025-10-08 14:00:00	SPY	ETF	672.64	673.14	672.17	672.25	4900719.0
2025-10-08 15:00:00	SPY	ETF	672.24	673.2056	672.15	673.07	10750434.0
2025-10-08 16:00:00	SPY	ETF	673.05	673.63	672.887	673.17	3193752.0
2025-10-08 17:00:00	SPY	ETF	673.3	673.39	672.95	673.05	77619.0
2025-10-08 18:00:00	SPY	ETF	673.1	673.6	673.1	673.589	44382.0
2025-10-08 19:00:00	SPY	ETF	673.62	674.0488	673.47	673.78	34369.0
2025-10-08 04:00:00	QQQ	ETF	605.48	606.14	604.8	605.54	98421.0
2025-10-08 05:00:00	QQQ	ETF	605.55	605.81	605.31	605.58	45020.0
2025-10-08 06:00:00	QQQ	ETF	605.58	605.84	604.9	605.83	55795.0
2025-10-08 07:00:00	QQQ	ETF	605.82	605.99	604.91	605.64	81874.0
2025-10-08 08:00:00	QQQ	ETF	605.81	606.05	604.057	604.95	282611.0
2025-10-08 09:00:00	QQQ	ETF	604.97	607.81	604.81	607.58	5357213.0
2025-10-08 10:00:00	QQQ	ETF	607.59	608.945	607.585	608.095	6557916.0
2025-10-08 11:00:00	QQQ	ETF	608.1	609.685	608.02	609.538	3793719.0
2025-10-08 12:00:00	QQQ	ETF	609.54	610.06	609.03	609.4696	2871666.0
2025-10-08 13:00:00	QQQ	ETF	609.47	610.36	609.2	610.03	2477026.0
2025-10-08 14:00:00	QQQ	ETF	610.02	610.59	609.82	609.96	3623702.0
2025-10-08 15:00:00	QQQ	ETF	609.95	611.75	609.9	611.45	8589497.0
2025-10-08 16:00:00	QQQ	ETF	611.44	612.23	608.0334	611.93	1659295.0
2025-10-08 17:00:00	QQQ	ETF	611.95	611.98	611.6959	611.7649	26787.0
2025-10-08 18:00:00	QQQ	ETF	611.8	612.31	611.8	612.31	60364.0
2025-10-08 19:00:00	QQQ	ETF	612.33	612.9091	612.25	612.63	87802.0
2025-10-08 04:00:00	IWM	ETF	244.78	245.04	244.66	244.83	34765.0
2025-10-08 05:00:00	IWM	ETF	244.86	245.15	244.86	244.99	17031.0
2025-10-08 06:00:00	IWM	ETF	244.99	245.22	244.8	245.2	12507.0
2025-10-08 07:00:00	IWM	ETF	245.18	245.35	244.76	245.27	32366.0
2025-10-08 08:00:00	IWM	ETF	245.27	245.31	244.35	245.1	67062.0
2025-10-08 09:00:00	IWM	ETF	245.1	245.36	243.8	244.815	2598346.0
2025-10-08 10:00:00	IWM	ETF	244.83	245.7363	244.81	245.555	2836860.0
2025-10-08 11:00:00	IWM	ETF	245.57	246.47	245.29	246.31	1981100.0
2025-10-08 12:00:00	IWM	ETF	246.32	246.8	246.2201	246.77	1540235.0
2025-10-08 13:00:00	IWM	ETF	246.79	246.955	246.285	246.3203	1535605.0
2025-10-08 14:00:00	IWM	ETF	246.325	246.53	245.69	245.88	1928925.0
2025-10-08 15:00:00	IWM	ETF	245.87	246.77	245.78	246.68	4288401.0
2025-10-08 16:00:00	IWM	ETF	246.68	246.88	246.62	246.73	1238679.0
2025-10-08 17:00:00	IWM	ETF	246.85	246.87	246.49	246.49	30130.0
2025-10-08 18:00:00	IWM	ETF	246.66	246.98	246.65	246.87	24021.0
2025-10-08 19:00:00	IWM	ETF	246.92	247.06	246.79	246.81	13833.0
2025-10-08 04:00:00	DIA	ETF	466.7	466.75	466.26	466.35	2600.0
2025-10-08 05:00:00	DIA	ETF	466.63	466.74	466.62	466.73	700.0

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

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