PREVIEW / etf_daily / 2016-01-27

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-27.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-01-27	SPY	ETF	189.58	191.56	187.06	188.13	185681700.0
2016-01-27	QQQ	ETF	102.55	102.99	100.15	100.58	54524736.0
2016-01-27	IWM	ETF	100.59	101.59	99.06	99.71	47973900.0
2016-01-27	DIA	ETF	160.57	162.23	158.61	159.3	10121900.0
2016-01-27	GLD	ETF	106.86	107.93	106.65	107.69	8273400.0
2016-01-27	TLT	ETF	125.75	126.29	125.19	126.05	7957800.0
2016-01-27	AADR	ETF	35.9	35.95	35.83	35.95	5000.0
2016-01-27	AAXJ	ETF	48.31	48.73	47.78	48.01	1213000.0
2016-01-27	ACTX	ETF	6.4901	6.4901	5.7821	6.1951	1359.0
2016-01-27	ACWI	ETF	51.76	52.32	51.22	51.47	6113800.0
2016-01-27	ACWV	ETF	66.6	67.21	66.18	66.5	194100.0
2016-01-27	ACWX	ETF	36.55	36.97	36.28	36.435	1037491.0
2016-01-27	ADRE	ETF	26.43	26.5001	26.17	26.17	3409.0
2016-01-27	AFK	ETF	15.65	15.8	15.5	15.68	16095.0
2016-01-27	AFTY	ETF	11.54	11.635	11.46	11.48	15700.0
2016-01-27	AGG	ETF	108.91	109.01	108.72	108.94	1645300.0
2016-01-27	AGGY	ETF	49.4	49.53	49.31	49.35	14800.0
2016-01-27	AGQ	ETF	29.59	29.97	29.15	29.65	208800.0
2016-01-27	AGZ	ETF	113.75	113.8	113.54	113.8	17771.0
2016-01-27	AGZD	ETF	23.77	23.79	23.7	23.7	6000.0
2016-01-27	AIA	ETF	38.05	38.33	37.7	37.79	32944.0
2016-01-27	AIQ	ETF	7.07	7.41	6.99	7.19	10064.0
2016-01-27	AIRR	ETF	14.54	14.7	14.44	14.48	7500.0
2016-01-27	AIVI	ETF	36.22	36.72	36.1	36.12	24200.0
2016-01-27	ALTY	ETF	12.94	12.94	12.94	12.94	100.0
2016-01-27	AMJ	ETF	24.38	24.81	23.57	24.31	5682547.0
2016-01-27	AMLP	ETF	49.6	50.05	47.5	49.1	2466660.0
2016-01-27	AMZA	ETF	83.5	85.0	79.9	83.6	18570.0
2016-01-27	ANGL	ETF	23.97	23.97	23.71	23.77	35900.0
2016-01-27	AOA	ETF	42.28	42.54	41.92	41.99	58500.0
2016-01-27	AOK	ETF	30.99	31.1099	30.936	30.97	38415.0
2016-01-27	AOM	ETF	33.12	33.2799	33.0212	33.04	83798.0
2016-01-27	AOR	ETF	37.09	37.3512	36.92	37.01	93098.0
2016-01-27	ARGT	ETF	16.48	16.74	16.36	16.49	9000.0
2016-01-27	ARKG	ETF	17.56	17.56	17.56	17.56	200.0
2016-01-27	ARKK	ETF	17.5	17.5	16.83	16.877	2700.0
2016-01-27	ARKQ	ETF	16.38	16.38	16.25	16.25	200.0
2016-01-27	ARKW	ETF	19.22	19.22	18.78	18.78	2200.0
2016-01-27	ASET	ETF	22.34	23.71	22.34	23.71	200.0
2016-01-27	ASHR	ETF	21.7	21.96	21.6	21.62	1544800.0
2016-01-27	ASHS	ETF	29.34	30.0	29.34	29.63	82400.0
2016-01-27	ASHX	ETF	19.84	20.02	19.7301	19.7301	11700.0
2016-01-27	ATMP	ETF	16.03	16.34	15.8	16.25	91500.0
2016-01-27	BAB	ETF	29.78	29.78	29.6	29.66	166508.0
2016-01-27	BAL	ETF	40.48	40.48	40.03	40.03	4391.0
2016-01-27	BBC	ETF	20.6	20.81	19.514	19.55	11887.0
2016-01-27	BBH	ETF	108.05	108.75	104.0	104.53	94500.0
2016-01-27	BBP	ETF	25.46	25.46	24.33	24.46	5400.0
2016-01-27	BCM	ETF	22.61	22.934	22.61	22.92	1141.0
2016-01-27	BFOR	ETF	6.85	6.8575	6.73	6.75	60800.0

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

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