PREVIEW / etf_daily / 2024-09-20

all etf daily files

  file:    by_date/etf_daily/2024/2024-09-20.parquet
  size:    135 KB
  rows:    3,520

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-20	SPY	ETF	567.84	569.31	565.17	568.25	81706110.0
2024-09-20	QQQ	ETF	482.49	483.69	478.3	482.44	34577663.0
2024-09-20	IWM	ETF	223.45	223.46	221.29	221.57	34548119.0
2024-09-20	DIA	ETF	419.38	421.2988	418.5	420.57	2896753.0
2024-09-20	GLD	ETF	241.11	242.625	240.47	242.21	7872705.0
2024-09-20	TLT	ETF	98.99	99.245	98.72	98.88	36781668.0
2024-09-20	AAA	ETF	25.09	25.1239	25.03	25.0635	7250.0
2024-09-20	AAAU	ETF	25.8	25.975	25.745	25.925	2186290.0
2024-09-20	AADR	ETF	63.87	63.87	63.87	63.87	59.0
2024-09-20	AAPB	ETF	29.33	30.02	28.69	28.93	96696.0
2024-09-20	AAPD	ETF	16.79	16.95	16.57	16.89	666963.0
2024-09-20	AAPR	ETF	26.12	26.17	26.12	26.1428	7758.0
2024-09-20	AAPU	ETF	37.46	38.43	36.7	36.96	980081.0
2024-09-20	AAPX	ETF	33.89	34.61	33.575	33.575	16932.0
2024-09-20	AAPY	ETF	28.01	28.01	27.7149	27.7149	930.0
2024-09-20	AAXJ	ETF	73.97	74.115	73.68	74.0	697655.0
2024-09-20	ABCS	ETF	28.22	28.26	28.2001	28.2197	2800.0
2024-09-20	ABEQ	ETF	32.65	32.65	32.54	32.6005	5508.0
2024-09-20	ABNY	ETF	82.6	83.4	82.35	83.3425	1346.0
2024-09-20	ACES	ETF	28.94	28.94	28.4	28.64	179696.0
2024-09-20	ACIO	ETF	39.56	39.59	39.33	39.5	215592.0
2024-09-20	ACSI	ETF	57.4715	57.4715	57.4715	57.4715	22.0
2024-09-20	ACT	ETF	36.86	36.885	36.19	36.28	563422.0
2024-09-20	ACTV	ETF	33.3	33.5642	33.3	33.4	2383.0
2024-09-20	ACVF	ETF	43.19	43.21	43.12	43.19	3333.0
2024-09-20	ACWI	ETF	117.85	118.0	117.28	117.76	2584020.0
2024-09-20	ACWV	ETF	113.64	113.82	113.3	113.72	113462.0
2024-09-20	ACWX	ETF	55.96	55.96	55.58	55.73	287123.0
2024-09-20	ADFI	ETF	8.79	8.82	8.78	8.81	14768.0
2024-09-20	ADIV	ETF	15.52	15.52	15.435	15.4476	548.0
2024-09-20	ADME	ETF	45.83	45.91	45.7501	45.8446	4111.0
2024-09-20	ADPV	ETF	32.1	32.1	31.95	31.9544	2092.0
2024-09-20	AEMB	ETF	39.14	39.295	39.14	39.2763	53441.0
2024-09-20	AESR	ETF	16.71	16.82	16.71	16.81	20312.0
2024-09-20	AETH	ETF	32.6383	33.17	32.6383	32.7926	3531.0
2024-09-20	AFIF	ETF	9.2199	9.2199	9.18	9.205	22525.0
2024-09-20	AFK	ETF	16.73	16.73	16.4601	16.5955	4623.0
2024-09-20	AFLG	ETF	33.72	33.76	33.57	33.7	5193.0
2024-09-20	AFMC	ETF	31.855	31.87	31.72	31.855	742.0
2024-09-20	AFSM	ETF	30.86	30.88	30.6759	30.6759	2469.0
2024-09-20	AFTY	ETF	13.63	13.67	13.63	13.655	2710.0
2024-09-20	AGG	ETF	101.43	101.65	101.315	101.48	8390422.0
2024-09-20	AGGH	ETF	21.89	21.89	21.78	21.81	89799.0
2024-09-20	AGGS	ETF	42.63	42.63	42.6138	42.6138	102.0
2024-09-20	AGGY	ETF	44.96	45.05	44.9141	45.04	56018.0
2024-09-20	AGIX	ETF	25.0745	25.0745	25.0745	25.0745	168.0
2024-09-20	AGMI	ETF	28.31	28.39	28.31	28.39	1182.0
2024-09-20	AGNG	ETF	32.97	32.98	32.84	32.88	5354.0
2024-09-20	AGOX	ETF	29.07	29.07	28.65	29.07	13693.0
2024-09-20	AGQ	ETF	40.56	41.11	39.97	40.62	1834913.0

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

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