PREVIEW / etf_daily / 2022-07-14

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-14.parquet
  size:    102 KB
  rows:    2,754

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
2022-07-14	SPY	ETF	373.61	379.05	371.04	377.91	89704800.0
2022-07-14	QQQ	ETF	282.99	287.56	279.8	286.67	63741837.0
2022-07-14	IWM	ETF	168.68	170.0	167.02	169.56	25102200.0
2022-07-14	DIA	ETF	302.66	306.86	301.47	306.4	2893100.0
2022-07-14	GLD	ETF	159.02	159.83	158.22	159.33	12213600.0
2022-07-14	TLT	ETF	115.08	116.16	114.47	115.49	15665000.0
2022-07-14	AAA	ETF	24.265	24.265	24.265	24.265	5.0
2022-07-14	AAAU	ETF	16.95	17.02	16.86	16.97	1502300.0
2022-07-14	AADR	ETF	46.05	46.18	46.05	46.18	500.0
2022-07-14	AAXJ	ETF	66.46	66.61	65.93	66.53	1280000.0
2022-07-14	ABEQ	ETF	26.37	26.37	26.135	26.34	2300.0
2022-07-14	ACES	ETF	48.6	49.52	47.81	49.5	68100.0
2022-07-14	ACIO	ETF	28.412	28.75	28.412	28.75	36000.0
2022-07-14	ACSI	ETF	42.5047	42.5047	42.5047	42.5047	31.0
2022-07-14	ACT	ETF	21.57	21.95	21.195	21.34	129628.0
2022-07-14	ACTV	ETF	29.86	30.09	29.7	30.0571	9337.0
2022-07-14	ACTX	ETF	0.65	0.65	0.6404	0.65	2917.0
2022-07-14	ACVF	ETF	28.07	28.55	28.07	28.55	4200.0
2022-07-14	ACWF	ETF	30.42	30.6002	30.15	30.6002	4291.0
2022-07-14	ACWI	ETF	82.01	82.9	81.47	82.81	2258200.0
2022-07-14	ACWV	ETF	93.47	94.12	93.07	94.01	110200.0
2022-07-14	ACWX	ETF	43.12	43.36	42.755	43.31	2901317.0
2022-07-14	ADFI	ETF	8.495	8.508	8.495	8.508	2700.0
2022-07-14	ADIV	ETF	13.47	13.47	13.42	13.42	200.0
2022-07-14	ADME	ETF	33.93	34.36	33.93	34.36	30800.0
2022-07-14	ADRE	ETF	37.5187	37.735	37.29	37.7	2106.0
2022-07-14	AEMB	ETF	36.32	36.337	36.32	36.337	20500.0
2022-07-14	AESR	ETF	10.89	11.07	10.85	11.04	8200.0
2022-07-14	AFIF	ETF	8.8092	8.86	8.8	8.84	28793.0
2022-07-14	AFK	ETF	16.76	16.76	16.31	16.3862	4076.0
2022-07-14	AFLG	ETF	22.404	22.575	22.4	22.575	600.0
2022-07-14	AFMC	ETF	20.695	20.95	20.695	20.95	400.0
2022-07-14	AFSM	ETF	21.446	21.777	21.446	21.777	400.0
2022-07-14	AFTY	ETF	18.05	18.089	17.92	18.089	1200.0
2022-07-14	AGG	ETF	101.51	101.98	101.33	101.85	6233300.0
2022-07-14	AGGH	ETF	23.6701	23.7168	23.67	23.7168	3077.0
2022-07-14	AGGY	ETF	44.77	44.983	44.72	44.89	102800.0
2022-07-14	AGNG	ETF	25.285	25.39	25.285	25.379	500.0
2022-07-14	AGOV	ETF	79.1	79.7326	79.1	79.7326	106.0
2022-07-14	AGOX	ETF	19.73	19.98	19.6	19.86	28100.0
2022-07-14	AGQ	ETF	19.77	20.14	19.31	20.0	1777100.0
2022-07-14	AGZ	ETF	109.56	109.8863	109.5	109.86	15772.0
2022-07-14	AGZD	ETF	22.895	22.925	22.835	22.92	46600.0
2022-07-14	AHHX	ETF	8.4	8.4512	8.39	8.4512	2130.0
2022-07-14	AHYB	ETF	43.101	43.101	43.101	43.101	100.0
2022-07-14	AIA	ETF	59.93	59.93	59.45	59.77	44763.0
2022-07-14	AIEQ	ETF	30.66	30.8	30.56	30.705	4900.0
2022-07-14	AIQ	ETF	20.59	20.69	20.3215	20.65	10844.0
2022-07-14	AIRR	ETF	36.65	37.085	36.325	37.085	7800.0
2022-07-14	AIVI	ETF	33.82	33.87	33.41	33.84	5400.0

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

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