PREVIEW / etf_daily / 2016-01-04

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-04.parquet
  size:    50 KB
  rows:    1,254

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-04	SPY	ETF	200.49	201.03	198.59	201.02	222353500.0
2016-01-04	QQQ	ETF	109.43	109.6	108.12	109.5	50807643.0
2016-01-04	IWM	ETF	110.61	110.83	109.08	110.01	66665900.0
2016-01-04	DIA	ETF	171.05	171.32	169.35	171.29	14350800.0
2016-01-04	GLD	ETF	103.13	103.67	102.49	102.89	6440000.0
2016-01-04	TLT	ETF	121.93	122.45	121.32	121.45	10591900.0
2016-01-04	AADR	ETF	40.44	40.44	37.56	37.71	3900.0
2016-01-04	AAXJ	ETF	51.96	51.99	51.5	51.85	1926600.0
2016-01-04	ACTX	ETF	7.6701	7.6701	6.4901	7.6701	711.0
2016-01-04	ACWF	ETF	22.8294	22.8294	22.8294	22.8294	240.0
2016-01-04	ACWI	ETF	54.83	54.9	54.28	54.83	5145600.0
2016-01-04	ACWV	ETF	68.12	68.33	67.78	68.33	196000.0
2016-01-04	ACWX	ETF	38.86	38.86	38.44	38.85	2271247.0
2016-01-04	ADRE	ETF	28.22	28.2399	27.968	28.1653	12770.0
2016-01-04	AFK	ETF	17.75	17.75	17.4378	17.64	59060.0
2016-01-04	AFTY	ETF	13.06	13.54	13.01	13.13	43800.0
2016-01-04	AGG	ETF	108.09	108.29	107.93	107.97	3691000.0
2016-01-04	AGQ	ETF	28.28	28.48	27.14	27.15	201100.0
2016-01-04	AGZ	ETF	112.94	113.39	112.7701	113.16	33252.0
2016-01-04	AGZD	ETF	24.0	24.005	23.965	24.005	46800.0
2016-01-04	AIA	ETF	41.05	41.14	40.72	41.07	51186.0
2016-01-04	AIQ	ETF	9.03	9.28	8.15	8.71	22279.0
2016-01-04	AIRR	ETF	15.981	16.16	15.981	16.16	1700.0
2016-01-04	AIVI	ETF	37.51	38.81	37.08	37.46	9500.0
2016-01-04	ALTY	ETF	14.02	15.14	13.38	13.71	1300.0
2016-01-04	AMJ	ETF	28.86	29.46	28.585	29.35	7156306.0
2016-01-04	AMLP	ETF	59.5	60.9	59.0	60.8	4273940.0
2016-01-04	AMZA	ETF	112.0	114.0	109.0	113.9	3760.0
2016-01-04	ANGL	ETF	24.3	24.41	24.11	24.32	35300.0
2016-01-04	AOA	ETF	44.4	44.8	43.91	44.32	850300.0
2016-01-04	AOK	ETF	31.35	31.5499	31.35	31.47	153127.0
2016-01-04	AOM	ETF	33.76	34.07	33.72	33.89	570495.0
2016-01-04	AOR	ETF	38.5	38.66	38.26	38.47	1158972.0
2016-01-04	ARGT	ETF	17.91	17.97	17.52	17.8	62100.0
2016-01-04	ARKG	ETF	20.076	20.132	20.076	20.13	600.0
2016-01-04	ARKK	ETF	19.98	20.02	19.86	20.01	1600.0
2016-01-04	ARKQ	ETF	18.69	18.843	18.66	18.8	3900.0
2016-01-04	ARKW	ETF	22.94	22.94	22.403	22.43	2900.0
2016-01-04	ASEA	ETF	12.0	12.0	11.8	11.83	23900.0
2016-01-04	ASET	ETF	23.96	23.96	23.91	23.92	307.0
2016-01-04	ASHR	ETF	25.67	25.85	25.24	25.6	3871100.0
2016-01-04	ASHS	ETF	39.39	39.39	36.96	37.35	267800.0
2016-01-04	ASHX	ETF	24.25	24.25	23.0	23.13	5490.0
2016-01-04	ATMP	ETF	18.51	19.13	18.51	19.13	31500.0
2016-01-04	BAB	ETF	29.11	29.22	29.11	29.12	83976.0
2016-01-04	BAL	ETF	42.05	42.05	41.56	41.61	6058.0
2016-01-04	BBC	ETF	28.53	28.53	27.42	27.6984	8071.0
2016-01-04	BBH	ETF	124.64	124.64	122.52	123.65	137800.0
2016-01-04	BBP	ETF	30.09	30.36	29.596	29.77	5700.0
2016-01-04	BCM	ETF	23.81	23.81	23.81	23.81	846.0

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

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