PREVIEW / etf_daily / 2020-05-04

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-04.parquet
  size:    74 KB
  rows:    1,959

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-04	SPY	ETF	280.74	283.9	279.13	283.57	80873200.0
2020-05-04	QQQ	ETF	211.61	215.45	211.12	215.22	32841020.0
2020-05-04	IWM	ETF	123.6	125.9	122.25	125.68	28498200.0
2020-05-04	DIA	ETF	235.21	237.75	233.64	237.42	3845500.0
2020-05-04	GLD	ETF	160.33	160.95	159.91	160.34	7986200.0
2020-05-04	TLT	ETF	167.56	167.68	166.48	167.16	8300900.0
2020-05-04	AAAU	ETF	17.01	17.05	16.96	17.01	344300.0
2020-05-04	AADR	ETF	45.04	45.35	44.77	45.35	3300.0
2020-05-04	AAXJ	ETF	62.18	62.51	61.91	62.51	586400.0
2020-05-04	ABEQ	ETF	21.477	21.599	21.43	21.599	1100.0
2020-05-04	ACES	ETF	31.89	32.59	31.7	32.55	25800.0
2020-05-04	ACIO	ETF	23.656	23.71	23.64	23.71	7300.0
2020-05-04	ACSI	ETF	29.6334	30.1134	29.6334	30.1134	391.0
2020-05-04	ACTX	ETF	5.31	5.31	4.248	5.0445	440.0
2020-05-04	ACWF	ETF	25.4625	25.688	25.4	25.688	6865.0
2020-05-04	ACWI	ETF	66.56	67.22	66.24	67.13	2017200.0
2020-05-04	ACWV	ETF	84.95	85.38	84.52	85.31	496600.0
2020-05-04	ACWX	ETF	38.87	39.16	38.7	39.15	3523364.0
2020-05-04	ADME	ETF	29.29	29.872	29.29	29.872	7700.0
2020-05-04	ADRE	ETF	34.74	34.74	34.36	34.6	10615.0
2020-05-04	AESR	ETF	8.86	9.09	8.86	9.09	21200.0
2020-05-04	AFIF	ETF	9.69	9.84	9.29	9.8105	18111.0
2020-05-04	AFK	ETF	14.27	14.3685	14.1499	14.1499	8133.0
2020-05-04	AFTY	ETF	15.13	15.15	15.13	15.135	2700.0
2020-05-04	AGG	ETF	116.89	117.09	116.87	116.97	3684100.0
2020-05-04	AGGY	ETF	52.89	53.07	52.89	53.04	384800.0
2020-05-04	AGNG	ETF	22.01	22.112	22.01	22.112	600.0
2020-05-04	AGQ	ETF	19.68	19.83	19.33	19.45	265400.0
2020-05-04	AGZ	ETF	120.6	120.93	120.435	120.68	107438.0
2020-05-04	AGZD	ETF	23.525	23.525	22.445	23.21	97600.0
2020-05-04	AIA	ETF	57.76	58.32	57.63	58.31	30882.0
2020-05-04	AIEQ	ETF	24.9	25.43	24.9	25.37	14100.0
2020-05-04	AIQ	ETF	17.13	17.54	17.13	17.54	6904.0
2020-05-04	AIRR	ETF	20.77	20.922	20.73	20.922	4600.0
2020-05-04	AIVI	ETF	32.35	32.62	32.33	32.62	4100.0
2020-05-04	ALTY	ETF	9.62	9.78	9.548	9.72	11200.0
2020-05-04	AMJ	ETF	12.9	13.28	12.49	13.27	2175035.0
2020-05-04	AMLP	ETF	23.95	24.95	23.4	24.8	5769900.0
2020-05-04	AMUB	ETF	7.93	8.3328	7.93	8.3328	30303.0
2020-05-04	AMZA	ETF	16.23	17.23	15.831	17.12	100800.0
2020-05-04	ANGL	ETF	26.45	26.66	26.39	26.49	1191500.0
2020-05-04	AOA	ETF	49.96	50.4	49.85	50.4	121800.0
2020-05-04	AOK	ETF	34.85	34.9	34.75	34.9	303036.0
2020-05-04	AOM	ETF	37.66	37.92	37.61	37.92	287942.0
2020-05-04	AOR	ETF	42.97	43.25	42.9108	43.25	204673.0
2020-05-04	ARCM	ETF	99.97	100.355	99.97	100.355	200.0
2020-05-04	ARGT	ETF	17.44	18.0	17.44	17.99	6900.0
2020-05-04	ARKF	ETF	23.41	23.89	23.31	23.87	37200.0
2020-05-04	ARKG	ETF	39.75	41.22	39.59	41.18	228000.0
2020-05-04	ARKK	ETF	51.71	54.31	51.53	54.31	459800.0

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

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