PREVIEW / etf_1hour / 2025-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-11-05.parquet
  size:    713 KB
  rows:    27,493

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-05 04:00:00	SPY	ETF	674.37	675.27	673.87	674.54	54347.0
2025-11-05 05:00:00	SPY	ETF	674.28	675.03	672.56	672.6	43234.0
2025-11-05 06:00:00	SPY	ETF	672.55	674.11	672.42	673.82	58133.0
2025-11-05 07:00:00	SPY	ETF	673.9	674.86	673.47	674.8	202397.0
2025-11-05 08:00:00	SPY	ETF	674.74	675.91	672.52	675.72	585222.0
2025-11-05 09:00:00	SPY	ETF	675.71	677.6	674.17	677.28	7084252.0
2025-11-05 10:00:00	SPY	ETF	677.1	678.2782	675.4	677.87	9368568.0
2025-11-05 11:00:00	SPY	ETF	677.88	679.75	676.76	679.38	6753184.0
2025-11-05 12:00:00	SPY	ETF	679.37	680.8599	679.03	680.22	5173947.0
2025-11-05 13:00:00	SPY	ETF	680.21	680.86	680.0199	680.658	3542731.0
2025-11-05 14:00:00	SPY	ETF	680.64	680.64	679.74	680.23	4350139.0
2025-11-05 15:00:00	SPY	ETF	680.23	680.52	677.4	677.51	14272077.0
2025-11-05 16:00:00	SPY	ETF	677.5	678.18	677.11	677.83	3399474.0
2025-11-05 17:00:00	SPY	ETF	677.9055	678.07	677.71	678.06	98042.0
2025-11-05 18:00:00	SPY	ETF	678.06	678.59	677.27	678.58	434521.0
2025-11-05 19:00:00	SPY	ETF	678.58	678.58	676.24	677.2799	132410.0
2025-11-05 04:00:00	QQQ	ETF	615.84	618.73	615.84	617.89	223140.0
2025-11-05 05:00:00	QQQ	ETF	617.96	618.41	615.38	615.47	229888.0
2025-11-05 06:00:00	QQQ	ETF	615.4	617.14	615.25	617.07	168702.0
2025-11-05 07:00:00	QQQ	ETF	617.05	618.4	616.53	618.23	349092.0
2025-11-05 08:00:00	QQQ	ETF	616.47	619.83	615.43	619.62	1101342.0
2025-11-05 09:00:00	QQQ	ETF	619.62	622.13	617.21	621.98	6457079.0
2025-11-05 10:00:00	QQQ	ETF	621.94	623.19	620.34	622.81	7566606.0
2025-11-05 11:00:00	QQQ	ETF	622.82	624.43	621.33	624.1	4752751.0
2025-11-05 12:00:00	QQQ	ETF	624.09	625.41	623.29	625.02	2936703.0
2025-11-05 13:00:00	QQQ	ETF	625.02	626.48	624.84	626.3	2448501.0
2025-11-05 14:00:00	QQQ	ETF	626.29	626.57	625.29	626.25	3181087.0
2025-11-05 15:00:00	QQQ	ETF	626.26	626.6	623.06	623.29	6567683.0
2025-11-05 16:00:00	QQQ	ETF	623.29	623.83	622.22	622.9358	2156819.0
2025-11-05 17:00:00	QQQ	ETF	622.9168	623.36	622.8	623.28	54903.0
2025-11-05 18:00:00	QQQ	ETF	623.46	624.0995	622.36	624.06	126862.0
2025-11-05 19:00:00	QQQ	ETF	624.05	624.05	621.2199	622.3468	277497.0
2025-11-05 04:00:00	IWM	ETF	241.7	241.83	241.21	241.46	51089.0
2025-11-05 05:00:00	IWM	ETF	241.48	241.66	240.9	240.96	157581.0
2025-11-05 06:00:00	IWM	ETF	240.9	241.76	240.83	241.55	116308.0
2025-11-05 07:00:00	IWM	ETF	241.55	242.02	241.38	242.0	212882.0
2025-11-05 08:00:00	IWM	ETF	241.45	242.35	241.04	242.25	486880.0
2025-11-05 09:00:00	IWM	ETF	242.23	243.38	241.64	243.18	4027591.0
2025-11-05 10:00:00	IWM	ETF	243.11	243.46	242.12	243.15	5449970.0
2025-11-05 11:00:00	IWM	ETF	243.16	244.9	242.48	244.68	3864490.0
2025-11-05 12:00:00	IWM	ETF	244.67	245.335	244.42	245.1	2506562.0
2025-11-05 13:00:00	IWM	ETF	245.1	245.27	244.66	244.84	2048342.0
2025-11-05 14:00:00	IWM	ETF	244.84	245.32	244.56	245.21	2161527.0
2025-11-05 15:00:00	IWM	ETF	245.215	245.7297	244.66	244.71	6648484.0
2025-11-05 16:00:00	IWM	ETF	244.68	245.06	244.4	244.97	965815.0
2025-11-05 17:00:00	IWM	ETF	244.83	244.98	244.7288	244.81	35313.0
2025-11-05 18:00:00	IWM	ETF	244.83	245.0	244.56	245.0	80206.0
2025-11-05 19:00:00	IWM	ETF	244.94	244.94	244.01	244.42	24962.0
2025-11-05 04:00:00	DIA	ETF	471.53	471.6	470.97	470.98	3690.0
2025-11-05 05:00:00	DIA	ETF	471.02	471.39	470.22	470.24	7323.0

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

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