PREVIEW / etf_daily / 2023-09-19

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-19.parquet
  size:    108 KB
  rows:    3,015

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
2023-09-19	SPY	ETF	442.68	443.29	439.94	442.71	66514600.0
2023-09-19	QQQ	ETF	369.32	370.6826	366.8	369.87	37621734.0
2023-09-19	IWM	ETF	182.49	183.3	181.07	181.68	24085900.0
2023-09-19	DIA	ETF	345.47	345.81	342.98	345.07	2740900.0
2023-09-19	GLD	ETF	179.54	179.65	179.03	179.22	4224700.0
2023-09-19	TLT	ETF	93.08	93.43	92.8	92.8	24941800.0
2023-09-19	AAA	ETF	24.85	24.87	24.85	24.85	1500.0
2023-09-19	AAAU	ETF	19.17	19.18	19.12	19.14	1343100.0
2023-09-19	AADR	ETF	50.36	50.43	50.01	50.37	4700.0
2023-09-19	AAPB	ETF	24.53	24.9504	24.41	24.86	16244.0
2023-09-19	AAPD	ETF	21.81	21.898	21.6	21.64	246209.0
2023-09-19	AAPU	ETF	24.96	25.36	24.86	25.28	187954.0
2023-09-19	AAXJ	ETF	64.99	65.2	64.83	64.92	171700.0
2023-09-19	ABEQ	ETF	28.33	28.33	28.243	28.28	8200.0
2023-09-19	ACES	ETF	40.2	40.29	39.978	40.024	27400.0
2023-09-19	ACIO	ETF	31.255	31.27	31.1	31.21	37800.0
2023-09-19	ACSI	ETF	45.82	45.82	45.82	45.82	100.0
2023-09-19	ACT	ETF	28.21	28.59	27.96	28.16	92848.0
2023-09-19	ACTV	ETF	31.3	31.46	31.17	31.247	88200.0
2023-09-19	ACVF	ETF	34.14	34.206	34.03	34.206	2100.0
2023-09-19	ACWF	ETF	35.42	35.45	35.23	35.3881	8157.0
2023-09-19	ACWI	ETF	95.57	95.72	95.06	95.51	1716600.0
2023-09-19	ACWV	ETF	97.89	98.15	97.81	98.02	1189900.0
2023-09-19	ACWX	ETF	48.59	48.65	48.39	48.5	372400.0
2023-09-19	ADFI	ETF	8.339	8.34	8.32	8.33	7500.0
2023-09-19	ADIV	ETF	13.57	13.579	13.57	13.579	800.0
2023-09-19	ADME	ETF	36.21	36.46	36.19	36.36	17100.0
2023-09-19	ADPV	ETF	24.62	24.62	24.5995	24.5995	120.0
2023-09-19	AEMB	ETF	36.62	36.64	36.62	36.64	600.0
2023-09-19	AESR	ETF	12.58	12.615	12.53	12.57	15000.0
2023-09-19	AFIF	ETF	8.91	8.94	8.9	8.92	12200.0
2023-09-19	AFK	ETF	14.64	14.64	14.6	14.61	1500.0
2023-09-19	AFMC	ETF	24.315	24.319	24.315	24.319	200.0
2023-09-19	AFTY	ETF	14.88	14.89	14.86	14.86	3000.0
2023-09-19	AGG	ETF	95.54	95.59	95.35	95.35	5327900.0
2023-09-19	AGGH	ETF	22.18	22.18	21.91	21.9203	7365.0
2023-09-19	AGGY	ETF	42.19	42.23	42.145	42.16	56900.0
2023-09-19	AGNG	ETF	26.755	26.84	26.731	26.84	900.0
2023-09-19	AGOV	ETF	73.96	73.965	73.51	73.965	1166.0
2023-09-19	AGOX	ETF	23.19	23.295	23.154	23.22	14600.0
2023-09-19	AGQ	ETF	27.37	27.42	26.84	27.1	504000.0
2023-09-19	AGZ	ETF	106.17	106.19	106.08	106.09	9300.0
2023-09-19	AGZD	ETF	22.29	22.34	22.25	22.31	8300.0
2023-09-19	AHLT	ETF	26.03	26.1957	26.02	26.1957	2748.0
2023-09-19	AHYB	ETF	43.88	43.88	43.844	43.844	300.0
2023-09-19	AIA	ETF	56.93	57.17	56.81	57.0	20300.0
2023-09-19	AIEQ	ETF	30.8	30.874	30.65	30.765	6700.0
2023-09-19	AIQ	ETF	27.81	27.85	27.6	27.8	268800.0
2023-09-19	AIRR	ETF	53.14	53.41	52.73	52.97	80300.0
2023-09-19	AIVI	ETF	39.21	39.26	39.11	39.19	3100.0

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

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