PREVIEW / etf_daily / 2016-02-08

all etf daily files

  file:    by_date/etf_daily/2016/2016-02-08.parquet
  size:    50 KB
  rows:    1,247

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-02-08	SPY	ETF	185.77	186.12	182.8	185.42	191526700.0
2016-02-08	QQQ	ETF	96.33	97.05	94.84	96.62	91673063.0
2016-02-08	IWM	ETF	97.01	97.01	94.94	96.43	61107700.0
2016-02-08	DIA	ETF	160.11	160.81	158.05	160.35	13377600.0
2016-02-08	GLD	ETF	113.67	114.87	113.39	113.83	28341200.0
2016-02-08	TLT	ETF	129.72	131.63	129.68	131.49	14452200.0
2016-02-08	AADR	ETF	35.07	35.37	34.96	35.37	5700.0
2016-02-08	AAXJ	ETF	48.09	48.23	47.48	48.02	1332300.0
2016-02-08	ACTX	ETF	5.31	5.31	4.72	4.72	1062.0
2016-02-08	ACWF	ETF	20.65	21.0695	20.43	20.49	9203.0
2016-02-08	ACWI	ETF	50.75	50.75	49.91	50.48	2561100.0
2016-02-08	ACWV	ETF	67.22	67.63	66.89	67.51	146100.0
2016-02-08	ACWX	ETF	35.9	35.9	35.46	35.79	2084173.0
2016-02-08	ADRE	ETF	25.91	25.91	25.6422	25.85	3225.0
2016-02-08	AFK	ETF	16.63	16.67	16.49	16.56	11129.0
2016-02-08	AFTY	ETF	11.44	11.5	11.34	11.36	4700.0
2016-02-08	AGG	ETF	109.59	109.87	109.5	109.74	2818600.0
2016-02-08	AGGY	ETF	49.81	49.98	49.8	49.85	18500.0
2016-02-08	AGQ	ETF	32.49	33.49	32.43	32.95	380900.0
2016-02-08	AGZ	ETF	114.46	114.86	114.29	114.56	20144.0
2016-02-08	AGZD	ETF	23.565	23.605	23.5	23.56	28800.0
2016-02-08	AIA	ETF	37.64	37.84	37.25	37.73	59424.0
2016-02-08	AIQ	ETF	6.72	7.06	6.46	6.75	27750.0
2016-02-08	AIRR	ETF	14.35	14.36	14.34	14.36	1200.0
2016-02-08	AIVI	ETF	35.62	35.78	35.4	35.7	14600.0
2016-02-08	ALTY	ETF	12.91	13.1	12.91	12.94	12200.0
2016-02-08	AMJ	ETF	23.88	23.93	22.23	22.55	6486079.0
2016-02-08	AMLP	ETF	46.75	47.65	44.85	44.95	3954680.0
2016-02-08	AMZA	ETF	79.0	79.1	67.5	70.0	19790.0
2016-02-08	ANGL	ETF	23.64	23.67	23.54	23.63	45300.0
2016-02-08	AOA	ETF	41.62	42.01	41.18	41.53	135900.0
2016-02-08	AOK	ETF	30.86	30.97	30.85	30.97	63511.0
2016-02-08	AOM	ETF	32.98	33.05	32.85	32.99	161026.0
2016-02-08	AOR	ETF	36.69	36.8489	36.51	36.78	210051.0
2016-02-08	ARGT	ETF	17.11	17.11	16.64	16.88	31800.0
2016-02-08	ARKG	ETF	16.05	16.05	15.42	15.42	500.0
2016-02-08	ARKK	ETF	14.98	15.05	14.671	14.8	3200.0
2016-02-08	ARKQ	ETF	15.2	15.2	14.62	14.62	1400.0
2016-02-08	ARKW	ETF	17.15	17.15	16.18	16.18	1500.0
2016-02-08	ASEA	ETF	11.84	11.84	11.84	11.84	200.0
2016-02-08	ASHR	ETF	21.41	21.65	21.31	21.44	830800.0
2016-02-08	ASHS	ETF	30.02	30.03	29.72	29.9	20100.0
2016-02-08	ATMP	ETF	15.95	15.95	14.29	14.6	65900.0
2016-02-08	BAB	ETF	30.21	30.3	30.085	30.29	201474.0
2016-02-08	BAL	ETF	39.475	39.475	38.9205	39.3145	3921.0
2016-02-08	BBC	ETF	17.11	17.38	16.416	16.7338	18533.0
2016-02-08	BBH	ETF	94.93	96.6	94.21	95.56	183000.0
2016-02-08	BBP	ETF	22.69	22.69	21.896	22.35	14800.0
2016-02-08	BCM	ETF	23.11	23.14	23.11	23.14	500.0
2016-02-08	BFOR	ETF	6.625	6.6275	6.525	6.6	89200.0

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

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