PREVIEW / etf_daily / 2017-05-11

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-11.parquet
  size:    54 KB
  rows:    1,380

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-11	SPY	ETF	239.35	239.57	238.13	239.38	62358300.0
2017-05-11	QQQ	ETF	138.03	138.33	137.38	138.29	27232074.0
2017-05-11	IWM	ETF	138.67	138.83	136.98	138.24	28617300.0
2017-05-11	DIA	ETF	209.14	209.45	208.1	209.28	3093700.0
2017-05-11	GLD	ETF	116.21	116.85	116.19	116.5	6274400.0
2017-05-11	TLT	ETF	120.0	120.57	119.91	120.48	7479800.0
2017-05-11	AADR	ETF	48.86	48.86	48.25	48.71	45700.0
2017-05-11	AAXJ	ETF	65.63	65.78	65.38	65.77	759400.0
2017-05-11	ACSI	ETF	28.44	28.45	28.33	28.45	710.0
2017-05-11	ACTX	ETF	70.8006	79.6507	70.8006	75.5207	458.0
2017-05-11	ACWF	ETF	26.5301	26.5301	26.5301	26.5301	390.0
2017-05-11	ACWI	ETF	64.92	64.95	64.61	64.93	2738800.0
2017-05-11	ACWV	ETF	78.31	78.42	78.15	78.42	117200.0
2017-05-11	ACWX	ETF	45.21	45.32	45.11	45.3	301026.0
2017-05-11	ADRE	ETF	38.28	38.3753	38.05	38.315	5238.0
2017-05-11	AFK	ETF	21.41	21.49	21.31	21.49	5397.0
2017-05-11	AFTY	ETF	13.63	13.685	13.63	13.66	2000.0
2017-05-11	AGG	ETF	108.35	108.54	108.34	108.52	2331000.0
2017-05-11	AGGY	ETF	49.96	50.04	49.86	50.04	10400.0
2017-05-11	AGNG	ETF	17.74	17.77	17.74	17.74	300.0
2017-05-11	AGQ	ETF	32.59	32.97	32.5	32.9	245800.0
2017-05-11	AGZ	ETF	113.05	113.13	112.92	113.1	12154.0
2017-05-11	AGZD	ETF	23.955	24.03	23.955	24.005	8800.0
2017-05-11	AIA	ETF	55.14	55.35	55.02	55.35	18695.0
2017-05-11	AIQ	ETF	13.15	13.2	13.1	13.15	12737.0
2017-05-11	AIRR	ETF	24.12	24.12	23.735	24.06	32600.0
2017-05-11	AIVI	ETF	40.29	40.4	40.26	40.37	7000.0
2017-05-11	ALTY	ETF	15.32	15.4	15.25	15.334	2700.0
2017-05-11	AMJ	ETF	31.54	31.54	31.27	31.29	1607073.0
2017-05-11	AMLP	ETF	61.4	61.5	61.0	61.2	1548880.0
2017-05-11	AMZA	ETF	105.0	105.05	103.9	104.0	49880.0
2017-05-11	ANGL	ETF	29.54	29.59	29.48	29.57	169200.0
2017-05-11	AOA	ETF	50.93	50.94	50.73	50.94	61900.0
2017-05-11	AOK	ETF	33.55	33.6199	33.5101	33.58	91441.0
2017-05-11	AOM	ETF	36.75	36.79	36.652	36.73	114114.0
2017-05-11	AOR	ETF	42.99	43.0288	42.8605	42.99	65504.0
2017-05-11	ARCM	ETF	100.0	100.0	100.0	100.0	2000.0
2017-05-11	ARGT	ETF	30.16	30.27	30.07	30.21	39100.0
2017-05-11	ARKG	ETF	19.96	20.012	19.96	20.012	1000.0
2017-05-11	ARKK	ETF	26.5	26.67	26.298	26.569	36700.0
2017-05-11	ARKQ	ETF	27.89	28.34	27.78	28.318	21600.0
2017-05-11	ARKW	ETF	31.91	32.04	31.699	31.95	11200.0
2017-05-11	ASEA	ETF	14.89	14.89	14.73	14.74	12800.0
2017-05-11	ASET	ETF	26.8263	26.84	26.8263	26.84	316.0
2017-05-11	ASHR	ETF	24.16	24.18	24.1	24.14	1016200.0
2017-05-11	ASHS	ETF	30.66	30.71	30.6	30.7	8900.0
2017-05-11	ASHX	ETF	18.81	18.81	18.8	18.8	3550.0
2017-05-11	ATMP	ETF	23.09	23.17	23.03	23.07	49100.0
2017-05-11	BAB	ETF	29.3	29.45	29.3	29.44	138371.0
2017-05-11	BAL	ETF	48.48	50.4404	48.48	50.39	20543.0

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

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