PREVIEW / etf_1hour / 2025-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-20.parquet
  size:    704 KB
  rows:    27,384

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-20 04:00:00	SPY	ETF	666.0	667.21	666.0	666.15	48559.0
2025-10-20 05:00:00	SPY	ETF	666.05	666.6	665.81	666.29	14716.0
2025-10-20 06:00:00	SPY	ETF	666.32	666.72	665.22	665.52	29962.0
2025-10-20 07:00:00	SPY	ETF	665.29	666.47	665.27	666.36	142678.0
2025-10-20 08:00:00	SPY	ETF	666.35	667.58	665.2791	667.37	451822.0
2025-10-20 09:00:00	SPY	ETF	667.38	669.455	667.17	668.74	6008002.0
2025-10-20 10:00:00	SPY	ETF	668.75	671.46	668.73	671.2101	6547347.0
2025-10-20 11:00:00	SPY	ETF	671.22	671.31	670.16	670.55	4585578.0
2025-10-20 12:00:00	SPY	ETF	670.58	671.09	670.21	671.045	2903739.0
2025-10-20 13:00:00	SPY	ETF	671.03	672.12	671.01	671.7988	3184430.0
2025-10-20 14:00:00	SPY	ETF	671.8	672.21	671.175	671.66	3604334.0
2025-10-20 15:00:00	SPY	ETF	671.67	672.1	671.2	671.27	9167666.0
2025-10-20 16:00:00	SPY	ETF	671.27	671.92	670.93	671.9	2545337.0
2025-10-20 17:00:00	SPY	ETF	671.9	672.23	671.85	672.0	75487.0
2025-10-20 18:00:00	SPY	ETF	671.96	672.0	671.58	671.7	79510.0
2025-10-20 19:00:00	SPY	ETF	671.82	672.1	671.5813	671.7497	42467.0
2025-10-20 04:00:00	QQQ	ETF	607.3	607.51	606.0	606.14	129965.0
2025-10-20 05:00:00	QQQ	ETF	606.16	606.74	605.85	606.44	92592.0
2025-10-20 06:00:00	QQQ	ETF	606.44	606.81	605.3	605.39	170630.0
2025-10-20 07:00:00	QQQ	ETF	605.31	606.5	605.27	606.38	113183.0
2025-10-20 08:00:00	QQQ	ETF	606.34	607.85	603.478	607.43	529114.0
2025-10-20 09:00:00	QQQ	ETF	607.43	610.07	607.065	609.63	4932711.0
2025-10-20 10:00:00	QQQ	ETF	609.65	612.03	609.42	611.84	4852400.0
2025-10-20 11:00:00	QQQ	ETF	611.86	612.58	611.24	611.905	3606055.0
2025-10-20 12:00:00	QQQ	ETF	611.91	612.16	611.27	611.85	2133795.0
2025-10-20 13:00:00	QQQ	ETF	611.84	612.8	611.78	612.37	2289606.0
2025-10-20 14:00:00	QQQ	ETF	612.34	612.78	611.68	612.16	2414034.0
2025-10-20 15:00:00	QQQ	ETF	612.18	612.37	611.443	611.55	5094782.0
2025-10-20 16:00:00	QQQ	ETF	611.55	612.14	611.33	612.14	1472182.0
2025-10-20 17:00:00	QQQ	ETF	612.09	612.2	611.92	612.09	63198.0
2025-10-20 18:00:00	QQQ	ETF	612.08	612.15	611.7111	612.0	71920.0
2025-10-20 19:00:00	QQQ	ETF	612.1	612.55	611.94	612.06	72979.0
2025-10-20 04:00:00	IWM	ETF	245.14	245.64	245.03	245.17	108132.0
2025-10-20 05:00:00	IWM	ETF	245.13	245.34	244.97	245.25	78164.0
2025-10-20 06:00:00	IWM	ETF	245.28	245.34	244.79	244.82	80765.0
2025-10-20 07:00:00	IWM	ETF	244.8	245.43	244.78	245.36	78866.0
2025-10-20 08:00:00	IWM	ETF	245.32	246.11	244.76	246.07	440747.0
2025-10-20 09:00:00	IWM	ETF	246.07	248.13	246.05	246.91	4101947.0
2025-10-20 10:00:00	IWM	ETF	246.94	248.25	246.15	247.83	4725598.0
2025-10-20 11:00:00	IWM	ETF	247.85	247.95	246.6	246.91	2863285.0
2025-10-20 12:00:00	IWM	ETF	246.93	247.67	246.66	247.66	1875628.0
2025-10-20 13:00:00	IWM	ETF	247.66	248.11	247.65	248.11	1255582.0
2025-10-20 14:00:00	IWM	ETF	248.105	248.33	247.772	248.1	1649357.0
2025-10-20 15:00:00	IWM	ETF	248.115	248.26	247.83	248.13	4097643.0
2025-10-20 16:00:00	IWM	ETF	248.11	248.5	248.01	248.4399	1755707.0
2025-10-20 17:00:00	IWM	ETF	248.47	248.6599	248.22	248.47	52809.0
2025-10-20 18:00:00	IWM	ETF	248.42	248.73	248.42	248.48	30215.0
2025-10-20 19:00:00	IWM	ETF	248.51	248.7	248.46	248.51	17586.0
2025-10-20 04:00:00	DIA	ETF	463.26	463.26	462.63	462.63	2730.0
2025-10-20 05:00:00	DIA	ETF	462.67	463.05	462.67	463.05	1000.0

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

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