PREVIEW / etf_daily / 2023-07-13

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-13.parquet
  size:    108 KB
  rows:    2,978

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-07-13	SPY	ETF	447.9	450.38	447.45	449.56	72425200.0
2023-07-13	QQQ	ETF	376.05	379.99	375.46	379.15	46960012.0
2023-07-13	IWM	ETF	192.51	193.69	191.8	193.42	23523000.0
2023-07-13	DIA	ETF	344.34	344.88	343.7	343.92	2472300.0
2023-07-13	GLD	ETF	181.96	182.15	181.49	182.01	4527900.0
2023-07-13	TLT	ETF	101.31	101.97	101.03	101.89	32441500.0
2023-07-13	AAA	ETF	24.59	24.66	24.59	24.62	1200.0
2023-07-13	AAAU	ETF	19.42	19.45	19.38	19.43	956100.0
2023-07-13	AADR	ETF	50.22	50.84	50.22	50.56	700.0
2023-07-13	AAPB	ETF	28.3354	28.49	28.1985	28.31	15925.0
2023-07-13	AAPD	ETF	20.44	20.51	20.39	20.47	77843.0
2023-07-13	AAPU	ETF	28.29	28.43	28.1486	28.28	113728.0
2023-07-13	AAXJ	ETF	68.85	69.37	68.73	69.23	1737000.0
2023-07-13	ABEQ	ETF	28.26	28.29	28.26	28.262	3000.0
2023-07-13	ACES	ETF	48.5	49.0	48.219	48.77	43400.0
2023-07-13	ACIO	ETF	31.228	31.365	31.19	31.32	69800.0
2023-07-13	ACSI	ETF	47.493	47.493	47.493	47.493	100.0
2023-07-13	ACT	ETF	26.61	26.81	26.45	26.47	110671.0
2023-07-13	ACTV	ETF	32.59	32.77	32.59	32.696	5400.0
2023-07-13	ACVF	ETF	34.25	34.43	34.16	34.345	7900.0
2023-07-13	ACWF	ETF	36.04	36.13	36.04	36.1256	2342.0
2023-07-13	ACWI	ETF	97.54	98.09	97.48	97.95	1997500.0
2023-07-13	ACWV	ETF	98.73	98.73	98.36	98.47	92200.0
2023-07-13	ACWX	ETF	50.48	50.79	50.47	50.74	1366200.0
2023-07-13	ADFI	ETF	8.51	8.52	8.51	8.515	8200.0
2023-07-13	ADIV	ETF	13.9	13.989	13.9	13.989	200.0
2023-07-13	ADME	ETF	36.6	36.71	36.55	36.66	16700.0
2023-07-13	ADPV	ETF	25.63	25.7268	25.63	25.7268	994.0
2023-07-13	AEMB	ETF	38.035	38.035	38.035	38.035	100.0
2023-07-13	AESR	ETF	12.92	12.99	12.91	12.99	15400.0
2023-07-13	AFIF	ETF	8.84	8.87	8.83	8.85	9700.0
2023-07-13	AFK	ETF	15.05	15.35	15.05	15.3	7300.0
2023-07-13	AFLG	ETF	25.77	25.808	25.77	25.808	200.0
2023-07-13	AFMC	ETF	25.53	25.56	25.53	25.544	1300.0
2023-07-13	AFTY	ETF	15.36	15.449	15.33	15.428	7800.0
2023-07-13	AGG	ETF	98.18	98.44	98.12	98.41	7458500.0
2023-07-13	AGGH	ETF	22.6107	24.98	22.6107	23.29	85163.0
2023-07-13	AGGY	ETF	43.27	43.4	43.26	43.37	338200.0
2023-07-13	AGNG	ETF	27.76	27.78	27.72	27.78	1700.0
2023-07-13	AGOV	ETF	77.19	77.19	76.0	76.845	911.0
2023-07-13	AGOX	ETF	24.06	24.06	23.86	23.9	18500.0
2023-07-13	AGQ	ETF	31.13	31.92	30.94	31.92	899700.0
2023-07-13	AGZ	ETF	107.14	107.34	107.12	107.32	28700.0
2023-07-13	AGZD	ETF	22.125	22.16	22.09	22.095	20600.0
2023-07-13	AHYB	ETF	44.3	44.4	44.26	44.4	800.0
2023-07-13	AIA	ETF	61.76	62.71	61.76	62.69	62700.0
2023-07-13	AIEQ	ETF	32.23	32.35	32.04	32.256	12500.0
2023-07-13	AIQ	ETF	28.91	29.23	28.85	29.19	631900.0
2023-07-13	AIRR	ETF	54.16	54.5	53.99	54.42	77500.0
2023-07-13	AIVI	ETF	40.08	40.23	40.08	40.2	2000.0

> showing 50 of 2,978 rows — these rows as CSV

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