PREVIEW / etf_daily / 2021-05-20

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-20.parquet
  size:    88 KB
  rows:    2,340

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-20	SPY	ETF	411.8	416.63	411.67	415.28	78022200.0
2021-05-20	QQQ	ETF	324.12	329.71	323.89	328.83	46466135.0
2021-05-20	IWM	ETF	218.27	219.87	216.33	219.4	24932800.0
2021-05-20	DIA	ETF	339.74	342.94	339.34	341.52	4532800.0
2021-05-20	GLD	ETF	175.32	176.46	175.11	175.96	9802800.0
2021-05-20	TLT	ETF	136.76	137.49	136.67	137.23	13310500.0
2021-05-20	AAA	ETF	25.0	25.015	25.0	25.015	1387.0
2021-05-20	AAAU	ETF	18.64	18.75	18.61	18.69	604000.0
2021-05-20	AADR	ETF	64.1	64.72	64.1	64.72	600.0
2021-05-20	AAXJ	ETF	91.99	92.48	91.94	92.39	415800.0
2021-05-20	ABEQ	ETF	28.29	28.32	28.276	28.276	300.0
2021-05-20	ACES	ETF	66.46	67.45	66.46	67.15	39200.0
2021-05-20	ACIO	ETF	29.48	29.74	29.48	29.644	18700.0
2021-05-20	ACSI	ETF	48.7	48.7619	48.7	48.7619	421.0
2021-05-20	ACTV	ETF	37.83	38.1	37.83	37.9794	5782.0
2021-05-20	ACTX	ETF	4.25	4.55	4.25	4.49	1076.0
2021-05-20	ACVF	ETF	30.95	31.09	30.81	30.94	9100.0
2021-05-20	ACWF	ETF	37.64	37.9	37.605	37.8139	5422.0
2021-05-20	ACWI	ETF	98.57	99.56	98.53	99.33	1548000.0
2021-05-20	ACWV	ETF	102.05	103.25	102.05	102.94	152600.0
2021-05-20	ACWX	ETF	57.18	57.605	57.17	57.56	2123695.0
2021-05-20	ADFI	ETF	9.65	9.7	9.65	9.67	15100.0
2021-05-20	ADIV	ETF	18.53	18.53	18.522	18.522	100.0
2021-05-20	ADME	ETF	38.32	38.64	38.32	38.52	13400.0
2021-05-20	ADRE	ETF	55.39	55.83	55.33	55.83	12798.0
2021-05-20	AESR	ETF	13.09	13.17	13.09	13.14	25400.0
2021-05-20	AFIF	ETF	9.7151	9.74	9.7	9.725	16787.0
2021-05-20	AFK	ETF	21.93	22.27	21.87	22.0	4622.0
2021-05-20	AFLG	ETF	24.86	24.874	24.86	24.874	200.0
2021-05-20	AFMC	ETF	25.014	25.014	25.014	25.014	600.0
2021-05-20	AFSM	ETF	25.41	25.505	25.41	25.505	200.0
2021-05-20	AFTY	ETF	23.45	23.455	23.44	23.454	1200.0
2021-05-20	AGG	ETF	114.08	114.3	114.08	114.29	6243300.0
2021-05-20	AGGY	ETF	51.53	51.63	51.505	51.63	207300.0
2021-05-20	AGNG	ETF	29.13	29.2	29.107	29.107	1200.0
2021-05-20	AGOX	ETF	24.8	25.259	24.8	25.195	10400.0
2021-05-20	AGQ	ETF	52.81	53.62	52.28	52.81	627100.0
2021-05-20	AGZ	ETF	118.02	118.2	118.02	118.2	36254.0
2021-05-20	AGZD	ETF	23.47	23.525	23.47	23.515	38600.0
2021-05-20	AIA	ETF	89.27	89.94	89.27	89.71	51132.0
2021-05-20	AIEQ	ETF	36.33	36.614	36.13	36.44	10900.0
2021-05-20	AIQ	ETF	27.94	28.4087	27.94	28.35	32015.0
2021-05-20	AIRR	ETF	40.53	40.85	40.33	40.69	167300.0
2021-05-20	AIVI	ETF	44.08	44.19	44.07	44.19	1400.0
2021-05-20	ALTL	ETF	41.18	41.585	41.18	41.43	13405.0
2021-05-20	ALTY	ETF	13.332	13.41	13.332	13.41	4500.0
2021-05-20	AMJ	ETF	18.79	19.12	18.62	19.12	225344.0
2021-05-20	AMLP	ETF	34.13	34.58	33.69	34.5	1814100.0
2021-05-20	AMNA	ETF	33.1424	33.1424	33.1424	33.1424	0.0
2021-05-20	AMND	ETF	35.1598	35.1598	35.1598	35.1598	5.0

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

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