PREVIEW / etf_1hour / 2025-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-21.parquet
  size:    703 KB
  rows:    27,142

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-21 04:00:00	SPY	ETF	671.33	671.33	670.4	670.54	54255.0
2025-10-21 05:00:00	SPY	ETF	670.55	671.16	670.5	670.91	31209.0
2025-10-21 06:00:00	SPY	ETF	670.93	671.19	670.61	671.15	18840.0
2025-10-21 07:00:00	SPY	ETF	671.15	671.8	671.05	671.7	135280.0
2025-10-21 08:00:00	SPY	ETF	671.04	671.824	670.5296	671.41	162067.0
2025-10-21 09:00:00	SPY	ETF	671.42	671.78	670.15	670.57	4843873.0
2025-10-21 10:00:00	SPY	ETF	670.56	672.64	669.981	672.57	6753288.0
2025-10-21 11:00:00	SPY	ETF	672.58	672.7313	671.4	672.28	4908053.0
2025-10-21 12:00:00	SPY	ETF	672.27	672.99	671.355	671.49	5187693.0
2025-10-21 13:00:00	SPY	ETF	671.51	672.31	670.76	672.205	4276934.0
2025-10-21 14:00:00	SPY	ETF	672.21	672.52	671.78	671.95	3333739.0
2025-10-21 15:00:00	SPY	ETF	671.94	672.4	671.16	671.27	7368662.0
2025-10-21 16:00:00	SPY	ETF	671.26	672.0	670.5198	671.24	2295702.0
2025-10-21 17:00:00	SPY	ETF	671.0962	671.46	670.88	671.22	122473.0
2025-10-21 18:00:00	SPY	ETF	671.28	671.7	671.2127	671.48	62848.0
2025-10-21 19:00:00	SPY	ETF	671.5	671.5	670.95	671.03	34591.0
2025-10-21 04:00:00	QQQ	ETF	611.78	611.78	610.58	610.81	94855.0
2025-10-21 05:00:00	QQQ	ETF	610.84	611.52	610.81	611.17	101836.0
2025-10-21 06:00:00	QQQ	ETF	611.2	611.31	610.65	611.12	127663.0
2025-10-21 07:00:00	QQQ	ETF	611.12	611.86	611.02	611.83	133384.0
2025-10-21 08:00:00	QQQ	ETF	611.12	612.28	610.7	611.61	403164.0
2025-10-21 09:00:00	QQQ	ETF	611.59	611.75	609.5412	610.03	4217549.0
2025-10-21 10:00:00	QQQ	ETF	610.04	611.69	609.32	611.6	4725287.0
2025-10-21 11:00:00	QQQ	ETF	611.61	612.25	610.251	612.15	3355581.0
2025-10-21 12:00:00	QQQ	ETF	612.14	612.7213	611.055	611.24	3356125.0
2025-10-21 13:00:00	QQQ	ETF	611.24	611.94	610.37	611.91	3098672.0
2025-10-21 14:00:00	QQQ	ETF	611.91	612.2	611.35	611.8301	2116949.0
2025-10-21 15:00:00	QQQ	ETF	611.81	612.43	611.25	611.41	4239269.0
2025-10-21 16:00:00	QQQ	ETF	611.39	611.59	609.89	610.75	1933236.0
2025-10-21 17:00:00	QQQ	ETF	610.74	611.03	610.2807	610.88	109098.0
2025-10-21 18:00:00	QQQ	ETF	610.87	611.2	610.5899	610.85	62639.0
2025-10-21 19:00:00	QQQ	ETF	610.6	610.81	610.17	610.25	63559.0
2025-10-21 04:00:00	IWM	ETF	247.89	247.91	247.45	247.56	77141.0
2025-10-21 05:00:00	IWM	ETF	247.58	247.86	247.52	247.74	38060.0
2025-10-21 06:00:00	IWM	ETF	247.74	247.87	247.48	247.79	55056.0
2025-10-21 07:00:00	IWM	ETF	247.82	248.16	247.76	248.03	60814.0
2025-10-21 08:00:00	IWM	ETF	247.47	248.47	247.47	247.73	168873.0
2025-10-21 09:00:00	IWM	ETF	247.73	247.75	245.505	245.79	2888185.0
2025-10-21 10:00:00	IWM	ETF	245.78	248.24	245.6	248.195	3242873.0
2025-10-21 11:00:00	IWM	ETF	248.195	248.365	247.48	247.94	2277740.0
2025-10-21 12:00:00	IWM	ETF	247.94	248.35	247.35	247.45	1492219.0
2025-10-21 13:00:00	IWM	ETF	247.46	247.79	246.885	247.32	1711743.0
2025-10-21 14:00:00	IWM	ETF	247.32	247.48	246.82	246.93	1390183.0
2025-10-21 15:00:00	IWM	ETF	246.92	247.305	246.52	246.98	3716194.0
2025-10-21 16:00:00	IWM	ETF	246.99	247.1	246.82	246.99	2583422.0
2025-10-21 17:00:00	IWM	ETF	247.17	247.19	246.82	246.82	29432.0
2025-10-21 18:00:00	IWM	ETF	246.87	246.96	246.73	246.88	16764.0
2025-10-21 19:00:00	IWM	ETF	246.85	246.85	246.53	246.53	10165.0
2025-10-21 04:00:00	DIA	ETF	466.38	466.38	466.13	466.24	800.0
2025-10-21 05:00:00	DIA	ETF	466.23	466.57	466.23	466.57	2087.0

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

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