PREVIEW / etf_daily / 2020-05-13

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-13.parquet
  size:    75 KB
  rows:    1,990

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-05-13	SPY	ETF	286.06	287.19	278.96	281.6	144721100.0
2020-05-13	QQQ	ETF	222.65	224.61	216.71	219.34	65521208.0
2020-05-13	IWM	ETF	125.65	126.08	120.41	122.72	58719300.0
2020-05-13	DIA	ETF	236.96	237.5	231.02	232.82	7531300.0
2020-05-13	GLD	ETF	160.94	161.62	160.54	161.58	10950400.0
2020-05-13	TLT	ETF	165.09	166.29	164.83	165.52	13305600.0
2020-05-13	AAAU	ETF	17.07	17.14	17.02	17.12	433300.0
2020-05-13	AADR	ETF	46.77	46.77	45.77	45.91	25300.0
2020-05-13	AAXJ	ETF	64.71	64.92	63.63	64.1	1487300.0
2020-05-13	ABEQ	ETF	21.5	21.5	21.16	21.215	2400.0
2020-05-13	ACES	ETF	34.22	34.22	32.49	32.8	45600.0
2020-05-13	ACIO	ETF	23.81	23.81	23.71	23.79	16700.0
2020-05-13	ACSI	ETF	29.48	29.5855	29.48	29.5855	903.0
2020-05-13	ACTX	ETF	4.72	5.31	4.72	4.72	799.0
2020-05-13	ACWF	ETF	25.76	26.0	25.3663	25.563	11766.0
2020-05-13	ACWI	ETF	68.27	68.45	66.77	67.26	13590400.0
2020-05-13	ACWV	ETF	85.79	85.81	84.26	84.73	343700.0
2020-05-13	ACWX	ETF	40.01	40.02	39.2443	39.44	3620955.0
2020-05-13	ADME	ETF	30.545	30.59	30.335	30.49	11400.0
2020-05-13	ADRE	ETF	35.74	35.74	34.86	34.98	4748.0
2020-05-13	AESR	ETF	9.079	9.079	9.079	9.079	100.0
2020-05-13	AFIF	ETF	9.8235	9.8412	9.7902	9.82	1869.0
2020-05-13	AFK	ETF	14.52	14.98	14.4	14.42	129388.0
2020-05-13	AFLG	ETF	17.215	17.215	17.215	17.215	100.0
2020-05-13	AFMC	ETF	15.03	15.03	14.945	14.945	300.0
2020-05-13	AFSM	ETF	14.453	14.453	14.453	14.453	100.0
2020-05-13	AFTY	ETF	15.96	16.054	15.92	15.926	6000.0
2020-05-13	AGG	ETF	116.63	116.76	116.45	116.6	4425900.0
2020-05-13	AGGY	ETF	52.87	52.91	52.75	52.84	143300.0
2020-05-13	AGNG	ETF	22.97	22.97	22.581	22.68	2200.0
2020-05-13	AGQ	ETF	21.8	22.15	21.53	21.96	461300.0
2020-05-13	AGZ	ETF	120.62	120.96	120.62	120.85	23938.0
2020-05-13	AGZD	ETF	23.18	23.22	23.145	23.22	23000.0
2020-05-13	AIA	ETF	59.76	59.9843	58.9335	59.16	34159.0
2020-05-13	AIEQ	ETF	26.48	26.682	25.91	26.33	20900.0
2020-05-13	AIQ	ETF	18.32	18.46	17.87	18.0664	25106.0
2020-05-13	AIRR	ETF	19.75	19.75	18.92	19.185	46300.0
2020-05-13	AIVI	ETF	33.1	33.14	32.63	32.74	7400.0
2020-05-13	ALTY	ETF	9.75	9.79	9.424	9.53	4800.0
2020-05-13	AMJ	ETF	13.04	13.05	12.42	12.7	1257132.0
2020-05-13	AMLP	ETF	23.8	23.85	22.55	23.0	4920020.0
2020-05-13	AMOM	ETF	26.585	26.585	26.585	26.585	100.0
2020-05-13	AMUB	ETF	8.11	8.11	7.85	7.98	25894.0
2020-05-13	AMZA	ETF	17.32	17.32	16.046	16.47	95800.0
2020-05-13	ANGL	ETF	26.89	27.03	26.56	26.66	1206600.0
2020-05-13	AOA	ETF	50.97	50.97	50.01	50.22	55900.0
2020-05-13	AOK	ETF	35.04	35.04	34.76	34.84	143101.0
2020-05-13	AOM	ETF	38.12	38.12	37.6301	37.82	249239.0
2020-05-13	AOR	ETF	43.68	43.68	43.0339	43.19	133735.0
2020-05-13	ARB	ETF	24.92	24.95	24.805	24.8275	2580.0

> showing 50 of 1,990 rows — these rows as CSV

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