PREVIEW / etf_daily / 2024-09-04

all etf daily files

  file:    by_date/etf_daily/2024/2024-09-04.parquet
  size:    133 KB
  rows:    3,478

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-09-04	SPY	ETF	550.2	554.43	549.46	550.95	47538337.0
2024-09-04	QQQ	ETF	458.67	464.45	457.73	460.61	32505102.0
2024-09-04	IWM	ETF	212.76	215.37	211.7	212.99	23705293.0
2024-09-04	DIA	ETF	409.97	412.5499	409.23	410.42	2128593.0
2024-09-04	GLD	ETF	229.79	231.06	229.375	230.43	4642674.0
2024-09-04	TLT	ETF	97.88	99.03	97.81	99.01	40826172.0
2024-09-04	AAA	ETF	25.0788	25.0788	25.0	25.01	6529.0
2024-09-04	AAAU	ETF	24.595	24.7241	24.555	24.66	1118022.0
2024-09-04	AADR	ETF	62.12	62.12	61.84	61.84	561.0
2024-09-04	AAPB	ETF	27.42	27.42	26.4	27.2	84074.0
2024-09-04	AAPD	ETF	17.39	17.715	17.39	17.47	435069.0
2024-09-04	AAPR	ETF	25.7693	25.8	25.75	25.7827	4281.0
2024-09-04	AAPU	ETF	35.05	35.05	33.75	34.74	710186.0
2024-09-04	AAPX	ETF	31.61	31.61	30.6	31.5	22711.0
2024-09-04	AAPY	ETF	26.62	26.6664	26.61	26.6664	972.0
2024-09-04	AAXJ	ETF	71.26	71.87	71.26	71.42	381828.0
2024-09-04	ABCS	ETF	27.65	27.67	27.4899	27.53	1638.0
2024-09-04	ABEQ	ETF	32.6	32.74	32.4852	32.4852	6584.0
2024-09-04	ABNY	ETF	81.0	81.0	79.85	80.267	1566.0
2024-09-04	ACES	ETF	27.41	28.105	27.41	27.92	10638.0
2024-09-04	ACIO	ETF	38.62	38.8303	38.62	38.74	90589.0
2024-09-04	ACSI	ETF	56.7708	56.7708	56.7708	56.7708	42.0
2024-09-04	ACT	ETF	35.28	35.77	35.28	35.55	279873.0
2024-09-04	ACTV	ETF	32.32	32.67	32.32	32.5132	5089.0
2024-09-04	ACVF	ETF	42.03	42.2125	42.03	42.1228	6510.0
2024-09-04	ACWI	ETF	114.26	115.07	114.13	114.39	1662572.0
2024-09-04	ACWV	ETF	113.06	113.54	112.96	113.34	381835.0
2024-09-04	ACWX	ETF	54.46	54.94	54.44	54.67	305198.0
2024-09-04	ADFI	ETF	8.75	8.77	8.73	8.74	21390.0
2024-09-04	ADIV	ETF	14.97	15.0519	14.97	15.0519	1451.0
2024-09-04	ADME	ETF	44.87	44.96	44.65	44.7836	6003.0
2024-09-04	ADPV	ETF	31.5001	31.69	31.5001	31.69	694.0
2024-09-04	AEMB	ETF	39.4495	39.4495	39.4495	39.4495	335.0
2024-09-04	AESR	ETF	16.25	16.29	16.15	16.23	33222.0
2024-09-04	AETH	ETF	31.04	32.15	31.0335	31.6742	2555.0
2024-09-04	AFIF	ETF	9.16	9.21	9.16	9.195	15300.0
2024-09-04	AFK	ETF	15.6	15.7793	15.6	15.75	3733.0
2024-09-04	AFLG	ETF	32.54	32.561	32.43	32.5172	3863.0
2024-09-04	AFMC	ETF	30.535	30.65	30.535	30.5958	569.0
2024-09-04	AFSM	ETF	29.59	29.59	29.37	29.4422	5050.0
2024-09-04	AFTY	ETF	13.87	13.87	13.87	13.87	46.0
2024-09-04	AGG	ETF	100.43	100.85	100.4	100.8	10858732.0
2024-09-04	AGGH	ETF	21.78	22.06	21.5362	22.06	65885.0
2024-09-04	AGGS	ETF	42.28	42.3188	42.26	42.3188	340.0
2024-09-04	AGGY	ETF	44.42	44.6	44.42	44.59	77258.0
2024-09-04	AGIX	ETF	23.4363	23.4363	23.4363	23.4363	226.0
2024-09-04	AGMI	ETF	24.73	24.73	24.708	24.708	107.0
2024-09-04	AGNG	ETF	32.87	32.9	32.81	32.9	3153.0
2024-09-04	AGOX	ETF	27.82	27.87	27.42	27.71	41795.0
2024-09-04	AGQ	ETF	33.29	33.94	33.12	33.39	875089.0

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

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