PREVIEW / etf_1hour / 2025-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-11-07.parquet
  size:    705 KB
  rows:    27,746

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-07 04:00:00	SPY	ETF	671.0	672.19	669.96	670.69	143575.0
2025-11-07 05:00:00	SPY	ETF	670.75	671.17	669.35	670.02	121427.0
2025-11-07 06:00:00	SPY	ETF	669.91	669.91	667.2	669.37	290617.0
2025-11-07 07:00:00	SPY	ETF	669.35	669.41	666.8	667.34	416323.0
2025-11-07 08:00:00	SPY	ETF	667.33	672.6	666.83	667.93	664402.0
2025-11-07 09:00:00	SPY	ETF	667.85	668.08	664.35	666.25	11402673.0
2025-11-07 10:00:00	SPY	ETF	666.16	667.22	663.29	663.33	13187377.0
2025-11-07 11:00:00	SPY	ETF	663.32	664.03	661.33	661.975	11148043.0
2025-11-07 12:00:00	SPY	ETF	661.97	664.275	661.205	663.94	8120326.0
2025-11-07 13:00:00	SPY	ETF	663.94	666.09	663.58	665.615	6472765.0
2025-11-07 14:00:00	SPY	ETF	665.61	669.98	665.2	669.9	11935899.0
2025-11-07 15:00:00	SPY	ETF	669.89	671.08	667.92	670.94	16115599.0
2025-11-07 16:00:00	SPY	ETF	670.92	672.07	670.8986	671.98	3724426.0
2025-11-07 17:00:00	SPY	ETF	671.94	672.1	671.94	672.04	128205.0
2025-11-07 18:00:00	SPY	ETF	672.05	672.12	671.75	672.12	61974.0
2025-11-07 19:00:00	SPY	ETF	672.0424	672.35	672.0424	672.35	50639.0
2025-11-07 20:00:00	SPY	ETF	672.36	672.36	672.36	672.36	97.0
2025-11-07 04:00:00	QQQ	ETF	612.12	613.68	611.62	612.02	136573.0
2025-11-07 05:00:00	QQQ	ETF	611.84	612.42	610.3	611.0	169139.0
2025-11-07 06:00:00	QQQ	ETF	610.89	610.92	607.79	610.1	510977.0
2025-11-07 07:00:00	QQQ	ETF	610.07	610.47	607.27	607.98	433021.0
2025-11-07 08:00:00	QQQ	ETF	609.8	614.3	607.29	608.42	1171824.0
2025-11-07 09:00:00	QQQ	ETF	608.3769	608.65	603.68	606.08	9580009.0
2025-11-07 10:00:00	QQQ	ETF	605.91	606.79	601.41	601.42	10862819.0
2025-11-07 11:00:00	QQQ	ETF	601.41	602.34	598.89	599.58	8867074.0
2025-11-07 12:00:00	QQQ	ETF	599.57	602.41	598.67	601.91	7427514.0
2025-11-07 13:00:00	QQQ	ETF	601.92	604.63	601.445	603.87	6792306.0
2025-11-07 14:00:00	QQQ	ETF	603.88	608.58	603.36	608.52	7570256.0
2025-11-07 15:00:00	QQQ	ETF	608.51	609.95	606.34	609.76	10515885.0
2025-11-07 16:00:00	QQQ	ETF	609.75	611.21	608.4011	611.21	2005840.0
2025-11-07 17:00:00	QQQ	ETF	611.25	611.25	610.96	611.2	89712.0
2025-11-07 18:00:00	QQQ	ETF	611.31	611.8596	611.24	611.8	73040.0
2025-11-07 19:00:00	QQQ	ETF	611.85	612.15	611.74	612.15	81617.0
2025-11-07 04:00:00	IWM	ETF	241.23	241.34	240.61	240.7	20048.0
2025-11-07 05:00:00	IWM	ETF	240.72	240.88	240.08	240.34	32381.0
2025-11-07 06:00:00	IWM	ETF	240.27	240.27	239.15	239.96	98872.0
2025-11-07 07:00:00	IWM	ETF	239.95	239.96	238.74	238.85	141065.0
2025-11-07 08:00:00	IWM	ETF	238.8	241.64	238.58	238.66	254052.0
2025-11-07 09:00:00	IWM	ETF	238.71	239.28	237.16	239.2	6211414.0
2025-11-07 10:00:00	IWM	ETF	239.21	239.21	237.36	237.475	5466128.0
2025-11-07 11:00:00	IWM	ETF	237.46	237.79	236.2744	236.63	5199603.0
2025-11-07 12:00:00	IWM	ETF	236.63	238.2	236.29	238.11	3915666.0
2025-11-07 13:00:00	IWM	ETF	238.11	239.28	238.04	239.11	3968023.0
2025-11-07 14:00:00	IWM	ETF	239.11	241.46	238.94	241.455	5917819.0
2025-11-07 15:00:00	IWM	ETF	241.46	241.66	240.12	241.605	8330602.0
2025-11-07 16:00:00	IWM	ETF	241.605	242.11	241.57	242.0	1318592.0
2025-11-07 17:00:00	IWM	ETF	242.03	242.11	242.0	242.09	41749.0
2025-11-07 18:00:00	IWM	ETF	242.08	242.089	241.91	242.05	17500.0
2025-11-07 19:00:00	IWM	ETF	242.08	242.18	241.93	242.12	27820.0
2025-11-07 04:00:00	DIA	ETF	469.82	470.19	469.37	469.37	5240.0

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

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