PREVIEW / etf_daily / 2021-02-08

all etf daily files

  file:    by_date/etf_daily/2021/2021-02-08.parquet
  size:    86 KB
  rows:    2,269

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-02-08	SPY	ETF	389.27	390.56	388.35	390.51	38365200.0
2021-02-08	QQQ	ETF	333.1	333.74	331.41	333.58	20462812.0
2021-02-08	IWM	ETF	223.79	227.33	223.4	227.31	20831500.0
2021-02-08	DIA	ETF	312.7	313.89	312.41	313.89	1690000.0
2021-02-08	GLD	ETF	171.98	172.4	171.49	171.52	6887500.0
2021-02-08	TLT	ETF	148.3	149.26	148.04	148.68	11574800.0
2021-02-08	AAA	ETF	25.1457	25.1498	25.14	25.14	2603.0
2021-02-08	AAAU	ETF	18.27	18.3	18.22	18.23	773900.0
2021-02-08	AADR	ETF	65.02	65.8	65.02	65.8	8000.0
2021-02-08	AAXJ	ETF	98.5	99.02	98.39	99.02	1502600.0
2021-02-08	ABEQ	ETF	26.6	27.33	25.97	26.13	1400.0
2021-02-08	ACES	ETF	98.91	99.98	98.34	99.74	171000.0
2021-02-08	ACIO	ETF	27.904	27.94	27.85	27.91	33600.0
2021-02-08	ACSI	ETF	45.04	45.2405	45.04	45.2405	7909.0
2021-02-08	ACTV	ETF	34.5323	35.1909	34.4552	35.1909	4012.0
2021-02-08	ACTX	ETF	4.65	4.65	4.35	4.4	1646.0
2021-02-08	ACVF	ETF	28.95	28.95	28.822	28.907	2000.0
2021-02-08	ACWF	ETF	35.28	35.449	35.27	35.4165	100435.0
2021-02-08	ACWI	ETF	94.95	95.2	94.76	95.2	4352900.0
2021-02-08	ACWV	ETF	97.44	97.67	97.34	97.55	295900.0
2021-02-08	ACWX	ETF	55.64	55.765	55.51	55.67	453231.0
2021-02-08	ADFI	ETF	9.88	9.88	9.88	9.88	100.0
2021-02-08	ADME	ETF	37.02	37.02	36.63	36.74	51200.0
2021-02-08	ADRE	ETF	63.32	64.41	63.32	63.6799	29475.0
2021-02-08	AESR	ETF	12.37	12.37	12.37	12.37	100.0
2021-02-08	AFIF	ETF	9.77	9.7899	9.7565	9.765	16647.0
2021-02-08	AFK	ETF	21.34	21.545	21.03	21.39	59250.0
2021-02-08	AFLG	ETF	23.4	23.428	23.38	23.428	1100.0
2021-02-08	AFMC	ETF	23.423	23.423	23.423	23.423	100.0
2021-02-08	AFSM	ETF	25.58	25.65	25.58	25.65	400.0
2021-02-08	AFTY	ETF	25.58	25.588	25.54	25.588	2700.0
2021-02-08	AGG	ETF	116.75	116.93	116.72	116.83	4704200.0
2021-02-08	AGGY	ETF	52.98	53.1	52.96	53.06	175200.0
2021-02-08	AGNG	ETF	29.31	29.33	29.14	29.185	11700.0
2021-02-08	AGQ	ETF	52.97	53.42	52.31	52.43	1608500.0
2021-02-08	AGZ	ETF	119.16	119.3148	119.16	119.27	46222.0
2021-02-08	AGZD	ETF	23.695	23.7	23.645	23.665	27400.0
2021-02-08	AIA	ETF	98.04	98.9	98.01	98.9	194212.0
2021-02-08	AIEQ	ETF	41.0	41.56	41.0	41.54	78400.0
2021-02-08	AIQ	ETF	29.7	29.79	29.58	29.79	61155.0
2021-02-08	AIRR	ETF	37.31	37.933	37.31	37.883	14900.0
2021-02-08	AIVI	ETF	41.92	41.94	41.77	41.79	13300.0
2021-02-08	ALTL	ETF	35.02	35.37	34.9642	35.37	8703.0
2021-02-08	ALTY	ETF	12.22	12.25	12.22	12.225	16800.0
2021-02-08	AMJ	ETF	15.5	15.54	15.33	15.5	784116.0
2021-02-08	AMLP	ETF	28.39	28.69	28.3	28.66	2945200.0
2021-02-08	AMNA	ETF	27.6709	27.6709	27.6709	27.6709	8.0
2021-02-08	AMND	ETF	29.3405	29.3405	29.3405	29.3405	0.0
2021-02-08	AMOM	ETF	33.88	34.24	33.88	34.112	3700.0
2021-02-08	AMPS	ETF	10.48	10.79	10.44	10.67	118373.0

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

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