PREVIEW / etf_1hour / 2025-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-11-12.parquet
  size:    699 KB
  rows:    27,135

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-12 04:00:00	SPY	ETF	685.88	685.88	684.62	685.56	29009.0
2025-11-12 05:00:00	SPY	ETF	685.58	685.75	684.74	685.08	40152.0
2025-11-12 06:00:00	SPY	ETF	685.1	685.2	684.04	684.22	105935.0
2025-11-12 07:00:00	SPY	ETF	684.25	685.52	684.0	685.28	133846.0
2025-11-12 08:00:00	SPY	ETF	684.03	685.73	683.74	685.23	188808.0
2025-11-12 09:00:00	SPY	ETF	685.21	685.22	683.12	683.735	6533730.0
2025-11-12 10:00:00	SPY	ETF	683.73	684.27	681.7954	682.35	7166940.0
2025-11-12 11:00:00	SPY	ETF	682.33	683.01	680.945	681.76	5861828.0
2025-11-12 12:00:00	SPY	ETF	681.76	683.85	681.54	683.63	4629091.0
2025-11-12 13:00:00	SPY	ETF	683.64	684.1499	683.05	683.63	3738104.0
2025-11-12 14:00:00	SPY	ETF	683.64	683.8	682.24	682.81	5455264.0
2025-11-12 15:00:00	SPY	ETF	682.8	684.07	682.092	683.33	12124004.0
2025-11-12 16:00:00	SPY	ETF	683.3	684.0	682.96	683.0	2785730.0
2025-11-12 17:00:00	SPY	ETF	683.03	683.38	682.95	683.06	374635.0
2025-11-12 18:00:00	SPY	ETF	683.06	683.16	680.92	681.5	157999.0
2025-11-12 19:00:00	SPY	ETF	681.5875	682.64	681.5875	682.0825	59152.0
2025-11-12 04:00:00	QQQ	ETF	624.62	625.95	624.62	625.83	96672.0
2025-11-12 05:00:00	QQQ	ETF	625.84	626.04	624.88	625.14	71182.0
2025-11-12 06:00:00	QQQ	ETF	625.32	625.44	623.68	623.76	79606.0
2025-11-12 07:00:00	QQQ	ETF	623.8	625.41	623.5	625.18	331135.0
2025-11-12 08:00:00	QQQ	ETF	623.67	626.02	621.104	625.37	329501.0
2025-11-12 09:00:00	QQQ	ETF	625.33	625.37	619.6	620.35	6168472.0
2025-11-12 10:00:00	QQQ	ETF	620.36	621.96	618.84	619.44	7155526.0
2025-11-12 11:00:00	QQQ	ETF	619.45	620.66	617.81	618.85	5696493.0
2025-11-12 12:00:00	QQQ	ETF	618.84	621.16	618.56	620.71	3863260.0
2025-11-12 13:00:00	QQQ	ETF	620.72	621.405	620.1	620.8101	3776045.0
2025-11-12 14:00:00	QQQ	ETF	620.82	621.0915	619.36	620.04	3248574.0
2025-11-12 15:00:00	QQQ	ETF	620.01	621.7	619.16	621.04	5681088.0
2025-11-12 16:00:00	QQQ	ETF	621.08	621.75	620.5358	621.08	1681874.0
2025-11-12 17:00:00	QQQ	ETF	621.12	621.44	621.0	621.0	47633.0
2025-11-12 18:00:00	QQQ	ETF	621.0	621.28	618.17	619.04	345480.0
2025-11-12 19:00:00	QQQ	ETF	619.02	620.46	619.02	619.6	189737.0
2025-11-12 04:00:00	IWM	ETF	244.44	244.95	244.39	244.76	41064.0
2025-11-12 05:00:00	IWM	ETF	244.73	244.84	244.5	244.54	9547.0
2025-11-12 06:00:00	IWM	ETF	244.65	244.66	244.31	244.41	36231.0
2025-11-12 07:00:00	IWM	ETF	244.39	245.3	244.36	245.28	101269.0
2025-11-12 08:00:00	IWM	ETF	244.61	245.38	243.92	244.98	73257.0
2025-11-12 09:00:00	IWM	ETF	244.95	246.265	244.64	246.22	4333595.0
2025-11-12 10:00:00	IWM	ETF	246.2	246.375	243.92	244.27	4753304.0
2025-11-12 11:00:00	IWM	ETF	244.265	244.57	243.33	244.05	4063037.0
2025-11-12 12:00:00	IWM	ETF	244.05	244.605	243.59	244.55	2860928.0
2025-11-12 13:00:00	IWM	ETF	244.55	244.64	243.85	244.34	2594961.0
2025-11-12 14:00:00	IWM	ETF	244.35	244.39	243.79	244.05	2275411.0
2025-11-12 15:00:00	IWM	ETF	244.04	244.33	243.385	243.64	5262369.0
2025-11-12 16:00:00	IWM	ETF	243.64	243.9	243.34	243.39	729999.0
2025-11-12 17:00:00	IWM	ETF	243.42	243.48	243.2	243.38	41409.0
2025-11-12 18:00:00	IWM	ETF	243.39	243.39	242.57	242.78	51108.0
2025-11-12 19:00:00	IWM	ETF	242.95	243.14	242.64	242.85	59675.0
2025-11-12 04:00:00	DIA	ETF	479.97	480.29	479.86	480.27	2860.0
2025-11-12 05:00:00	DIA	ETF	480.2	480.23	479.92	480.17	1232.0

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

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