PREVIEW / etf_daily / 2020-06-15

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-15.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-06-15	SPY	ETF	298.02	308.28	296.74	307.05	135782700.0
2020-06-15	QQQ	ETF	232.44	239.45	231.47	238.75	45307371.0
2020-06-15	IWM	ETF	133.28	142.06	133.28	140.99	57354800.0
2020-06-15	DIA	ETF	250.29	259.6	249.1	258.35	7421300.0
2020-06-15	GLD	ETF	160.52	162.56	160.16	162.33	8532500.0
2020-06-15	TLT	ETF	163.89	164.22	162.14	162.39	7759800.0
2020-06-15	AAAU	ETF	17.03	17.23	17.0	17.2	308700.0
2020-06-15	AADR	ETF	48.44	50.46	48.44	50.46	2600.0
2020-06-15	AAXJ	ETF	66.54	67.75	66.24	67.46	1004400.0
2020-06-15	ABEQ	ETF	21.998	22.283	21.998	22.283	2300.0
2020-06-15	ACES	ETF	36.06	38.36	36.06	38.13	42300.0
2020-06-15	ACIO	ETF	24.81	25.04	24.81	24.973	14900.0
2020-06-15	ACSI	ETF	32.75	33.328	32.75	33.328	267.0
2020-06-15	ACTX	ETF	4.189	4.72	3.9884	4.2008	309.0
2020-06-15	ACWF	ETF	26.75	27.5499	26.75	27.44	7732.0
2020-06-15	ACWI	ETF	71.11	73.32	70.87	73.07	3099900.0
2020-06-15	ACWV	ETF	85.87	87.83	85.5	87.56	316800.0
2020-06-15	ACWX	ETF	42.0	43.02	41.84	42.88	1983810.0
2020-06-15	ADME	ETF	31.54	31.83	31.23	31.698	25200.0
2020-06-15	ADRE	ETF	38.4	39.34	38.4	39.265	2938.0
2020-06-15	AESR	ETF	9.58	9.723	9.58	9.723	41500.0
2020-06-15	AFIF	ETF	9.8	9.825	9.8	9.8202	36224.0
2020-06-15	AFK	ETF	15.68	16.29	15.64	16.17	14202.0
2020-06-15	AFLG	ETF	18.39	18.65	18.39	18.65	900.0
2020-06-15	AFMC	ETF	17.01	17.01	17.01	17.01	200.0
2020-06-15	AFTY	ETF	16.252	16.252	16.252	16.252	300.0
2020-06-15	AGG	ETF	117.72	117.98	117.61	117.97	5870000.0
2020-06-15	AGGY	ETF	53.65	53.81	53.57	53.78	171300.0
2020-06-15	AGNG	ETF	23.83	24.13	23.82	24.002	7500.0
2020-06-15	AGQ	ETF	25.36	26.85	25.15	26.69	467600.0
2020-06-15	AGZ	ETF	121.06	121.27	120.791	120.84	52485.0
2020-06-15	AGZD	ETF	23.475	23.555	23.425	23.55	68800.0
2020-06-15	AIA	ETF	61.71	62.985	61.44	62.6238	202267.0
2020-06-15	AIEQ	ETF	26.45	27.37	26.45	27.37	25500.0
2020-06-15	AIQ	ETF	19.38	20.0	19.38	19.9616	27822.0
2020-06-15	AIRR	ETF	22.25	23.625	22.25	23.389	45900.0
2020-06-15	AIVI	ETF	34.83	35.75	34.83	35.68	12700.0
2020-06-15	ALTY	ETF	10.97	11.35	10.89	11.24	20400.0
2020-06-15	AMJ	ETF	13.84	15.38	13.655	15.24	2474495.0
2020-06-15	AMLP	ETF	25.87	28.64	25.37	28.24	7522200.0
2020-06-15	AMOM	ETF	28.2	28.386	28.2	28.386	2100.0
2020-06-15	AMUB	ETF	8.83	9.55	8.83	9.5499	34387.0
2020-06-15	AMZA	ETF	19.0	21.39	18.313	21.13	93400.0
2020-06-15	ANGL	ETF	28.29	28.99	28.24	28.85	685400.0
2020-06-15	AOA	ETF	53.18	54.63	53.18	54.37	91000.0
2020-06-15	AOK	ETF	35.85	36.2543	35.81	36.16	107707.0
2020-06-15	AOM	ETF	39.12	39.8	39.0203	39.67	224726.0
2020-06-15	AOR	ETF	45.29	46.1976	45.12	46.06	110169.0
2020-06-15	APRT	ETF	24.78	24.9336	24.78	24.9336	153.0
2020-06-15	APRW	ETF	24.92	24.92	24.8798	24.892	810.0

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

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