PREVIEW / etf_daily / 2020-09-11

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-11.parquet
  size:    78 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-09-11	SPY	ETF	335.82	336.97	331.0	334.06	84680200.0
2020-09-11	QQQ	ETF	274.33	275.22	266.9	270.45	71809014.0
2020-09-11	IWM	ETF	150.92	151.05	147.68	149.15	20851000.0
2020-09-11	DIA	ETF	276.95	278.82	274.96	277.09	2787500.0
2020-09-11	GLD	ETF	183.14	183.55	182.01	182.45	7662300.0
2020-09-11	TLT	ETF	164.31	164.57	164.08	164.48	5458200.0
2020-09-11	AAA	ETF	25.04	25.05	25.02	25.035	33786.0
2020-09-11	AAAU	ETF	19.44	19.47	19.32	19.36	367700.0
2020-09-11	AADR	ETF	55.61	55.61	55.2	55.32	1100.0
2020-09-11	AAXJ	ETF	76.74	77.0	76.15	76.56	963800.0
2020-09-11	ABEQ	ETF	23.75	23.887	23.75	23.887	1300.0
2020-09-11	ACES	ETF	50.42	50.42	49.21	49.66	39100.0
2020-09-11	ACIO	ETF	26.465	26.52	26.31	26.51	10100.0
2020-09-11	ACSI	ETF	36.57	36.8095	36.57	36.8095	345.0
2020-09-11	ACTX	ETF	2.2774	2.7081	2.1358	2.36	574.0
2020-09-11	ACWF	ETF	29.69	29.69	29.3578	29.5538	874.0
2020-09-11	ACWI	ETF	80.17	80.4	79.22	79.8	3274900.0
2020-09-11	ACWV	ETF	91.75	92.11	91.36	91.79	191100.0
2020-09-11	ACWX	ETF	46.66	46.76	46.31	46.51	1392587.0
2020-09-11	ADFI	ETF	10.016	10.016	10.016	10.016	100.0
2020-09-11	ADME	ETF	33.44	33.44	33.191	33.293	8100.0
2020-09-11	ADRE	ETF	46.4	46.62	45.82	46.0188	6080.0
2020-09-11	AESR	ETF	10.764	10.764	10.764	10.764	100.0
2020-09-11	AFIF	ETF	9.81	9.85	9.81	9.835	55860.0
2020-09-11	AFK	ETF	17.9	18.055	17.57	17.78	6150.0
2020-09-11	AFLG	ETF	19.95	19.987	19.95	19.987	1000.0
2020-09-11	AFMC	ETF	17.68	17.68	17.637	17.637	100.0
2020-09-11	AFSM	ETF	17.79	17.79	17.651	17.651	100.0
2020-09-11	AFTY	ETF	19.26	19.28	19.2	19.235	1200.0
2020-09-11	AGG	ETF	118.42	118.49	118.24	118.37	8200400.0
2020-09-11	AGGY	ETF	54.09	54.09	54.0	54.06	55900.0
2020-09-11	AGNG	ETF	25.26	25.26	25.105	25.13	800.0
2020-09-11	AGQ	ETF	57.37	58.01	55.95	56.82	847200.0
2020-09-11	AGZ	ETF	121.29	121.3	121.0589	121.26	37014.0
2020-09-11	AGZD	ETF	23.55	23.595	23.5	23.55	17800.0
2020-09-11	AIA	ETF	72.08	72.19	71.53	71.79	222641.0
2020-09-11	AIEQ	ETF	29.75	29.798	29.11	29.32	16900.0
2020-09-11	AIQ	ETF	22.95	23.1299	22.48	22.7244	19497.0
2020-09-11	AIRR	ETF	26.05	26.135	25.94	25.94	1200.0
2020-09-11	AIVI	ETF	36.91	37.16	36.84	37.1	144400.0
2020-09-11	ALTL	ETF	24.92	24.97	24.8793	24.8793	1823.0
2020-09-11	ALTY	ETF	10.77	10.77	10.677	10.68	4200.0
2020-09-11	AMJ	ETF	11.81	11.81	11.49	11.52	903189.0
2020-09-11	AMLP	ETF	21.53	21.74	21.17	21.3	2846000.0
2020-09-11	AMNA	ETF	23.24	23.24	22.93	23.0517	1500.0
2020-09-11	AMND	ETF	24.16	24.16	24.07	24.1221	300.0
2020-09-11	AMOM	ETF	34.25	34.25	33.45	33.796	5700.0
2020-09-11	AMUB	ETF	7.34	7.38	7.23	7.26	20806.0
2020-09-11	AMZA	ETF	15.13	15.35	14.76	14.88	118900.0
2020-09-11	ANGL	ETF	30.12	30.12	29.95	30.03	1203400.0

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

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