PREVIEW / etf_daily / 2017-02-16

all etf daily files

  file:    by_date/etf_daily/2017/2017-02-16.parquet
  size:    54 KB
  rows:    1,364

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
2017-02-16	SPY	ETF	234.95	235.16	233.85	234.72	84722400.0
2017-02-16	QQQ	ETF	129.36	129.63	128.92	129.25	15098286.0
2017-02-16	IWM	ETF	139.46	139.84	138.21	139.2	24613600.0
2017-02-16	DIA	ETF	206.55	206.72	205.85	206.48	4589600.0
2017-02-16	GLD	ETF	117.93	118.35	117.83	118.08	6378700.0
2017-02-16	TLT	ETF	119.22	120.21	119.12	119.61	10005800.0
2017-02-16	AADR	ETF	46.0	46.0	45.69	45.78	8000.0
2017-02-16	AAXJ	ETF	60.82	60.82	60.6	60.7	1014700.0
2017-02-16	ACSI	ETF	27.92	27.92	27.85	27.85	6593.0
2017-02-16	ACTX	ETF	133.4592	141.6013	124.3141	125.0811	2997.0
2017-02-16	ACWF	ETF	25.46	25.4601	25.46	25.46	2985.0
2017-02-16	ACWI	ETF	62.49	62.54	62.28	62.46	2579400.0
2017-02-16	ACWV	ETF	75.34	75.48	75.23	75.48	2745600.0
2017-02-16	ACWX	ETF	42.7	42.74	42.63	42.72	537812.0
2017-02-16	ADRE	ETF	36.49	36.49	36.26	36.3	3993.0
2017-02-16	AFK	ETF	21.81	22.17	21.6874	21.69	4981.0
2017-02-16	AFTY	ETF	14.03	14.03	13.97	13.995	2200.0
2017-02-16	AGG	ETF	108.01	108.28	108.01	108.12	5257400.0
2017-02-16	AGGY	ETF	49.57	49.79	49.57	49.63	6400.0
2017-02-16	AGQ	ETF	40.87	41.27	40.82	41.09	100700.0
2017-02-16	AGZ	ETF	112.6	112.755	112.6	112.68	49034.0
2017-02-16	AGZD	ETF	24.09	24.155	24.025	24.025	5400.0
2017-02-16	AIA	ETF	50.99	51.01	50.87	50.92	39101.0
2017-02-16	AIQ	ETF	10.4	10.4	10.3	10.35	4698.0
2017-02-16	AIRR	ETF	24.39	24.432	24.17	24.31	45000.0
2017-02-16	AIVI	ETF	38.9	38.96	38.83	38.93	14700.0
2017-02-16	ALTY	ETF	15.75	15.75	15.44	15.56	31100.0
2017-02-16	AMJ	ETF	34.32	34.41	33.93	33.96	1661459.0
2017-02-16	AMLP	ETF	65.8	66.2	65.1	65.25	1565480.0
2017-02-16	AMZA	ETF	114.6	114.71	113.1	113.1	47580.0
2017-02-16	ANGL	ETF	29.47	29.49	29.41	29.44	227600.0
2017-02-16	AOA	ETF	49.31	49.31	49.15	49.19	56700.0
2017-02-16	AOK	ETF	32.97	33.05	32.97	33.03	91723.0
2017-02-16	AOM	ETF	35.97	36.06	35.96	36.06	54998.0
2017-02-16	AOR	ETF	41.89	41.89	41.7996	41.87	117409.0
2017-02-16	ARGT	ETF	27.14	27.15	26.79	26.81	104000.0
2017-02-16	ARKG	ETF	19.22	19.22	19.0	19.07	3500.0
2017-02-16	ARKK	ETF	23.09	23.09	22.929	22.98	2700.0
2017-02-16	ARKQ	ETF	24.7	24.7	24.266	24.33	20400.0
2017-02-16	ARKW	ETF	28.65	28.65	28.26	28.305	6000.0
2017-02-16	ASEA	ETF	13.58	13.58	13.51	13.57	10500.0
2017-02-16	ASET	ETF	26.23	26.25	26.2	26.25	3148.0
2017-02-16	ASHR	ETF	25.06	25.16	25.05	25.16	1228800.0
2017-02-16	ASHS	ETF	33.65	33.75	33.64	33.73	4800.0
2017-02-16	ASHX	ETF	19.48	19.48	19.4797	19.4797	1100.0
2017-02-16	ATMP	ETF	25.06	25.1	24.56	24.61	22600.0
2017-02-16	BAB	ETF	29.29	29.41	29.29	29.33	195641.0
2017-02-16	BAL	ETF	50.12	50.12	49.89	49.905	9819.0
2017-02-16	BBC	ETF	21.29	21.54	21.2315	21.33	2868.0
2017-02-16	BBH	ETF	120.36	120.4	118.31	119.08	45400.0

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

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