PREVIEW / etf_daily / 2020-05-15

all etf daily files

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

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-15	SPY	ETF	282.37	286.33	281.34	286.28	111146300.0
2020-05-15	QQQ	ETF	218.77	223.33	218.33	223.27	55747208.0
2020-05-15	IWM	ETF	122.01	125.53	121.46	125.08	40236600.0
2020-05-15	DIA	ETF	234.16	237.25	233.41	236.91	4811100.0
2020-05-15	GLD	ETF	164.02	164.8	163.08	163.93	13918800.0
2020-05-15	TLT	ETF	168.3	168.49	166.33	166.71	7225600.0
2020-05-15	AAAU	ETF	17.37	17.46	17.3	17.39	312300.0
2020-05-15	AADR	ETF	45.91	46.61	45.91	46.53	9200.0
2020-05-15	AAXJ	ETF	63.04	63.36	62.85	63.21	604400.0
2020-05-15	ABEQ	ETF	21.395	21.5	21.38	21.5	13700.0
2020-05-15	ACES	ETF	32.78	33.032	32.5	32.93	31100.0
2020-05-15	ACIO	ETF	23.775	23.968	23.775	23.968	14600.0
2020-05-15	ACSI	ETF	29.9299	30.1243	29.9299	30.1243	342.0
2020-05-15	ACTX	ETF	3.9825	5.31	3.9825	4.72	149.0
2020-05-15	ACWF	ETF	25.49	25.73	25.49	25.73	16630.0
2020-05-15	ACWI	ETF	67.09	67.74	66.91	67.74	2617100.0
2020-05-15	ACWV	ETF	84.47	85.15	84.35	85.14	277800.0
2020-05-15	ACWX	ETF	39.04	39.3	38.91	39.17	1456457.0
2020-05-15	ADME	ETF	30.69	30.91	30.48	30.91	5100.0
2020-05-15	ADRE	ETF	34.87	35.1926	34.87	35.135	2950.0
2020-05-15	AESR	ETF	9.07	9.204	9.03	9.204	112400.0
2020-05-15	AFIF	ETF	9.79	9.815	9.78	9.815	38265.0
2020-05-15	AFK	ETF	14.59	14.8	14.56	14.7	12156.0
2020-05-15	AFLG	ETF	17.44	17.473	17.44	17.473	900.0
2020-05-15	AFSM	ETF	14.756	14.756	14.756	14.756	100.0
2020-05-15	AFTY	ETF	15.68	15.68	15.6	15.676	4900.0
2020-05-15	AGG	ETF	117.04	117.09	116.9	117.03	5897900.0
2020-05-15	AGGY	ETF	53.08	53.09	52.9	53.03	269800.0
2020-05-15	AGNG	ETF	22.73	22.88	22.73	22.88	700.0
2020-05-15	AGQ	ETF	25.12	25.88	24.55	25.69	773100.0
2020-05-15	AGZ	ETF	121.23	121.23	120.91	121.18	43788.0
2020-05-15	AGZD	ETF	23.155	23.205	23.135	23.185	7600.0
2020-05-15	AIA	ETF	57.97	58.1948	57.76	57.91	66293.0
2020-05-15	AIEQ	ETF	26.08	26.6	26.08	26.562	13600.0
2020-05-15	AIQ	ETF	17.98	18.3359	17.98	18.328	8007.0
2020-05-15	AIRR	ETF	19.27	19.805	19.22	19.785	3800.0
2020-05-15	AIVI	ETF	32.53	32.53	32.31	32.48	5000.0
2020-05-15	ALTY	ETF	9.57	9.71	9.57	9.67	8800.0
2020-05-15	AMJ	ETF	12.82	13.28	12.81	13.24	1054661.0
2020-05-15	AMLP	ETF	23.4	24.15	23.2	24.05	3352500.0
2020-05-15	AMOM	ETF	27.193	27.193	27.193	27.193	100.0
2020-05-15	AMUB	ETF	8.175	8.3364	8.175	8.3364	9915.0
2020-05-15	AMZA	ETF	16.46	17.38	16.44	17.27	63900.0
2020-05-15	ANGL	ETF	26.46	26.64	26.39	26.6	782300.0
2020-05-15	AOA	ETF	50.12	50.52	50.12	50.52	81900.0
2020-05-15	AOK	ETF	34.9296	34.96	34.81	34.96	47393.0
2020-05-15	AOM	ETF	37.86	37.97	37.75	37.97	423367.0
2020-05-15	AOR	ETF	43.13	43.3906	43.07	43.35	214593.0
2020-05-15	ARB	ETF	24.8598	24.8598	24.76	24.8048	1484.0
2020-05-15	ARGT	ETF	19.61	20.64	19.61	20.41	43300.0

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

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