PREVIEW / etf_daily / 2017-05-04

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-04.parquet
  size:    55 KB
  rows:    1,396

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
2017-05-04	SPY	ETF	238.83	238.92	237.78	238.76	61462700.0
2017-05-04	QQQ	ETF	137.01	137.43	136.56	137.04	14630063.0
2017-05-04	IWM	ETF	138.53	138.73	137.11	138.1	25799100.0
2017-05-04	DIA	ETF	209.65	209.65	208.2	209.19	2640100.0
2017-05-04	GLD	ETF	116.81	117.28	116.63	116.79	12406900.0
2017-05-04	TLT	ETF	121.01	121.22	120.67	121.18	9707200.0
2017-05-04	AADR	ETF	48.2	48.2	47.13	47.37	20500.0
2017-05-04	AAXJ	ETF	64.58	64.61	64.14	64.15	4544800.0
2017-05-04	ACSI	ETF	28.4473	28.45	28.4473	28.45	267.0
2017-05-04	ACTX	ETF	80.4767	87.9108	76.7007	80.8307	436.0
2017-05-04	ACWF	ETF	26.28	26.28	26.28	26.28	100.0
2017-05-04	ACWI	ETF	64.52	64.61	64.4	64.59	703200.0
2017-05-04	ACWV	ETF	77.84	78.17	77.81	78.17	120900.0
2017-05-04	ACWX	ETF	44.86	44.97	44.76	44.96	551348.0
2017-05-04	ADRE	ETF	36.93	37.0185	36.82	36.82	2424.0
2017-05-04	AFK	ETF	21.26	21.26	20.7501	20.81	13988.0
2017-05-04	AFTY	ETF	13.534	13.534	13.534	13.534	500.0
2017-05-04	AGG	ETF	108.55	108.7	108.55	108.68	1897900.0
2017-05-04	AGGY	ETF	50.03	50.06	49.96	50.06	7800.0
2017-05-04	AGNG	ETF	17.693	17.693	17.693	17.693	300.0
2017-05-04	AGQ	ETF	33.0	33.42	32.5	32.83	248800.0
2017-05-04	AGZ	ETF	113.01	113.236	113.01	113.19	9445.0
2017-05-04	AGZD	ETF	23.975	24.065	23.975	24.065	1800.0
2017-05-04	AIA	ETF	54.26	54.26	54.0368	54.07	33971.0
2017-05-04	AIQ	ETF	13.121	13.15	13.1	13.1	7986.0
2017-05-04	AIRR	ETF	24.25	24.27	23.94	24.09	26400.0
2017-05-04	AIVI	ETF	40.14	40.37	40.07	40.37	8400.0
2017-05-04	ALTY	ETF	15.39	15.48	15.33	15.48	9800.0
2017-05-04	AMJ	ETF	31.38	31.4481	30.34	30.6	2936444.0
2017-05-04	AMLP	ETF	62.35	62.5	60.9	61.2	2987520.0
2017-05-04	AMZA	ETF	103.7	103.9	99.3	100.9	143490.0
2017-05-04	ANGL	ETF	29.59	29.59	29.33	29.37	308800.0
2017-05-04	AOA	ETF	50.78	50.79	50.66	50.75	32400.0
2017-05-04	AOK	ETF	33.6	33.6	33.492	33.59	83551.0
2017-05-04	AOM	ETF	36.73	36.75	36.58	36.75	61751.0
2017-05-04	AOR	ETF	42.91	42.94	42.8096	42.85	96384.0
2017-05-04	ARCM	ETF	100.0	100.0	100.0	100.0	3000.0
2017-05-04	ARGT	ETF	29.09	29.09	28.77	28.83	41900.0
2017-05-04	ARKG	ETF	20.37	20.49	20.26	20.49	5000.0
2017-05-04	ARKK	ETF	25.74	25.74	25.402	25.5	13300.0
2017-05-04	ARKQ	ETF	26.74	26.77	26.4	26.51	20200.0
2017-05-04	ARKW	ETF	30.69	30.77	30.56	30.605	9700.0
2017-05-04	ASET	ETF	26.6765	26.6765	26.6765	26.6765	132.0
2017-05-04	ASHR	ETF	24.67	24.67	24.5	24.5	503400.0
2017-05-04	ASHS	ETF	32.3	32.35	32.26	32.26	4600.0
2017-05-04	ASHX	ETF	19.13	19.13	19.05	19.05	1330.0
2017-05-04	ATMP	ETF	22.99	22.99	22.52	22.53	24600.0
2017-05-04	BAB	ETF	29.4	29.44	29.33	29.41	84973.0
2017-05-04	BAL	ETF	50.34	50.4835	50.293	50.293	6397.0
2017-05-04	BBC	ETF	22.14	22.14	21.822	22.0399	4675.0

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

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