PREVIEW / etf_daily / 2021-01-27

all etf daily files

  file:    by_date/etf_daily/2021/2021-01-27.parquet
  size:    84 KB
  rows:    2,246

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-01-27	SPY	ETF	380.22	380.32	372.01	374.41	123351100.0
2021-01-27	QQQ	ETF	326.26	326.27	317.36	319.43	55263985.0
2021-01-27	IWM	ETF	209.5	212.99	207.29	209.39	45830300.0
2021-01-27	DIA	ETF	306.54	306.72	302.1	303.26	5743100.0
2021-01-27	GLD	ETF	172.93	173.52	171.66	172.52	9036500.0
2021-01-27	TLT	ETF	154.07	154.5	153.53	153.77	7895200.0
2021-01-27	AAA	ETF	25.14	25.15	25.14	25.15	491.0
2021-01-27	AAAU	ETF	18.37	18.41	18.24	18.34	569600.0
2021-01-27	AADR	ETF	61.22	61.22	59.91	59.91	6600.0
2021-01-27	AAXJ	ETF	96.09	96.48	95.3	95.32	953300.0
2021-01-27	ABEQ	ETF	25.41	25.45	25.28	25.333	1900.0
2021-01-27	ACES	ETF	94.56	96.21	91.93	93.05	242200.0
2021-01-27	ACIO	ETF	27.73	27.77	27.21	27.23	8600.0
2021-01-27	ACSI	ETF	44.38	44.38	43.24	43.24	600.0
2021-01-27	ACTV	ETF	32.68	33.185	32.68	33.11	4789.0
2021-01-27	ACTX	ETF	4.9	4.9	4.2	4.5	885.0
2021-01-27	ACVF	ETF	28.0	28.03	27.58	27.697	2500.0
2021-01-27	ACWF	ETF	34.56	34.6784	34.29	34.3212	4324.0
2021-01-27	ACWI	ETF	92.57	92.64	91.14	91.48	5122000.0
2021-01-27	ACWV	ETF	97.36	97.51	96.29	96.5	939100.0
2021-01-27	ACWX	ETF	54.36	54.57	53.92	54.07	1644802.0
2021-01-27	ADFI	ETF	9.911	9.911	9.911	9.911	4000.0
2021-01-27	ADME	ETF	36.15	36.15	35.81	35.81	8500.0
2021-01-27	ADRE	ETF	61.0	61.0	59.86	59.9386	31296.0
2021-01-27	AESR	ETF	12.012	12.012	11.846	11.846	7000.0
2021-01-27	AFIF	ETF	9.765	9.7797	9.74	9.74	15048.0
2021-01-27	AFK	ETF	21.26	21.26	21.0	21.0	10558.0
2021-01-27	AFLG	ETF	22.6	22.623	22.6	22.623	800.0
2021-01-27	AFMC	ETF	22.54	22.54	22.246	22.246	600.0
2021-01-27	AFSM	ETF	23.667	23.667	23.667	23.667	800.0
2021-01-27	AFTY	ETF	24.33	24.33	24.16	24.197	14000.0
2021-01-27	AGG	ETF	117.61	117.67	117.04	117.52	3619100.0
2021-01-27	AGGY	ETF	53.34	53.393	53.3	53.31	89700.0
2021-01-27	AGNG	ETF	29.18	29.18	28.44	28.44	13400.0
2021-01-27	AGQ	ETF	45.21	46.35	43.6	45.55	929500.0
2021-01-27	AGZ	ETF	119.56	119.636	119.5537	119.6	27214.0
2021-01-27	AGZD	ETF	23.615	23.62	23.53	23.56	80800.0
2021-01-27	AIA	ETF	96.1	96.2	95.16	95.29	326711.0
2021-01-27	AIEQ	ETF	39.13	39.42	38.18	38.55	170400.0
2021-01-27	AIQ	ETF	28.13	28.265	27.71	27.775	171868.0
2021-01-27	AIRR	ETF	35.77	35.77	34.889	35.311	15700.0
2021-01-27	AIVI	ETF	41.5	41.88	41.46	41.51	5100.0
2021-01-27	ALTL	ETF	32.465	32.476	31.87	31.8733	4220.0
2021-01-27	ALTY	ETF	12.0	12.0	11.82	11.84	20400.0
2021-01-27	AMJ	ETF	14.73	14.95	14.47	14.5	702355.0
2021-01-27	AMLP	ETF	27.2	27.55	26.63	26.73	3998900.0
2021-01-27	AMNA	ETF	26.0806	26.0806	26.0806	26.0806	11.0
2021-01-27	AMND	ETF	27.7162	27.7162	27.7162	27.7162	0.0
2021-01-27	AMOM	ETF	32.21	32.401	31.983	31.983	1300.0
2021-01-27	AMTR	ETF	29.9637	29.9637	29.9637	29.9637	0.0

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

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