PREVIEW / etf_daily / 2016-02-16

all etf daily files

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

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-16	SPY	ETF	188.77	189.81	187.63	189.78	120250700.0
2016-02-16	QQQ	ETF	99.44	100.23	98.85	100.23	40565911.0
2016-02-16	IWM	ETF	97.79	99.1	97.22	98.88	38882100.0
2016-02-16	DIA	ETF	161.76	162.29	160.62	162.2	5451200.0
2016-02-16	GLD	ETF	116.0	116.31	114.74	114.77	14601700.0
2016-02-16	TLT	ETF	130.72	130.75	129.81	130.11	11766000.0
2016-02-16	AADR	ETF	35.47	35.94	35.47	35.52	6600.0
2016-02-16	AAXJ	ETF	48.58	48.95	48.51	48.91	1871700.0
2016-02-16	ACTX	ETF	5.31	5.9001	4.72	4.72	2021.0
2016-02-16	ACWF	ETF	21.084	21.084	21.084	21.084	125.0
2016-02-16	ACWI	ETF	51.17	51.41	50.84	51.4	2141300.0
2016-02-16	ACWV	ETF	68.4	68.4	67.85	68.4	248800.0
2016-02-16	ACWX	ETF	36.02	36.18	35.8	36.16	1961682.0
2016-02-16	ADRE	ETF	26.3	26.6999	26.3	26.63	4905.0
2016-02-16	AFK	ETF	16.424	16.66	16.424	16.66	1072.0
2016-02-16	AFTY	ETF	11.94	11.972	11.89	11.972	5100.0
2016-02-16	AGG	ETF	109.54	109.61	109.43	109.5	2356200.0
2016-02-16	AGGY	ETF	49.749	49.75	49.56	49.57	6300.0
2016-02-16	AGQ	ETF	33.12	33.22	32.27	32.41	436100.0
2016-02-16	AGZ	ETF	114.53	114.9158	114.2346	114.81	26325.0
2016-02-16	AGZD	ETF	23.54	23.54	23.42	23.475	2400.0
2016-02-16	AIA	ETF	38.52	38.73	38.401	38.73	39711.0
2016-02-16	AIQ	ETF	7.3235	7.3235	6.55	6.78	12649.0
2016-02-16	AIRR	ETF	14.67	14.71	14.63	14.7	16300.0
2016-02-16	AIVI	ETF	36.09	36.2	35.78	36.19	20600.0
2016-02-16	AMJ	ETF	22.68	23.59	22.585	23.44	7399667.0
2016-02-16	AMLP	ETF	44.75	45.7	43.55	45.4	4589980.0
2016-02-16	AMZA	ETF	69.0	75.66	69.0	73.84	6830.0
2016-02-16	ANGL	ETF	23.72	23.72	23.37	23.5	52300.0
2016-02-16	AOA	ETF	41.93	42.08	41.71	42.08	70400.0
2016-02-16	AOK	ETF	31.09	31.09	30.95	31.0	46460.0
2016-02-16	AOM	ETF	33.18	33.2	33.04	33.2	51452.0
2016-02-16	AOR	ETF	37.03	37.11	36.88	37.11	59520.0
2016-02-16	ARGT	ETF	17.06	17.22	16.86	17.22	11100.0
2016-02-16	ARKG	ETF	15.92	15.92	15.92	15.92	100.0
2016-02-16	ARKK	ETF	15.55	15.55	15.55	15.55	200.0
2016-02-16	ARKQ	ETF	15.09	15.09	15.08	15.08	400.0
2016-02-16	ARKW	ETF	17.1	17.339	17.063	17.339	500.0
2016-02-16	ASEA	ETF	12.19	12.28	12.15	12.24	110300.0
2016-02-16	ASHR	ETF	22.7	23.04	22.52	23.01	4065700.0
2016-02-16	ASHS	ETF	30.94	32.28	30.94	32.06	125300.0
2016-02-16	ASHX	ETF	19.83	20.52	19.83	20.52	350.0
2016-02-16	ATMP	ETF	15.16	15.56	14.97	15.52	180600.0
2016-02-16	BAB	ETF	30.0	30.11	29.81	29.81	187198.0
2016-02-16	BAL	ETF	39.09	39.2962	38.83	38.9	2499.0
2016-02-16	BBC	ETF	17.771	18.1069	17.72	18.1069	11622.0
2016-02-16	BBH	ETF	100.64	101.51	99.99	101.34	170300.0
2016-02-16	BBP	ETF	22.85	23.16	22.77	23.16	7300.0
2016-02-16	BCM	ETF	22.95	22.95	22.8048	22.8048	759.0
2016-02-16	BFOR	ETF	6.7225	6.82	6.685	6.8075	89200.0

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

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