PREVIEW / etf_1hour / 2025-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-11-10.parquet
  size:    727 KB
  rows:    27,758

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-10 04:00:00	SPY	ETF	675.62	677.94	675.62	677.62	109159.0
2025-11-10 05:00:00	SPY	ETF	677.62	677.8	677.3	677.38	25565.0
2025-11-10 06:00:00	SPY	ETF	677.39	677.65	676.76	677.65	97487.0
2025-11-10 07:00:00	SPY	ETF	677.65	677.74	676.79	677.11	413711.0
2025-11-10 08:00:00	SPY	ETF	677.59	677.7316	675.39	677.58	367507.0
2025-11-10 09:00:00	SPY	ETF	677.6	679.2	676.93	678.545	10471075.0
2025-11-10 10:00:00	SPY	ETF	678.54	679.22	676.15	676.24	8765662.0
2025-11-10 11:00:00	SPY	ETF	676.25	676.82	675.03	676.63	7079517.0
2025-11-10 12:00:00	SPY	ETF	676.62	679.75	676.45	679.42	6040940.0
2025-11-10 13:00:00	SPY	ETF	679.42	680.54	679.34	679.875	4731784.0
2025-11-10 14:00:00	SPY	ETF	679.88	681.67	679.84	681.3	5589080.0
2025-11-10 15:00:00	SPY	ETF	681.29	682.18	681.03	681.33	13743145.0
2025-11-10 16:00:00	SPY	ETF	681.32	682.0	681.18	681.42	2666528.0
2025-11-10 17:00:00	SPY	ETF	681.51	681.6	681.25	681.49	127431.0
2025-11-10 18:00:00	SPY	ETF	681.49	681.9	681.11	681.85	91069.0
2025-11-10 19:00:00	SPY	ETF	681.8	682.33	681.58	681.66	71076.0
2025-11-10 04:00:00	QQQ	ETF	617.12	619.67	617.12	619.27	190408.0
2025-11-10 05:00:00	QQQ	ETF	619.35	619.42	618.69	618.78	151326.0
2025-11-10 06:00:00	QQQ	ETF	618.78	619.13	618.18	619.13	134502.0
2025-11-10 07:00:00	QQQ	ETF	619.12	619.25	618.36	618.97	303331.0
2025-11-10 08:00:00	QQQ	ETF	617.82	619.47	610.197	619.33	614477.0
2025-11-10 09:00:00	QQQ	ETF	619.32	621.77	618.5	621.29	7636558.0
2025-11-10 10:00:00	QQQ	ETF	621.28	622.04	618.43	618.57	7592513.0
2025-11-10 11:00:00	QQQ	ETF	618.59	618.94	616.89	618.57	5390473.0
2025-11-10 12:00:00	QQQ	ETF	618.57	621.55	618.24	621.262	4062711.0
2025-11-10 13:00:00	QQQ	ETF	621.28	622.4156	621.1123	621.55	3598468.0
2025-11-10 14:00:00	QQQ	ETF	621.56	623.25	621.44	622.897	3337722.0
2025-11-10 15:00:00	QQQ	ETF	622.9	624.31	622.77	623.18	7397922.0
2025-11-10 16:00:00	QQQ	ETF	623.18	623.97	623.07	623.36	1701166.0
2025-11-10 17:00:00	QQQ	ETF	623.33	623.74	623.32	623.6	46524.0
2025-11-10 18:00:00	QQQ	ETF	623.59	623.97	622.98	623.9	103525.0
2025-11-10 19:00:00	QQQ	ETF	623.899	624.53	623.6	623.82	101706.0
2025-11-10 04:00:00	IWM	ETF	244.1	244.68	244.09	244.42	95676.0
2025-11-10 05:00:00	IWM	ETF	244.42	244.75	244.36	244.6	35418.0
2025-11-10 06:00:00	IWM	ETF	244.6	244.77	244.17	244.5	53037.0
2025-11-10 07:00:00	IWM	ETF	244.53	244.74	244.5	244.64	64721.0
2025-11-10 08:00:00	IWM	ETF	244.62	244.99	243.28	244.93	170643.0
2025-11-10 09:00:00	IWM	ETF	244.9	245.18	243.69	243.74	4066269.0
2025-11-10 10:00:00	IWM	ETF	243.75	244.17	242.36	242.54	4688637.0
2025-11-10 11:00:00	IWM	ETF	242.54	243.55	242.25	243.54	3208398.0
2025-11-10 12:00:00	IWM	ETF	243.54	244.72	243.475	244.605	2269352.0
2025-11-10 13:00:00	IWM	ETF	244.605	244.79	244.41	244.48	1869437.0
2025-11-10 14:00:00	IWM	ETF	244.47	245.24	244.4	244.955	1825527.0
2025-11-10 15:00:00	IWM	ETF	244.95	245.16	243.985	244.015	4729208.0
2025-11-10 16:00:00	IWM	ETF	244.015	244.3	243.92	244.11	990214.0
2025-11-10 17:00:00	IWM	ETF	243.96	244.2	243.68	244.18	64495.0
2025-11-10 18:00:00	IWM	ETF	244.18	244.37	243.95	244.25	26718.0
2025-11-10 19:00:00	IWM	ETF	244.36	244.58	244.16	244.1992	39829.0
2025-11-10 04:00:00	DIA	ETF	471.64	472.13	471.64	471.88	728.0
2025-11-10 05:00:00	DIA	ETF	472.01	472.04	471.91	471.96	1205.0

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

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