PREVIEW / etf_daily / 2024-01-26

all etf daily files

  file:    by_date/etf_daily/2024/2024-01-26.parquet
  size:    116 KB
  rows:    3,232

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2024-01-26	SPY	ETF	487.59	489.12	486.54	487.41	76641600.0
2024-01-26	QQQ	ETF	424.44	426.21	423.15	423.81	37137028.0
2024-01-26	IWM	ETF	196.89	197.89	195.38	195.98	33478600.0
2024-01-26	DIA	ETF	379.98	382.13	379.95	381.09	3221000.0
2024-01-26	GLD	ETF	187.27	187.38	186.76	187.01	5064800.0
2024-01-26	TLT	ETF	93.93	94.07	93.49	93.78	29276900.0
2024-01-26	AAA	ETF	25.12	25.228	25.09	25.16	14400.0
2024-01-26	AAAU	ETF	20.02	20.02	19.96	19.99	1407600.0
2024-01-26	AADR	ETF	55.98	56.13	55.98	56.13	300.0
2024-01-26	AAPB	ETF	23.1299	23.18	22.64	22.69	20890.0
2024-01-26	AAPD	ETF	20.05	20.29	20.0	20.25	170482.0
2024-01-26	AAPU	ETF	27.52	27.65	27.081	27.15	67758.0
2024-01-26	AAPX	ETF	26.6	26.6	26.47	26.5245	739.0
2024-01-26	AAXJ	ETF	63.98	64.24	63.93	64.04	338200.0
2024-01-26	ABCS	ETF	25.0964	25.1	25.0964	25.1	100.0
2024-01-26	ABEQ	ETF	28.66	28.66	28.59	28.61	1000.0
2024-01-26	ACES	ETF	29.86	30.18	29.575	29.64	146700.0
2024-01-26	ACIO	ETF	33.93	34.004	33.874	33.93	65000.0
2024-01-26	ACSI	ETF	49.94	49.94	49.94	49.94	100.0
2024-01-26	ACT	ETF	28.5	28.805	28.355	28.68	470124.0
2024-01-26	ACTV	ETF	32.89	33.07	32.85	32.881	7500.0
2024-01-26	ACVF	ETF	37.38	37.46	37.33	37.399	3600.0
2024-01-26	ACWF	ETF	38.73	38.74	38.63	38.7	4721.0
2024-01-26	ACWI	ETF	102.9	103.13	102.7	102.88	4609900.0
2024-01-26	ACWV	ETF	101.66	101.77	101.51	101.62	139500.0
2024-01-26	ACWX	ETF	50.29	50.46	50.29	50.36	1066500.0
2024-01-26	ADFI	ETF	8.535	8.55	8.521	8.525	14700.0
2024-01-26	ADIV	ETF	13.725	13.725	13.725	13.725	100.0
2024-01-26	ADME	ETF	39.38	39.48	39.31	39.374	6000.0
2024-01-26	ADPV	ETF	24.96	25.16	24.96	25.0908	13283.0
2024-01-26	AEMB	ETF	37.633	37.633	37.633	37.633	100.0
2024-01-26	AESR	ETF	14.29	14.33	14.27	14.27	10700.0
2024-01-26	AETH	ETF	30.9052	31.17	30.9052	30.9903	3476.0
2024-01-26	AFIF	ETF	9.08	9.12	9.07	9.11	21800.0
2024-01-26	AFK	ETF	13.65	13.81	13.48	13.52	7000.0
2024-01-26	AFLG	ETF	28.074	28.074	28.074	28.074	100.0
2024-01-26	AFMC	ETF	26.929	26.93	26.89	26.89	700.0
2024-01-26	AFTY	ETF	13.203	13.203	13.203	13.203	100.0
2024-01-26	AGG	ETF	98.2	98.2	97.98	98.07	5022800.0
2024-01-26	AGGH	ETF	21.58	21.58	21.4747	21.51	117589.0
2024-01-26	AGGY	ETF	43.45	43.46	43.37	43.37	74700.0
2024-01-26	AGNG	ETF	28.22	28.225	28.11	28.21	2100.0
2024-01-26	AGOX	ETF	24.215	24.43	24.17	24.34	27400.0
2024-01-26	AGQ	ETF	24.55	24.8	24.45	24.67	750000.0
2024-01-26	AGQI	ETF	13.46	13.48	13.4301	13.45	19572.0
2024-01-26	AGRH	ETF	25.94	25.94	25.88	25.885	815.0
2024-01-26	AGZ	ETF	108.25	108.25	108.15	108.22	15100.0
2024-01-26	AGZD	ETF	21.89	21.97	21.88	21.91	22300.0
2024-01-26	AHLT	ETF	22.27	22.3	22.26	22.264	4585.0
2024-01-26	AHYB	ETF	45.598	45.598	45.54	45.54	900.0

> showing 50 of 3,232 rows — these rows as CSV

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