PREVIEW / etf_daily / 2020-10-20

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-20.parquet
  size:    79 KB
  rows:    2,076

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-20	SPY	ETF	343.46	346.88	342.64	343.38	60051900.0
2020-10-20	QQQ	ETF	284.56	287.62	282.95	284.41	32195361.0
2020-10-20	IWM	ETF	161.56	162.45	160.34	160.76	18927700.0
2020-10-20	DIA	ETF	283.16	285.66	282.25	282.95	3339000.0
2020-10-20	GLD	ETF	178.54	179.67	178.08	179.25	7121400.0
2020-10-20	TLT	ETF	159.86	160.01	158.95	159.25	11189000.0
2020-10-20	AAA	ETF	24.9098	24.92	24.9	24.91	16917.0
2020-10-20	AAAU	ETF	18.94	19.07	18.91	19.02	422800.0
2020-10-20	AADR	ETF	57.91	57.94	57.76	57.76	2000.0
2020-10-20	AAXJ	ETF	79.97	80.64	79.75	80.18	2051400.0
2020-10-20	ABEQ	ETF	23.71	23.775	23.69	23.73	1100.0
2020-10-20	ACES	ETF	59.99	60.5	59.65	59.85	116400.0
2020-10-20	ACIO	ETF	26.97	27.04	26.905	26.93	41100.0
2020-10-20	ACSI	ETF	39.27	39.27	39.1977	39.1977	367.0
2020-10-20	ACTX	ETF	1.94	6.0	1.94	2.8	10149.0
2020-10-20	ACWF	ETF	30.761	30.83	30.7095	30.7552	8296.0
2020-10-20	ACWI	ETF	82.08	82.69	81.9	82.03	3062900.0
2020-10-20	ACWV	ETF	92.75	93.2	92.58	92.66	150000.0
2020-10-20	ACWX	ETF	47.21	47.45	47.14	47.19	692028.0
2020-10-20	ADME	ETF	34.2	34.54	34.2	34.344	20500.0
2020-10-20	ADRE	ETF	50.09	50.41	50.02	50.125	3479.0
2020-10-20	AESR	ETF	11.16	11.165	11.121	11.165	1400.0
2020-10-20	AFIF	ETF	9.775	9.7837	9.76	9.775	15467.0
2020-10-20	AFK	ETF	18.1999	18.2	18.1	18.1719	6315.0
2020-10-20	AFMC	ETF	18.88	18.88	18.838	18.838	300.0
2020-10-20	AFTY	ETF	20.65	20.7	20.61	20.639	3800.0
2020-10-20	AGG	ETF	117.7	117.71	117.58	117.65	4013600.0
2020-10-20	AGGY	ETF	53.71	53.71	53.61	53.62	71800.0
2020-10-20	AGNG	ETF	25.78	25.91	25.721	25.721	2600.0
2020-10-20	AGQ	ETF	46.22	47.67	46.06	47.05	1379000.0
2020-10-20	AGZ	ETF	120.77	120.88	120.76	120.83	93107.0
2020-10-20	AGZD	ETF	23.48	23.5	23.435	23.465	11800.0
2020-10-20	AIA	ETF	75.0	75.52	74.9199	75.26	292640.0
2020-10-20	AIEQ	ETF	32.07	32.23	31.88	32.01	13900.0
2020-10-20	AIQ	ETF	24.57	24.69	24.4	24.4955	35886.0
2020-10-20	AIRR	ETF	28.14	28.234	28.08	28.08	2600.0
2020-10-20	AIVI	ETF	36.47	36.56	36.41	36.41	3700.0
2020-10-20	ALTL	ETF	25.5207	25.56	25.44	25.4687	3418.0
2020-10-20	ALTY	ETF	10.64	10.69	10.632	10.665	13200.0
2020-10-20	AMJ	ETF	11.69	11.855	11.59	11.66	570708.0
2020-10-20	AMLP	ETF	21.52	22.01	21.48	21.74	2827700.0
2020-10-20	AMNA	ETF	22.23	22.23	22.229	22.229	200.0
2020-10-20	AMND	ETF	23.3619	23.3619	23.3619	23.3619	2.0
2020-10-20	AMOM	ETF	36.945	37.58	36.783	36.783	1300.0
2020-10-20	AMUB	ETF	7.29	7.3634	7.29	7.3634	10661.0
2020-10-20	AMZA	ETF	14.46	14.89	14.34	14.66	124000.0
2020-10-20	ANEW	ETF	39.63	39.789	39.417	39.44	8500.0
2020-10-20	ANGL	ETF	29.96	30.07	29.94	30.05	608400.0
2020-10-20	AOA	ETF	59.12	59.45	59.02	59.05	54400.0
2020-10-20	AOK	ETF	37.41	37.559	37.41	37.48	89391.0

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

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