PREVIEW / etf_daily / 2016-02-10

all etf daily files

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

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-10	SPY	ETF	186.41	188.34	185.12	185.27	148214100.0
2016-02-10	QQQ	ETF	97.5	98.69	96.62	96.69	59421699.0
2016-02-10	IWM	ETF	96.45	97.92	95.68	95.83	42756100.0
2016-02-10	DIA	ETF	160.98	162.3	159.23	159.39	8205700.0
2016-02-10	GLD	ETF	113.92	114.52	112.98	114.46	13311100.0
2016-02-10	TLT	ETF	131.7	132.84	131.11	132.79	12797100.0
2016-02-10	AADR	ETF	35.05	35.05	34.86	34.89	1100.0
2016-02-10	AAXJ	ETF	48.13	48.58	47.7	47.76	723800.0
2016-02-10	ACTX	ETF	5.31	5.31	4.72	4.72	1018.0
2016-02-10	ACWF	ETF	20.76	20.79	20.71	20.78	2336.0
2016-02-10	ACWI	ETF	50.47	50.94	50.13	50.19	2798100.0
2016-02-10	ACWV	ETF	67.5	67.75	67.2	67.29	127600.0
2016-02-10	ACWX	ETF	35.58	35.83	35.32	35.36	2032893.0
2016-02-10	ADRE	ETF	25.67	25.97	25.67	25.8501	3996.0
2016-02-10	AFK	ETF	16.3	16.3	16.2911	16.2911	1857.0
2016-02-10	AFTY	ETF	11.502	11.502	11.502	11.502	100.0
2016-02-10	AGG	ETF	109.82	110.0	109.6	110.0	2319000.0
2016-02-10	AGGY	ETF	49.74	49.958	49.74	49.815	15200.0
2016-02-10	AGQ	ETF	32.48	32.76	31.86	32.73	146100.0
2016-02-10	AGZ	ETF	114.74	115.06	114.54	115.06	22319.0
2016-02-10	AGZD	ETF	23.46	23.53	23.455	23.53	4400.0
2016-02-10	AIA	ETF	37.75	38.17	37.52	37.56	44061.0
2016-02-10	AIQ	ETF	6.68	6.92	6.4	6.57	10619.0
2016-02-10	AIRR	ETF	14.49	14.499	14.356	14.356	4600.0
2016-02-10	AIVI	ETF	35.4	35.51	35.21	35.21	14000.0
2016-02-10	AMJ	ETF	21.78	22.35	21.18	21.84	4159062.0
2016-02-10	AMLP	ETF	41.75	43.15	40.75	42.0	2686720.0
2016-02-10	AMZA	ETF	65.0	71.87	64.8	66.1	3820.0
2016-02-10	ANGL	ETF	23.61	23.61	23.4	23.46	38700.0
2016-02-10	AOA	ETF	41.68	41.85	41.32	41.35	33900.0
2016-02-10	AOK	ETF	30.97	31.0399	30.89	30.96	115406.0
2016-02-10	AOM	ETF	33.12	33.17	32.91	32.92	44291.0
2016-02-10	AOR	ETF	36.83	36.9154	36.63	36.66	53629.0
2016-02-10	ARGT	ETF	16.53	16.73	16.52	16.73	2200.0
2016-02-10	ARKG	ETF	15.765	15.765	15.765	15.765	100.0
2016-02-10	ARKK	ETF	15.055	15.055	15.055	15.055	100.0
2016-02-10	ARKQ	ETF	14.78	14.78	14.78	14.78	200.0
2016-02-10	ARKW	ETF	16.6	16.653	16.45	16.653	700.0
2016-02-10	ASEA	ETF	12.13	12.13	12.04	12.08	1500.0
2016-02-10	ASHR	ETF	21.36	21.74	21.36	21.57	723200.0
2016-02-10	ASHS	ETF	30.04	30.41	30.02	30.04	20300.0
2016-02-10	ATMP	ETF	14.34	14.59	13.93	14.37	92400.0
2016-02-10	BAB	ETF	30.36	30.44	30.27	30.44	148421.0
2016-02-10	BAL	ETF	38.577	38.808	38.56	38.74	6070.0
2016-02-10	BBC	ETF	16.95	17.581	16.62	16.62	4692.0
2016-02-10	BBH	ETF	96.83	99.75	96.74	97.14	116600.0
2016-02-10	BBP	ETF	22.45	22.892	22.08	22.08	5400.0
2016-02-10	BCM	ETF	22.385	22.48	22.381	22.45	1240.0
2016-02-10	BFOR	ETF	6.6125	6.6825	6.5825	6.595	103600.0
2016-02-10	BIB	ETF	37.84	40.45	37.84	38.13	988844.0

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

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