PREVIEW / etf_daily / 2016-12-20

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-20.parquet
  size:    54 KB
  rows:    1,356

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
2016-12-20	SPY	ETF	226.15	226.57	225.88	226.4	89838800.0
2016-12-20	QQQ	ETF	120.43	120.77	120.33	120.55	11461799.0
2016-12-20	IWM	ETF	137.28	138.21	136.99	137.96	31753600.0
2016-12-20	DIA	ETF	199.16	199.61	199.06	199.42	3062600.0
2016-12-20	GLD	ETF	107.47	108.0	107.29	107.79	7321100.0
2016-12-20	TLT	ETF	117.63	117.9	117.38	117.81	7030600.0
2016-12-20	AADR	ETF	39.12	39.47	39.12	39.37	1100.0
2016-12-20	AAXJ	ETF	55.56	55.6	55.42	55.56	1137700.0
2016-12-20	ACSI	ETF	27.48	27.57	27.48	27.54	16900.0
2016-12-20	ACTX	ETF	16.5201	17.1102	13.5701	17.1102	1172.0
2016-12-20	ACWF	ETF	24.3075	24.3075	24.3075	24.3075	509.0
2016-12-20	ACWI	ETF	59.98	60.12	59.94	60.12	2128900.0
2016-12-20	ACWV	ETF	73.7	73.73	73.55	73.69	493400.0
2016-12-20	ACWX	ETF	40.57	40.6	40.46	40.59	1821942.0
2016-12-20	ADRE	ETF	32.23	32.2352	32.11	32.23	13840.0
2016-12-20	AFK	ETF	19.09	19.57	19.09	19.26	51290.0
2016-12-20	AFTY	ETF	13.21	13.21	13.01	13.034	2900.0
2016-12-20	AGG	ETF	107.3	107.44	107.27	107.41	2871900.0
2016-12-20	AGGY	ETF	49.2	49.26	49.14	49.14	21500.0
2016-12-20	AGQ	ETF	31.05	32.87	31.05	32.79	489500.0
2016-12-20	AGZ	ETF	112.07	112.27	111.92	112.2	20634.0
2016-12-20	AGZD	ETF	24.04	24.095	24.04	24.095	4800.0
2016-12-20	AIA	ETF	47.06	47.19	47.06	47.15	57857.0
2016-12-20	AIQ	ETF	9.5	9.7	9.45	9.6	38084.0
2016-12-20	AIRR	ETF	24.18	24.3	24.11	24.3	171700.0
2016-12-20	AIVI	ETF	37.49	37.61	37.45	37.58	25400.0
2016-12-20	ALTY	ETF	14.973	15.05	14.959	14.959	3300.0
2016-12-20	AMJ	ETF	30.69	30.81	30.51	30.69	2377490.0
2016-12-20	AMLP	ETF	62.0	62.25	61.8	62.25	1669340.0
2016-12-20	AMZA	ETF	110.0	111.0	110.0	110.7	20210.0
2016-12-20	ANGL	ETF	28.95	28.96	28.87	28.93	183500.0
2016-12-20	AOA	ETF	47.8	47.8	47.61	47.74	130400.0
2016-12-20	AOK	ETF	32.59	32.59	32.43	32.55	243500.0
2016-12-20	AOM	ETF	35.37	35.51	35.34	35.38	319356.0
2016-12-20	AOR	ETF	40.71	40.83	40.71	40.8	296438.0
2016-12-20	ARGT	ETF	22.42	22.42	22.22	22.4	116500.0
2016-12-20	ARKG	ETF	17.833	17.833	17.699	17.783	2200.0
2016-12-20	ARKK	ETF	20.81	20.828	20.81	20.828	1000.0
2016-12-20	ARKQ	ETF	22.53	22.53	22.415	22.45	2700.0
2016-12-20	ARKW	ETF	25.725	25.725	25.632	25.676	11700.0
2016-12-20	ASEA	ETF	13.03	13.03	12.97	12.97	3700.0
2016-12-20	ASET	ETF	25.72	25.72	25.72	25.72	100.0
2016-12-20	ASHR	ETF	23.84	23.85	23.79	23.79	1035700.0
2016-12-20	ASHS	ETF	32.69	32.7	32.66	32.67	5100.0
2016-12-20	ASHX	ETF	21.8	21.849	21.8	21.8363	548.0
2016-12-20	ATMP	ETF	23.1	23.21	23.04	23.12	159800.0
2016-12-20	BAB	ETF	28.85	28.94	28.83	28.939	222572.0
2016-12-20	BAL	ETF	45.68	45.72	45.05	45.05	8771.0
2016-12-20	BBC	ETF	19.46	19.46	19.041	19.0844	4428.0
2016-12-20	BBH	ETF	107.41	108.57	107.41	108.33	231000.0

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

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