PREVIEW / etf_daily / 2016-02-04

all etf daily files

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

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-04	SPY	ETF	190.71	192.75	189.96	191.6	139531800.0
2016-02-04	QQQ	ETF	101.35	102.455	100.44	101.65	49321638.0
2016-02-04	IWM	ETF	100.0	101.97	99.97	100.8	51188400.0
2016-02-04	DIA	ETF	162.82	164.8	162.58	164.14	11715800.0
2016-02-04	GLD	ETF	110.45	110.7	109.92	110.57	13213700.0
2016-02-04	TLT	ETF	128.22	128.59	127.51	128.57	9953500.0
2016-02-04	AADR	ETF	36.27	36.27	36.14	36.14	700.0
2016-02-04	AAXJ	ETF	49.11	49.59	48.79	49.04	1453000.0
2016-02-04	ACTX	ETF	5.31	5.31	4.72	4.72	33.0
2016-02-04	ACWF	ETF	21.35	21.5	21.31	21.5	1488.0
2016-02-04	ACWI	ETF	51.95	52.52	51.82	52.19	2635700.0
2016-02-04	ACWV	ETF	68.43	68.61	68.11	68.36	82900.0
2016-02-04	ACWX	ETF	36.81	37.16	36.7135	36.94	1230799.0
2016-02-04	ADRE	ETF	26.63	27.0	26.63	26.9193	11601.0
2016-02-04	AFK	ETF	16.59	16.83	16.59	16.75	24215.0
2016-02-04	AFTY	ETF	11.72	11.8	11.72	11.8	10900.0
2016-02-04	AGG	ETF	109.34	109.46	109.24	109.42	1880300.0
2016-02-04	AGGY	ETF	49.65	49.768	49.54	49.768	2700.0
2016-02-04	AGQ	ETF	31.03	31.21	30.65	31.1	344500.0
2016-02-04	AGZ	ETF	114.29	114.3109	114.1	114.22	28018.0
2016-02-04	AIA	ETF	38.46	38.88	38.28	38.43	44524.0
2016-02-04	AIQ	ETF	7.05	7.6	7.05	7.26	20468.0
2016-02-04	AIRR	ETF	15.17	15.17	14.99	14.99	3600.0
2016-02-04	AIVI	ETF	36.49	36.82	36.48	36.72	24800.0
2016-02-04	AMJ	ETF	24.93	25.55	24.56	25.24	2913798.0
2016-02-04	AMLP	ETF	50.6	51.75	49.55	51.2	2493260.0
2016-02-04	AMZA	ETF	79.7	84.0	79.7	82.5	2470.0
2016-02-04	ANGL	ETF	23.8	23.8	23.65	23.66	54000.0
2016-02-04	AOA	ETF	42.46	42.74	42.33	42.54	45000.0
2016-02-04	AOK	ETF	31.13	31.22	31.0955	31.14	49178.0
2016-02-04	AOM	ETF	33.27	33.45	33.27	33.38	79725.0
2016-02-04	AOR	ETF	37.35	37.56	37.3	37.45	96712.0
2016-02-04	ARGT	ETF	16.98	17.3	16.83	17.24	36900.0
2016-02-04	ARKG	ETF	16.84	16.84	16.53	16.53	400.0
2016-02-04	ARKK	ETF	16.55	16.615	16.51	16.52	2300.0
2016-02-04	ARKQ	ETF	16.07	16.07	16.07	16.07	200.0
2016-02-04	ARKW	ETF	18.84	18.84	18.84	18.84	1100.0
2016-02-04	ASEA	ETF	12.02	12.02	12.02	12.02	300.0
2016-02-04	ASHR	ETF	22.24	22.5	22.19	22.34	1922000.0
2016-02-04	ASHS	ETF	30.73	31.06	30.62	30.96	63400.0
2016-02-04	ASHX	ETF	20.19	20.19	20.19	20.19	1000.0
2016-02-04	ATMP	ETF	16.33	16.92	16.31	16.63	72200.0
2016-02-04	BAB	ETF	30.03	30.03	29.92	30.0	114266.0
2016-02-04	BAL	ETF	40.52	40.52	39.75	39.899	12282.0
2016-02-04	BBC	ETF	18.75	19.5454	18.699	18.811	4201.0
2016-02-04	BBH	ETF	100.21	103.32	99.6	101.0	198400.0
2016-02-04	BBP	ETF	23.56	24.72	23.56	23.994	12100.0
2016-02-04	BCM	ETF	23.47	23.47	23.21	23.21	866.0
2016-02-04	BFOR	ETF	6.81	6.865	6.81	6.86	26800.0
2016-02-04	BIB	ETF	42.38	45.18	41.45	42.94	1135552.0

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

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