PREVIEW / etf_daily / 2020-08-19

all etf daily files

  file:    by_date/etf_daily/2020/2020-08-19.parquet
  size:    78 KB
  rows:    2,054

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-08-19	SPY	ETF	339.05	339.61	336.62	337.23	68054200.0
2020-08-19	QQQ	ETF	277.93	279.02	275.57	276.1	31999359.0
2020-08-19	IWM	ETF	156.93	158.04	156.19	156.4	14337300.0
2020-08-19	DIA	ETF	278.68	279.74	276.97	277.43	3374300.0
2020-08-19	GLD	ETF	187.21	187.46	181.71	182.24	24646900.0
2020-08-19	TLT	ETF	165.37	165.61	163.3	163.73	12497700.0
2020-08-19	AAAU	ETF	19.85	19.88	19.27	19.34	755700.0
2020-08-19	AADR	ETF	57.58	57.58	56.45	56.45	2000.0
2020-08-19	AAXJ	ETF	77.25	77.25	76.65	76.75	732800.0
2020-08-19	ABEQ	ETF	23.64	23.66	23.488	23.488	4400.0
2020-08-19	ACES	ETF	51.16	51.96	51.16	51.53	71600.0
2020-08-19	ACIO	ETF	26.875	26.94	26.76	26.82	10400.0
2020-08-19	ACSI	ETF	37.5617	37.5617	37.5617	37.5617	100.0
2020-08-19	ACTX	ETF	2.36	2.7612	2.36	2.7612	302.0
2020-08-19	ACWF	ETF	30.42	30.53	30.075	30.208	3805.0
2020-08-19	ACWI	ETF	80.93	81.05	80.33	80.41	1854600.0
2020-08-19	ACWV	ETF	93.17	93.31	92.45	92.53	271100.0
2020-08-19	ACWX	ETF	47.08	47.13	46.67	46.72	389835.0
2020-08-19	ADME	ETF	34.16	34.248	34.02	34.055	7900.0
2020-08-19	ADRE	ETF	46.32	46.32	45.92	46.0248	4978.0
2020-08-19	AESR	ETF	10.96	10.96	10.876	10.876	4700.0
2020-08-19	AFIF	ETF	9.89	9.89	9.815	9.815	57661.0
2020-08-19	AFK	ETF	17.6927	17.6927	17.465	17.465	2744.0
2020-08-19	AFLG	ETF	20.479	20.479	20.479	20.479	100.0
2020-08-19	AFTY	ETF	19.2	19.28	19.159	19.159	10600.0
2020-08-19	AGG	ETF	118.65	118.7	118.34	118.35	4541000.0
2020-08-19	AGGY	ETF	54.19	54.21	54.05	54.09	101600.0
2020-08-19	AGNG	ETF	25.72	25.76	25.568	25.568	2400.0
2020-08-19	AGQ	ETF	62.26	62.84	56.39	57.27	3913200.0
2020-08-19	AGZ	ETF	121.13	121.3714	120.91	121.07	38315.0
2020-08-19	AGZD	ETF	23.61	23.615	23.555	23.555	7600.0
2020-08-19	AIA	ETF	71.7	71.758	71.2817	71.3069	314052.0
2020-08-19	AIEQ	ETF	31.12	31.2	30.94	30.94	8100.0
2020-08-19	AIQ	ETF	22.78	22.84	22.6299	22.6299	47325.0
2020-08-19	AIRR	ETF	27.289	27.289	26.964	26.964	4400.0
2020-08-19	AIVI	ETF	37.72	37.72	37.33	37.33	8500.0
2020-08-19	ALTL	ETF	25.36	25.4	24.96	25.2483	20264.0
2020-08-19	ALTY	ETF	11.09	11.09	10.96	10.98	5600.0
2020-08-19	AMJ	ETF	13.57	13.71	13.47	13.5	521089.0
2020-08-19	AMLP	ETF	24.39	24.62	24.12	24.17	1584400.0
2020-08-19	AMNA	ETF	25.29	25.29	25.0844	25.0844	700.0
2020-08-19	AMND	ETF	26.62	26.63	26.46	26.4601	600.0
2020-08-19	AMOM	ETF	35.2	35.359	35.04	35.04	1200.0
2020-08-19	AMUB	ETF	8.52	8.56	8.46	8.46	422704.0
2020-08-19	AMZA	ETF	18.08	18.374	17.84	17.92	89600.0
2020-08-19	ANGL	ETF	30.32	30.33	30.12	30.22	440200.0
2020-08-19	AOA	ETF	58.72	58.9	58.39	58.4	37000.0
2020-08-19	AOK	ETF	37.56	37.56	37.4	37.41	108405.0
2020-08-19	AOM	ETF	41.44	41.4891	41.2304	41.28	142066.0
2020-08-19	AOR	ETF	49.02	49.02	48.67	48.67	73485.0

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

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