PREVIEW / etf_daily / 2020-08-04

all etf daily files

  file:    by_date/etf_daily/2020/2020-08-04.parquet
  size:    76 KB
  rows:    2,019

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-04	SPY	ETF	327.86	330.06	327.86	330.06	41917900.0
2020-08-04	QQQ	ETF	268.74	270.48	268.09	270.38	24911286.0
2020-08-04	IWM	ETF	149.39	150.93	149.04	150.79	20285000.0
2020-08-04	DIA	ETF	266.29	268.42	266.03	268.41	1909800.0
2020-08-04	GLD	ETF	185.61	189.6	185.21	189.59	20773200.0
2020-08-04	TLT	ETF	170.83	171.58	170.72	171.57	9878900.0
2020-08-04	AAAU	ETF	19.72	20.12	19.66	20.11	408400.0
2020-08-04	AADR	ETF	57.16	58.04	57.16	58.04	1400.0
2020-08-04	AAXJ	ETF	75.95	76.61	75.95	76.57	1290400.0
2020-08-04	ABEQ	ETF	23.19	23.223	23.19	23.221	4300.0
2020-08-04	ACES	ETF	47.0	48.03	46.83	47.6	64800.0
2020-08-04	ACIO	ETF	26.204	26.32	26.186	26.23	83400.0
2020-08-04	ACSI	ETF	36.2699	36.2699	36.2699	36.2699	109.0
2020-08-04	ACTX	ETF	3.1713	3.1713	2.4013	2.4013	101.0
2020-08-04	ACWF	ETF	29.66	29.7208	29.615	29.7208	13305.0
2020-08-04	ACWI	ETF	78.29	78.91	78.29	78.9	1868800.0
2020-08-04	ACWV	ETF	91.25	91.95	91.14	91.89	965500.0
2020-08-04	ACWX	ETF	45.59	46.02	45.55	46.02	732600.0
2020-08-04	ADME	ETF	33.85	33.924	33.83	33.924	5400.0
2020-08-04	ADRE	ETF	45.93	46.19	45.9024	45.94	37423.0
2020-08-04	AESR	ETF	10.65	10.68	10.62	10.679	1800.0
2020-08-04	AFIF	ETF	9.86	9.9	9.86	9.8758	17569.0
2020-08-04	AFK	ETF	16.96	17.1227	16.705	17.08	14722.0
2020-08-04	AFTY	ETF	18.975	19.085	18.975	19.085	1400.0
2020-08-04	AGG	ETF	119.42	119.63	119.42	119.63	10935200.0
2020-08-04	AGGY	ETF	54.6	54.68	54.54	54.68	156400.0
2020-08-04	AGNG	ETF	25.54	25.575	25.33	25.52	33000.0
2020-08-04	AGQ	ETF	50.01	57.14	49.7	57.14	5019100.0
2020-08-04	AGZ	ETF	121.74	121.88	121.62	121.83	486867.0
2020-08-04	AGZD	ETF	23.6	23.645	23.57	23.62	139200.0
2020-08-04	AIA	ETF	71.0	71.59	71.0	71.57	87602.0
2020-08-04	AIEQ	ETF	30.82	31.11	30.8	31.11	17000.0
2020-08-04	AIQ	ETF	22.47	22.71	22.47	22.7	54106.0
2020-08-04	AIRR	ETF	25.37	25.65	25.37	25.65	7800.0
2020-08-04	AIVI	ETF	36.28	36.7	36.28	36.7	7300.0
2020-08-04	ALTL	ETF	25.005	25.04	24.97	25.0277	2859.0
2020-08-04	ALTY	ETF	10.81	10.93	10.774	10.915	10600.0
2020-08-04	AMJ	ETF	12.96	13.21	12.87	13.19	1289260.0
2020-08-04	AMLP	ETF	23.98	24.52	23.81	24.5	2298700.0
2020-08-04	AMNA	ETF	24.23	24.7706	24.12	24.7706	4093.0
2020-08-04	AMND	ETF	25.52	26.0285	25.52	26.0285	1100.0
2020-08-04	AMOM	ETF	34.82	34.82	34.3	34.61	6700.0
2020-08-04	AMUB	ETF	8.19	8.3133	8.17	8.3133	21007.0
2020-08-04	AMZA	ETF	17.12	17.5	16.95	17.47	53200.0
2020-08-04	ANGL	ETF	30.46	30.5	30.37	30.46	1463100.0
2020-08-04	AOA	ETF	57.21	57.55	57.2	57.55	54300.0
2020-08-04	AOK	ETF	37.25	37.4	37.24	37.39	133696.0
2020-08-04	AOM	ETF	40.98	41.13	40.96	41.13	130443.0
2020-08-04	AOR	ETF	48.04	48.28	48.0248	48.28	62588.0
2020-08-04	APRT	ETF	26.0275	26.0275	26.0275	26.0275	1.0

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

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