PREVIEW / etf_daily / 2019-11-05

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-05.parquet
  size:    71 KB
  rows:    1,873

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
2019-11-05	SPY	ETF	307.59	307.92	306.71	307.03	42933200.0
2019-11-05	QQQ	ETF	200.35	200.55	199.55	200.21	15048864.0
2019-11-05	IWM	ETF	159.4	160.46	158.97	159.15	13760200.0
2019-11-05	DIA	ETF	275.08	275.51	274.43	274.81	1706300.0
2019-11-05	GLD	ETF	140.65	140.89	139.38	139.85	11782300.0
2019-11-05	TLT	ETF	137.22	137.44	136.73	137.15	13493000.0
2019-11-05	AAAU	ETF	14.91	15.07	14.78	14.82	191500.0
2019-11-05	AADR	ETF	50.51	50.51	50.09	50.27	10100.0
2019-11-05	AAXJ	ETF	71.57	71.66	71.32	71.57	1746300.0
2019-11-05	ACES	ETF	31.52	31.665	31.42	31.64	12900.0
2019-11-05	ACIO	ETF	25.13	25.19	25.12	25.138	17100.0
2019-11-05	ACSI	ETF	34.9375	34.95	34.9211	34.9211	852.0
2019-11-05	ACTX	ETF	8.8501	11.1806	8.5551	8.8501	402.0
2019-11-05	ACWF	ETF	30.3054	30.31	30.2717	30.2717	4104.0
2019-11-05	ACWI	ETF	76.99	77.03	76.74	76.89	3875100.0
2019-11-05	ACWV	ETF	95.29	95.45	94.81	94.95	241500.0
2019-11-05	ACWX	ETF	48.35	48.385	48.205	48.33	746579.0
2019-11-05	ADRE	ETF	41.65	41.65	41.55	41.55	1782.0
2019-11-05	AFIF	ETF	9.69	9.7223	9.69	9.7223	1092.0
2019-11-05	AFK	ETF	20.8	21.105	20.8	20.85	25886.0
2019-11-05	AFTY	ETF	18.03	18.05	18.01	18.02	4500.0
2019-11-05	AGG	ETF	112.35	112.38	112.15	112.23	3205500.0
2019-11-05	AGGY	ETF	52.01	52.065	51.93	52.02	335200.0
2019-11-05	AGNG	ETF	22.78	22.78	22.487	22.635	2000.0
2019-11-05	AGQ	ETF	31.75	31.86	30.98	31.23	333100.0
2019-11-05	AGZ	ETF	115.76	115.76	115.6028	115.66	14819.0
2019-11-05	AGZD	ETF	24.005	24.015	23.895	23.95	39000.0
2019-11-05	AIA	ETF	63.68	63.71	63.4852	63.65	16374.0
2019-11-05	AIEQ	ETF	26.8	26.82	26.633	26.68	32500.0
2019-11-05	AIQ	ETF	16.75	16.75	16.51	16.55	16767.0
2019-11-05	AIRR	ETF	29.0	29.117	28.997	29.039	16300.0
2019-11-05	AIVI	ETF	42.14	42.16	42.08	42.14	3100.0
2019-11-05	ALTY	ETF	14.99	14.99	14.84	14.854	6200.0
2019-11-05	AMJ	ETF	22.45	22.45	21.86	22.03	1902644.0
2019-11-05	AMLP	ETF	43.95	43.95	42.8	43.0	4672320.0
2019-11-05	AMUB	ETF	13.8852	13.8852	13.8852	13.8852	1.0
2019-11-05	AMZA	ETF	46.4	46.4	45.1	45.5	69120.0
2019-11-05	ANGL	ETF	29.3	29.3	29.19	29.26	299100.0
2019-11-05	AOA	ETF	56.54	56.58	56.46	56.5	32700.0
2019-11-05	AOK	ETF	35.9	35.9	35.8	35.8	95488.0
2019-11-05	AOM	ETF	39.6	39.66	39.56	39.6	99308.0
2019-11-05	AOR	ETF	46.96	46.9716	46.885	46.89	84291.0
2019-11-05	ARGT	ETF	22.3	22.32	22.15	22.21	26900.0
2019-11-05	ARKF	ETF	22.63	22.63	22.455	22.483	7200.0
2019-11-05	ARKG	ETF	30.65	30.75	30.498	30.57	50400.0
2019-11-05	ARKK	ETF	45.62	45.92	45.36	45.39	222500.0
2019-11-05	ARKQ	ETF	34.64	34.84	34.61	34.61	13200.0
2019-11-05	ARKW	ETF	52.7	52.71	52.19	52.19	104700.0
2019-11-05	ASEA	ETF	16.32	16.32	16.21	16.22	1600.0
2019-11-05	ASET	ETF	30.27	30.315	30.24	30.315	1641.0

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

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