PREVIEW / etf_daily / 2016-02-05

all etf daily files

  file:    by_date/etf_daily/2016/2016-02-05.parquet
  size:    49 KB
  rows:    1,226

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-05	SPY	ETF	190.99	191.67	187.2	187.95	180788300.0
2016-02-05	QQQ	ETF	101.29	101.33	97.72	98.12	70749932.0
2016-02-05	IWM	ETF	100.35	100.44	97.96	98.04	53366600.0
2016-02-05	DIA	ETF	163.87	164.01	161.22	161.94	8292500.0
2016-02-05	GLD	ETF	109.79	112.35	109.58	112.32	14777300.0
2016-02-05	TLT	ETF	127.89	129.0	127.59	128.72	9200800.0
2016-02-05	AADR	ETF	35.82	35.96	35.82	35.9	4900.0
2016-02-05	AAXJ	ETF	49.09	49.23	48.46	48.65	922900.0
2016-02-05	ACTX	ETF	5.9001	5.9001	4.72	4.956	742.0
2016-02-05	ACWI	ETF	52.04	52.07	51.15	51.32	2892000.0
2016-02-05	ACWV	ETF	68.2	68.2	67.52	67.68	95000.0
2016-02-05	ACWX	ETF	36.81	36.85	36.33	36.47	1885856.0
2016-02-05	ADRE	ETF	26.91	26.91	26.57	26.586	3984.0
2016-02-05	AFK	ETF	16.87	16.93	16.66	16.69	13300.0
2016-02-05	AFTY	ETF	11.7	11.7	11.7	11.7	1100.0
2016-02-05	AGG	ETF	109.24	109.44	109.15	109.32	2155500.0
2016-02-05	AGGY	ETF	49.5	49.74	49.5	49.58	8200.0
2016-02-05	AGQ	ETF	30.31	31.86	30.07	31.82	261700.0
2016-02-05	AGZ	ETF	114.15	114.3271	114.03	114.27	24505.0
2016-02-05	AGZD	ETF	23.6	23.63	23.515	23.63	8200.0
2016-02-05	AIA	ETF	38.61	38.71	38.05	38.18	48948.0
2016-02-05	AIQ	ETF	7.26	7.26	6.8	6.8	24761.0
2016-02-05	AIRR	ETF	14.94	14.97	14.75	14.77	33400.0
2016-02-05	AIVI	ETF	36.63	36.63	36.22	36.29	21100.0
2016-02-05	AMJ	ETF	25.35	25.43	24.3	24.53	3352093.0
2016-02-05	AMLP	ETF	50.5	51.5	49.2	49.85	2447880.0
2016-02-05	AMZA	ETF	80.6	83.23	79.25	80.4	9630.0
2016-02-05	ANGL	ETF	23.79	23.79	23.6	23.62	38600.0
2016-02-05	AOA	ETF	42.54	42.54	41.87	42.01	39600.0
2016-02-05	AOK	ETF	31.1	31.1	30.9715	31.01	24135.0
2016-02-05	AOM	ETF	33.33	33.33	33.07	33.14	171520.0
2016-02-05	AOR	ETF	37.36	37.3699	36.9601	37.06	121501.0
2016-02-05	ARGT	ETF	17.24	17.24	17.04	17.13	15300.0
2016-02-05	ARKG	ETF	16.02	16.02	16.02	16.02	200.0
2016-02-05	ARKK	ETF	15.75	15.76	15.5	15.5	3000.0
2016-02-05	ARKQ	ETF	15.52	15.52	15.22	15.22	500.0
2016-02-05	ARKW	ETF	18.74	18.74	17.16	17.16	2900.0
2016-02-05	ASEA	ETF	12.09	12.09	11.99	12.04	4800.0
2016-02-05	ASHR	ETF	22.07	22.07	21.61	21.64	1330400.0
2016-02-05	ASHS	ETF	30.44	30.52	30.06	30.12	24200.0
2016-02-05	ATMP	ETF	16.72	16.79	16.07	16.26	71100.0
2016-02-05	BAB	ETF	29.88	30.0212	29.86	30.02	141556.0
2016-02-05	BAL	ETF	40.04	40.04	39.63	39.63	5342.0
2016-02-05	BBC	ETF	18.41	18.41	17.975	18.0	4748.0
2016-02-05	BBH	ETF	100.48	100.81	96.37	97.91	237600.0
2016-02-05	BBP	ETF	24.0	24.0	23.116	23.16	3400.0
2016-02-05	BCM	ETF	23.09	23.15	23.03	23.03	700.0
2016-02-05	BFOR	ETF	6.8125	6.8125	6.7	6.7	49200.0
2016-02-05	BIB	ETF	42.43	42.92	39.1	40.16	974364.0
2016-02-05	BICK	ETF	17.18	17.18	17.18	17.18	100.0

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

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