PREVIEW / etf_daily / 2024-09-09

all etf daily files

  file:    by_date/etf_daily/2024/2024-09-09.parquet
  size:    134 KB
  rows:    3,491

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-09	SPY	ETF	544.65	547.71	542.68	546.41	40244636.0
2024-09-09	QQQ	ETF	453.06	455.46	449.8234	454.46	32981169.0
2024-09-09	IWM	ETF	208.15	210.255	207.52	208.48	23261885.0
2024-09-09	DIA	ETF	407.36	410.89	406.11	409.05	3013571.0
2024-09-09	GLD	ETF	231.26	231.62	230.39	231.6	3493461.0
2024-09-09	TLT	ETF	99.4	100.1	99.16	99.99	26935721.0
2024-09-09	AAA	ETF	25.04	25.08	25.04	25.05	3378.0
2024-09-09	AAAU	ETF	24.76	24.7901	24.665	24.79	1003016.0
2024-09-09	AADR	ETF	61.445	61.445	61.22	61.22	272.0
2024-09-09	AAPB	ETF	27.16	27.21	26.25	27.21	155375.0
2024-09-09	AAPD	ETF	17.47	17.7916	17.4499	17.48	860757.0
2024-09-09	AAPR	ETF	25.7	25.75	25.7	25.7389	3009.0
2024-09-09	AAPU	ETF	34.78	34.825	33.4725	34.79	919840.0
2024-09-09	AAPX	ETF	31.46	31.485	30.4	31.46	38017.0
2024-09-09	AAPY	ETF	26.4	26.6637	26.39	26.6637	1146.0
2024-09-09	AAXJ	ETF	70.74	71.195	70.71	71.04	434099.0
2024-09-09	ABCS	ETF	27.0716	27.27	27.0716	27.09	1653.0
2024-09-09	ABEQ	ETF	32.41	32.4714	32.3401	32.3479	3025.0
2024-09-09	ABNY	ETF	79.2	79.2	77.95	78.704	1872.0
2024-09-09	ACES	ETF	27.01	27.05	26.45	26.45	189120.0
2024-09-09	ACIO	ETF	38.36	38.47	38.2374	38.46	59859.0
2024-09-09	ACSI	ETF	56.2275	56.2275	56.2275	56.2275	66.0
2024-09-09	ACT	ETF	35.6	35.95	35.48	35.7	234840.0
2024-09-09	ACTV	ETF	32.0	32.049	31.77	31.79	6616.0
2024-09-09	ACVF	ETF	41.54	41.726	41.54	41.72	5591.0
2024-09-09	ACWI	ETF	113.24	113.79	112.89	113.47	1099783.0
2024-09-09	ACWV	ETF	112.2	112.84	111.92	112.55	120665.0
2024-09-09	ACWX	ETF	54.1	54.405	54.0733	54.24	373605.0
2024-09-09	ADFI	ETF	8.8	8.81	8.77	8.8	8570.0
2024-09-09	ADIV	ETF	14.83	14.9031	14.83	14.9031	1121.0
2024-09-09	ADME	ETF	44.3	44.38	44.095	44.38	8926.0
2024-09-09	ADPV	ETF	31.16	31.36	31.16	31.2215	5631.0
2024-09-09	AEMB	ETF	39.5122	39.5122	39.5122	39.5122	56.0
2024-09-09	AESR	ETF	15.93	16.01	15.9	16.0059	19548.0
2024-09-09	AETH	ETF	29.9	30.3461	29.8658	30.3461	2765.0
2024-09-09	AFIF	ETF	9.23	9.24	9.2	9.23	15226.0
2024-09-09	AFK	ETF	15.75	15.81	15.52	15.52	4712.0
2024-09-09	AFLG	ETF	32.16	32.33	32.12	32.1982	3785.0
2024-09-09	AFMC	ETF	30.1116	30.1116	30.03	30.0551	677.0
2024-09-09	AFSM	ETF	28.77	28.79	28.7371	28.7371	1521.0
2024-09-09	AFTY	ETF	13.6172	13.6172	13.6172	13.6172	13.0
2024-09-09	AGG	ETF	101.15	101.429	101.05	101.34	7544518.0
2024-09-09	AGGH	ETF	21.63	21.78	21.62	21.745	114403.0
2024-09-09	AGGS	ETF	42.56	42.56	42.5313	42.5313	143.0
2024-09-09	AGGY	ETF	44.76	44.87	44.76	44.8407	94758.0
2024-09-09	AGIX	ETF	23.16	23.2206	23.06	23.2206	1197.0
2024-09-09	AGMI	ETF	24.17	24.2313	24.17	24.2313	102.0
2024-09-09	AGNG	ETF	32.6	32.6	32.39	32.52	1020.0
2024-09-09	AGOX	ETF	27.05	27.51	27.05	27.35	54356.0
2024-09-09	AGQ	ETF	33.44	33.9	33.15	33.8	1088192.0

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

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