PREVIEW / etf_daily / 2020-11-20

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-20.parquet
  size:    81 KB
  rows:    2,152

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-11-20	SPY	ETF	357.5	357.72	355.25	355.33	70417300.0
2020-11-20	QQQ	ETF	292.3	293.065	290.29	290.38	25907308.0
2020-11-20	IWM	ETF	176.67	177.94	175.83	177.5	24898800.0
2020-11-20	DIA	ETF	294.22	294.59	292.2	292.53	3090200.0
2020-11-20	GLD	ETF	176.12	176.38	175.58	175.69	6379400.0
2020-11-20	TLT	ETF	160.53	161.54	160.39	161.51	7246800.0
2020-11-20	AAA	ETF	25.03	25.04	25.03	25.04	6278.0
2020-11-20	AAAU	ETF	18.69	18.72	18.64	18.65	200200.0
2020-11-20	AADR	ETF	57.09	57.58	57.09	57.58	3600.0
2020-11-20	AAXJ	ETF	85.52	86.01	85.34	85.77	643800.0
2020-11-20	ABEQ	ETF	24.61	24.61	24.52	24.521	1300.0
2020-11-20	ACES	ETF	65.65	66.279	65.26	65.945	94600.0
2020-11-20	ACIO	ETF	27.28	27.28	27.12	27.23	24100.0
2020-11-20	ACSI	ETF	41.23	41.36	41.23	41.36	363.0
2020-11-20	ACTV	ETF	28.24	28.319	28.24	28.319	3460.0
2020-11-20	ACTX	ETF	2.5	2.5	2.5	2.5	232.0
2020-11-20	ACVF	ETF	26.56	26.56	26.349	26.349	5200.0
2020-11-20	ACWF	ETF	32.02	32.02	31.79	31.8	25643.0
2020-11-20	ACWI	ETF	86.61	86.71	86.35	86.35	5055600.0
2020-11-20	ACWV	ETF	95.54	95.87	95.44	95.51	668300.0
2020-11-20	ACWX	ETF	50.65	50.86	50.6	50.8	1119128.0
2020-11-20	ADFI	ETF	9.98	10.01	9.97	10.01	6900.0
2020-11-20	ADME	ETF	34.717	34.75	34.63	34.63	16700.0
2020-11-20	ADRE	ETF	53.36	53.43	53.02	53.26	30369.0
2020-11-20	AESR	ETF	11.425	11.46	11.384	11.384	7900.0
2020-11-20	AFIF	ETF	9.73	9.81	9.73	9.81	85190.0
2020-11-20	AFK	ETF	19.4405	19.4546	19.36	19.41	2103.0
2020-11-20	AFMC	ETF	19.954	19.954	19.954	19.954	100.0
2020-11-20	AFTY	ETF	21.67	21.67	21.67	21.67	300.0
2020-11-20	AGG	ETF	118.19	118.34	118.13	118.29	7217400.0
2020-11-20	AGGY	ETF	53.86	53.989	53.86	53.95	88500.0
2020-11-20	AGNG	ETF	26.34	26.34	26.34	26.34	1000.0
2020-11-20	AGQ	ETF	44.67	45.02	43.73	43.75	689100.0
2020-11-20	AGZ	ETF	120.87	120.93	120.8	120.92	19965.0
2020-11-20	AGZD	ETF	23.575	23.575	23.555	23.57	4200.0
2020-11-20	AIA	ETF	81.98	82.335	81.86	82.07	48965.0
2020-11-20	AIEQ	ETF	32.49	32.699	32.44	32.514	14500.0
2020-11-20	AIQ	ETF	25.41	25.51	25.31	25.32	46183.0
2020-11-20	AIRR	ETF	31.09	31.09	30.84	31.067	10000.0
2020-11-20	AIVI	ETF	38.87	39.05	38.87	38.99	4500.0
2020-11-20	ALTL	ETF	29.0586	29.09	28.9284	28.9635	3561.0
2020-11-20	ALTY	ETF	11.46	11.46	11.401	11.442	4900.0
2020-11-20	AMJ	ETF	13.94	13.9901	13.73	13.79	969652.0
2020-11-20	AMLP	ETF	25.23	25.35	24.82	24.83	3032200.0
2020-11-20	AMNA	ETF	24.4145	24.4145	24.4145	24.4145	0.0
2020-11-20	AMND	ETF	26.0654	26.0654	26.0654	26.0654	0.0
2020-11-20	AMOM	ETF	37.08	37.361	37.08	37.134	1700.0
2020-11-20	AMTR	ETF	27.37	27.66	27.33	27.5009	19003.0
2020-11-20	AMUB	ETF	8.74	8.78	8.64	8.64	187428.0
2020-11-20	AMZA	ETF	18.33	18.459	17.92	17.92	241900.0

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

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