PREVIEW / etf_daily / 2016-02-26

all etf daily files

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

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-26	SPY	ETF	196.57	196.68	194.9	195.09	129833700.0
2016-02-26	QQQ	ETF	104.28	104.3659	103.1835	103.43	30925045.0
2016-02-26	IWM	ETF	103.06	103.47	102.7	103.19	27474700.0
2016-02-26	DIA	ETF	167.84	167.95	166.12	166.28	3798000.0
2016-02-26	GLD	ETF	117.43	117.72	115.86	117.11	12505100.0
2016-02-26	TLT	ETF	130.31	130.81	130.04	130.41	9245000.0
2016-02-26	AADR	ETF	36.09	36.26	36.02	36.13	45600.0
2016-02-26	AAXJ	ETF	49.54	49.66	49.05	49.09	371200.0
2016-02-26	ACTX	ETF	4.13	4.72	4.13	4.13	691.0
2016-02-26	ACWI	ETF	52.89	52.94	52.4	52.48	1597600.0
2016-02-26	ACWV	ETF	70.55	70.55	69.77	69.79	511200.0
2016-02-26	ACWX	ETF	36.98	37.0	36.575	36.64	1415666.0
2016-02-26	ADRE	ETF	27.37	27.3984	27.194	27.2	6898.0
2016-02-26	AFK	ETF	16.99	17.03	16.99	17.03	657.0
2016-02-26	AFTY	ETF	11.819	11.82	11.76	11.76	1600.0
2016-02-26	AGG	ETF	109.9	109.97	109.8	109.96	2068100.0
2016-02-26	AGGY	ETF	49.693	49.79	49.688	49.79	10600.0
2016-02-26	AGQ	ETF	31.59	31.6	30.02	30.2	343100.0
2016-02-26	AGZ	ETF	114.422	114.6	114.4	114.48	13037.0
2016-02-26	AGZD	ETF	23.55	23.55	23.55	23.55	200.0
2016-02-26	AIA	ETF	39.39	39.39	39.02	39.02	15549.0
2016-02-26	AIQ	ETF	7.34	7.6	7.34	7.55	9779.0
2016-02-26	AIRR	ETF	15.64	15.74	15.59	15.73	10000.0
2016-02-26	AIVI	ETF	36.37	36.37	35.98	36.0	12800.0
2016-02-26	ALTY	ETF	13.202	13.202	13.202	13.202	500.0
2016-02-26	AMJ	ETF	24.72	25.41	24.5605	24.69	3668907.0
2016-02-26	AMLP	ETF	50.5	51.2	49.35	49.7	2468540.0
2016-02-26	AMZA	ETF	83.5	85.0	80.7	82.0	10390.0
2016-02-26	ANGL	ETF	26.13	26.13	24.08	24.24	51600.0
2016-02-26	AOA	ETF	43.18	43.18	42.79	42.85	45700.0
2016-02-26	AOK	ETF	31.46	31.4899	31.34	31.37	117671.0
2016-02-26	AOM	ETF	33.7	33.7	33.5501	33.58	49666.0
2016-02-26	AOR	ETF	37.95	37.95	37.6301	37.66	195787.0
2016-02-26	ARGT	ETF	18.62	18.82	18.5	18.54	26400.0
2016-02-26	ARKG	ETF	16.66	16.66	16.66	16.66	200.0
2016-02-26	ARKK	ETF	17.02	17.02	17.02	17.02	100.0
2016-02-26	ARKQ	ETF	16.56	16.56	16.56	16.56	200.0
2016-02-26	ARKW	ETF	18.989	18.989	18.989	18.989	500.0
2016-02-26	ASEA	ETF	12.15	12.15	12.15	12.15	500.0
2016-02-26	ASHR	ETF	22.44	22.48	22.25	22.3	850800.0
2016-02-26	ASHS	ETF	30.98	31.05	30.84	30.93	23800.0
2016-02-26	ASHX	ETF	20.07	20.09	20.05	20.05	1500.0
2016-02-26	ATMP	ETF	16.49	16.98	16.44	16.55	43700.0
2016-02-26	BAB	ETF	30.13	30.13	30.02	30.03	170747.0
2016-02-26	BAL	ETF	37.62	37.62	37.505	37.5101	3202.0
2016-02-26	BBC	ETF	17.855	17.94	17.5	17.904	6367.0
2016-02-26	BBH	ETF	102.21	102.8	101.64	102.02	60900.0
2016-02-26	BBP	ETF	22.92	23.236	22.92	23.12	47800.0
2016-02-26	BCM	ETF	23.465	23.47	23.27	23.27	42263.0
2016-02-26	BFOR	ETF	7.0925	7.125	7.085	7.11	40400.0

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

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