PREVIEW / etf_daily / 2020-10-29

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-29.parquet
  size:    80 KB
  rows:    2,122

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-10-29	SPY	ETF	326.91	333.4	325.09	329.98	90597700.0
2020-10-29	QQQ	ETF	273.04	279.49	272.52	276.39	43246302.0
2020-10-29	IWM	ETF	152.77	155.79	151.67	155.14	27203200.0
2020-10-29	DIA	ETF	265.13	268.94	262.81	266.59	5479400.0
2020-10-29	GLD	ETF	175.02	176.14	174.83	175.4	8474500.0
2020-10-29	TLT	ETF	160.73	160.83	158.47	159.14	11932400.0
2020-10-29	AAA	ETF	24.9401	24.96	24.94	24.945	1750.0
2020-10-29	AAAU	ETF	18.59	18.7	18.55	18.62	711600.0
2020-10-29	AADR	ETF	54.21	54.3	53.81	54.23	8700.0
2020-10-29	AAXJ	ETF	79.36	79.98	79.1	79.65	779900.0
2020-10-29	ABEQ	ETF	23.0	23.19	23.0	23.08	7300.0
2020-10-29	ACES	ETF	56.02	56.49	55.63	56.4	58700.0
2020-10-29	ACIO	ETF	26.146	26.46	26.146	26.345	6100.0
2020-10-29	ACSI	ETF	38.232	38.232	38.232	38.232	153.0
2020-10-29	ACTV	ETF	24.0	24.57	24.0	24.48	1035837.0
2020-10-29	ACTX	ETF	2.075	2.075	2.01	2.04	1275.0
2020-10-29	ACVF	ETF	24.27	24.5137	24.27	24.5137	575.0
2020-10-29	ACWF	ETF	29.18	29.41	29.18	29.33	52867.0
2020-10-29	ACWI	ETF	78.31	79.42	77.91	78.82	7900400.0
2020-10-29	ACWV	ETF	89.72	90.31	89.13	89.77	301600.0
2020-10-29	ACWX	ETF	45.16	45.5	44.92	45.33	1110116.0
2020-10-29	ADFI	ETF	9.93	9.93	9.93	9.93	100.0
2020-10-29	ADME	ETF	33.26	33.58	33.215	33.45	43300.0
2020-10-29	ADRE	ETF	48.9893	49.425	48.8649	49.3	9859.0
2020-10-29	AESR	ETF	10.63	10.86	10.63	10.783	14100.0
2020-10-29	AFIF	ETF	9.78	9.7828	9.75	9.755	13771.0
2020-10-29	AFK	ETF	17.4	17.7299	17.4	17.6326	5007.0
2020-10-29	AFLG	ETF	19.936	19.936	19.936	19.936	100.0
2020-10-29	AFSM	ETF	18.32	18.32	18.32	18.32	200.0
2020-10-29	AFTY	ETF	20.41	20.505	20.41	20.505	1800.0
2020-10-29	AGG	ETF	117.76	117.77	117.4	117.52	11775800.0
2020-10-29	AGGY	ETF	53.55	53.59	53.415	53.45	188400.0
2020-10-29	AGNG	ETF	24.78	24.86	24.779	24.823	1700.0
2020-10-29	AGQ	ETF	39.83	42.26	39.71	41.42	1065200.0
2020-10-29	AGZ	ETF	120.95	120.95	120.72	120.83	66146.0
2020-10-29	AGZD	ETF	23.485	23.485	23.425	23.425	20800.0
2020-10-29	AIA	ETF	75.46	75.78	75.0945	75.63	74418.0
2020-10-29	AIEQ	ETF	30.46	30.8	30.24	30.644	11100.0
2020-10-29	AIQ	ETF	23.6	23.89	23.5	23.74	89117.0
2020-10-29	AIRR	ETF	26.104	26.69	26.104	26.611	5700.0
2020-10-29	AIVI	ETF	34.37	34.55	34.2	34.55	9400.0
2020-10-29	ALTL	ETF	24.59	24.595	24.4418	24.4418	1834.0
2020-10-29	ALTY	ETF	10.32	10.417	10.25	10.417	11700.0
2020-10-29	AMJ	ETF	11.1	11.405	10.87	11.4	829377.0
2020-10-29	AMLP	ETF	20.59	21.17	20.14	21.09	3135400.0
2020-10-29	AMNA	ETF	21.09	21.3321	21.09	21.3321	9100.0
2020-10-29	AMND	ETF	22.04	22.5817	22.04	22.5817	5600.0
2020-10-29	AMOM	ETF	35.644	35.644	35.644	35.644	300.0
2020-10-29	AMTR	ETF	23.83	24.22	23.83	24.1203	200.0
2020-10-29	AMUB	ETF	6.93	7.17	6.93	7.169	27954.0

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

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