PREVIEW / etf_daily / 2020-12-30

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-30.parquet
  size:    83 KB
  rows:    2,193

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
2020-12-30	SPY	ETF	372.34	373.1	371.57	371.99	49455300.0
2020-12-30	QQQ	ETF	314.16	314.49	312.33	312.97	18138071.0
2020-12-30	IWM	ETF	195.05	197.48	195.03	196.41	20595700.0
2020-12-30	DIA	ETF	304.11	305.13	303.86	304.13	2081300.0
2020-12-30	GLD	ETF	176.44	177.72	176.44	177.7	5914000.0
2020-12-30	TLT	ETF	156.82	157.53	156.68	157.5	9097300.0
2020-12-30	AAA	ETF	25.06	25.074	25.06	25.07	2492.0
2020-12-30	AAAU	ETF	18.74	18.87	18.73	18.87	400200.0
2020-12-30	AADR	ETF	61.59	61.69	61.36	61.46	7100.0
2020-12-30	AAXJ	ETF	89.5	89.94	89.34	89.7	790800.0
2020-12-30	ABEQ	ETF	25.44	25.45	25.42	25.45	3300.0
2020-12-30	ACES	ETF	78.04	79.98	78.04	79.85	96900.0
2020-12-30	ACIO	ETF	27.715	27.715	27.62	27.67	16300.0
2020-12-30	ACSI	ETF	43.23	43.23	43.1657	43.1657	260.0
2020-12-30	ACTV	ETF	31.37	31.3857	31.2	31.2872	2734.0
2020-12-30	ACTX	ETF	2.1	2.7	2.1	2.6	1355.0
2020-12-30	ACVF	ETF	28.0	28.0	27.7	27.7	2000.0
2020-12-30	ACWF	ETF	33.64	33.64	33.5	33.5	12096.0
2020-12-30	ACWI	ETF	90.8	90.99	90.64	90.66	946400.0
2020-12-30	ACWV	ETF	96.62	96.89	96.5	96.54	294300.0
2020-12-30	ACWX	ETF	53.45	53.58	53.3	53.3	766325.0
2020-12-30	ADFI	ETF	9.98	9.98	9.98	9.98	100.0
2020-12-30	ADME	ETF	35.925	35.925	35.82	35.86	16400.0
2020-12-30	ADRE	ETF	55.92	56.74	55.92	56.74	11422.0
2020-12-30	AESR	ETF	11.86	11.87	11.855	11.855	5300.0
2020-12-30	AFIF	ETF	9.7772	9.79	9.7752	9.7752	8987.0
2020-12-30	AFK	ETF	20.25	20.75	20.25	20.59	9786.0
2020-12-30	AFLG	ETF	22.27	22.28	22.18	22.189	1400.0
2020-12-30	AFMC	ETF	21.328	21.328	21.328	21.328	100.0
2020-12-30	AFTY	ETF	22.47	22.663	22.47	22.639	3500.0
2020-12-30	AGG	ETF	118.09	118.12	117.98	118.1	2762200.0
2020-12-30	AGGY	ETF	53.56	53.639	53.53	53.63	79700.0
2020-12-30	AGNG	ETF	28.137	28.137	27.911	28.0	5600.0
2020-12-30	AGQ	ETF	50.69	52.12	50.47	52.07	814800.0
2020-12-30	AGZ	ETF	119.51	119.5699	119.48	119.52	25606.0
2020-12-30	AGZD	ETF	23.555	23.565	23.525	23.55	5800.0
2020-12-30	AIA	ETF	87.1	87.4399	87.09	87.1	118846.0
2020-12-30	AIEQ	ETF	35.27	35.83	35.27	35.65	12400.0
2020-12-30	AIQ	ETF	27.12	27.24	27.1076	27.18	35919.0
2020-12-30	AIRR	ETF	33.52	33.935	33.52	33.812	45600.0
2020-12-30	AIVI	ETF	40.82	40.87	40.71	40.71	4700.0
2020-12-30	ALTL	ETF	31.828	31.8721	31.76	31.8721	4307.0
2020-12-30	ALTY	ETF	11.6	11.66	11.57	11.577	17600.0
2020-12-30	AMJ	ETF	13.76	14.01	13.731	13.76	950738.0
2020-12-30	AMLP	ETF	25.64	25.93	25.43	25.48	4570600.0
2020-12-30	AMNA	ETF	25.1487	25.1487	25.1487	25.1487	10.0
2020-12-30	AMND	ETF	26.7258	26.7258	26.7258	26.7258	2.0
2020-12-30	AMOM	ETF	31.89	32.05	31.85	31.951	5000.0
2020-12-30	AMTR	ETF	28.37	28.4	28.3232	28.3232	2202.0
2020-12-30	AMUB	ETF	8.77	8.77	8.64	8.66	18767.0

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

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