PREVIEW / etf_daily / 2021-05-13

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-13.parquet
  size:    89 KB
  rows:    2,346

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
2021-05-13	SPY	ETF	407.07	412.35	407.02	410.28	106394000.0
2021-05-13	QQQ	ETF	319.92	322.4	316.9	319.34	69877765.0
2021-05-13	IWM	ETF	213.31	217.44	211.8	215.75	37739900.0
2021-05-13	DIA	ETF	336.3	342.04	336.27	340.45	5741300.0
2021-05-13	GLD	ETF	170.35	171.27	170.23	171.13	8078300.0
2021-05-13	TLT	ETF	135.93	136.37	135.63	135.81	13073900.0
2021-05-13	AAA	ETF	25.02	25.2	25.005	25.005	430.0
2021-05-13	AAAU	ETF	18.11	18.19	18.09	18.19	216800.0
2021-05-13	AADR	ETF	63.64	63.85	62.41	63.02	1900.0
2021-05-13	AAXJ	ETF	89.65	90.04	88.82	89.29	2134400.0
2021-05-13	ABEQ	ETF	27.92	28.05	27.9	28.04	3600.0
2021-05-13	ACES	ETF	62.26	63.424	61.05	61.9	72900.0
2021-05-13	ACIO	ETF	28.78	29.4	28.48	29.282	16300.0
2021-05-13	ACSI	ETF	48.2896	48.2896	48.2896	48.2896	365.0
2021-05-13	ACTV	ETF	36.98	37.53	36.98	37.3402	7089.0
2021-05-13	ACTX	ETF	3.27	3.5	3.27	3.5	593.0
2021-05-13	ACVF	ETF	30.71	30.71	30.48	30.645	6200.0
2021-05-13	ACWF	ETF	37.17	37.248	36.961	37.1611	4184.0
2021-05-13	ACWI	ETF	97.01	97.92	96.93	97.54	5864100.0
2021-05-13	ACWV	ETF	100.77	101.91	100.65	101.77	387300.0
2021-05-13	ACWX	ETF	55.9	56.19	55.71	56.08	2838587.0
2021-05-13	ADFI	ETF	9.65	9.67	9.645	9.645	3900.0
2021-05-13	ADIV	ETF	18.09	18.11	18.09	18.11	500.0
2021-05-13	ADME	ETF	37.53	38.17	37.53	38.045	11100.0
2021-05-13	ADRE	ETF	54.02	54.28	52.715	53.1943	10649.0
2021-05-13	AESR	ETF	12.92	13.04	12.92	13.001	14200.0
2021-05-13	AFIF	ETF	9.74	9.74	9.72	9.73	8677.0
2021-05-13	AFK	ETF	21.95	21.95	21.26	21.34	37830.0
2021-05-13	AFLG	ETF	24.56	24.703	24.56	24.703	900.0
2021-05-13	AFMC	ETF	24.993	24.993	24.993	24.993	100.0
2021-05-13	AFSM	ETF	25.1	25.1	25.1	25.1	800.0
2021-05-13	AFTY	ETF	22.435	22.45	22.38	22.385	1500.0
2021-05-13	AGG	ETF	113.9	114.06	113.78	114.04	6772300.0
2021-05-13	AGGY	ETF	51.37	51.48	51.37	51.44	112300.0
2021-05-13	AGNG	ETF	28.11	28.3	28.0	28.18	4800.0
2021-05-13	AGOX	ETF	24.38	24.91	24.38	24.789	29300.0
2021-05-13	AGQ	ETF	49.47	50.42	49.29	50.29	808600.0
2021-05-13	AGZ	ETF	117.85	117.9664	117.85	117.93	35947.0
2021-05-13	AGZD	ETF	23.485	23.625	23.485	23.505	31600.0
2021-05-13	AIA	ETF	87.0	87.48	86.03	86.44	307578.0
2021-05-13	AIEQ	ETF	35.46	35.89	34.979	35.38	17600.0
2021-05-13	AIQ	ETF	27.37	27.579	27.04	27.2327	34887.0
2021-05-13	AIRR	ETF	40.28	41.39	40.242	41.29	52300.0
2021-05-13	AIVI	ETF	43.72	43.9	43.52	43.84	2500.0
2021-05-13	ALTL	ETF	40.93	41.475	40.93	41.3571	148958.0
2021-05-13	ALTY	ETF	12.95	13.2	12.95	13.159	14900.0
2021-05-13	AMJ	ETF	18.44	18.87	18.367	18.73	464932.0
2021-05-13	AMLP	ETF	33.35	34.21	33.2	34.04	3377800.0
2021-05-13	AMNA	ETF	32.4526	32.4526	32.4526	32.4526	0.0
2021-05-13	AMND	ETF	34.4911	34.4911	34.4911	34.4911	5.0

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

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