PREVIEW / etf_daily / 2020-04-17

all etf daily files

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

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-04-17	SPY	ETF	285.38	287.3	282.4	286.64	146684800.0
2020-04-17	QQQ	ETF	215.96	216.51	212.0801	215.29	62863223.0
2020-04-17	IWM	ETF	121.9	122.72	120.06	122.06	46250200.0
2020-04-17	DIA	ETF	241.6	242.66	238.25	242.43	5924500.0
2020-04-17	GLD	ETF	159.72	160.07	158.12	158.57	14652700.0
2020-04-17	TLT	ETF	169.82	170.84	167.27	167.81	8612100.0
2020-04-17	AAAU	ETF	16.96	16.96	16.76	16.82	416900.0
2020-04-17	AADR	ETF	44.82	44.84	44.32	44.58	4300.0
2020-04-17	AAXJ	ETF	63.85	63.94	63.25	63.7	936600.0
2020-04-17	ABEQ	ETF	21.551	21.772	21.54	21.772	2600.0
2020-04-17	ACES	ETF	31.93	32.07	31.46	31.8	15200.0
2020-04-17	ACIO	ETF	23.89	24.03	23.89	23.982	8200.0
2020-04-17	ACSI	ETF	31.02	31.02	30.63	30.8676	502.0
2020-04-17	ACTX	ETF	4.72	4.72	4.543	4.72	399.0
2020-04-17	ACWF	ETF	25.99	26.13	25.7739	26.0708	4808.0
2020-04-17	ACWI	ETF	67.59	67.88	66.9	67.81	5653600.0
2020-04-17	ACWV	ETF	87.23	87.46	86.23	87.3	318000.0
2020-04-17	ACWX	ETF	39.47	39.48	39.05	39.41	2562482.0
2020-04-17	ADME	ETF	30.151	30.22	29.97	30.16	10700.0
2020-04-17	ADRE	ETF	36.035	36.1582	35.82	36.0	13327.0
2020-04-17	AESR	ETF	9.1	9.201	9.1	9.201	83300.0
2020-04-17	AFIF	ETF	9.8	9.85	9.76	9.7999	733450.0
2020-04-17	AFK	ETF	13.67	13.9	13.5575	13.9	17197.0
2020-04-17	AFLG	ETF	17.35	17.465	17.34	17.465	5600.0
2020-04-17	AFMC	ETF	15.17	15.232	15.164	15.232	2400.0
2020-04-17	AFSM	ETF	14.67	14.67	14.54	14.66	3600.0
2020-04-17	AFTY	ETF	15.54	15.57	15.461	15.57	5700.0
2020-04-17	AGG	ETF	117.52	117.62	117.04	117.25	4949800.0
2020-04-17	AGGY	ETF	53.36	53.53	53.2	53.28	328900.0
2020-04-17	AGNG	ETF	22.3	22.566	22.252	22.566	2600.0
2020-04-17	AGQ	ETF	21.68	21.77	21.11	21.24	195300.0
2020-04-17	AGZ	ETF	120.73	120.73	120.22	120.3812	121152.0
2020-04-17	AGZD	ETF	23.4	23.875	23.4	23.52	13800.0
2020-04-17	AIA	ETF	59.59	59.68	59.16	59.45	29979.0
2020-04-17	AIEQ	ETF	25.37	25.49	25.054	25.49	24400.0
2020-04-17	AIQ	ETF	17.36	17.4499	17.2518	17.41	11002.0
2020-04-17	AIRR	ETF	20.539	20.82	20.401	20.765	37200.0
2020-04-17	AIVI	ETF	32.56	32.84	32.42	32.84	18200.0
2020-04-17	ALTY	ETF	9.553	9.653	9.49	9.561	2900.0
2020-04-17	AMJ	ETF	10.68	11.2	10.4788	11.19	3812216.0
2020-04-17	AMLP	ETF	20.25	21.2	20.0	21.15	6394500.0
2020-04-17	AMUB	ETF	6.94	7.0249	6.7	7.0249	16785.0
2020-04-17	AMZA	ETF	13.11	14.12	13.11	14.01	113100.0
2020-04-17	ANGL	ETF	27.44	27.48	27.18	27.31	792400.0
2020-04-17	AOA	ETF	50.6	50.74	50.15	50.72	124400.0
2020-04-17	AOK	ETF	34.91	35.13	34.85	35.03	407379.0
2020-04-17	AOM	ETF	37.91	38.04	37.73	37.94	402837.0
2020-04-17	AOR	ETF	43.35	43.522	43.22	43.48	240439.0
2020-04-17	ARGT	ETF	18.46	18.46	17.88	17.88	34000.0
2020-04-17	ARKF	ETF	22.94	22.952	22.687	22.93	80700.0

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

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