PREVIEW / etf_daily / 2016-02-18

all etf daily files

  file:    by_date/etf_daily/2016/2016-02-18.parquet
  size:    49 KB
  rows:    1,226

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-18	SPY	ETF	193.2	193.27	191.72	192.09	102343000.0
2016-02-18	QQQ	ETF	102.81	102.84	101.2	101.33	38991469.0
2016-02-18	IWM	ETF	100.51	100.64	99.54	99.95	35043600.0
2016-02-18	DIA	ETF	165.33	165.45	164.29	164.52	5187600.0
2016-02-18	GLD	ETF	115.3	118.6	115.29	118.29	13586500.0
2016-02-18	TLT	ETF	129.41	131.0	129.36	130.9	10196700.0
2016-02-18	AADR	ETF	37.56	37.56	37.56	37.56	100.0
2016-02-18	AAXJ	ETF	49.61	49.68	49.16	49.21	857200.0
2016-02-18	ACTX	ETF	4.779	5.31	4.13	5.31	128.0
2016-02-18	ACWF	ETF	21.56	21.56	21.56	21.56	293.0
2016-02-18	ACWI	ETF	52.5	52.5	52.04	52.11	2891700.0
2016-02-18	ACWV	ETF	68.97	69.16	68.71	68.96	192200.0
2016-02-18	ACWX	ETF	37.03	37.03	36.67	36.71	831488.0
2016-02-18	ADRE	ETF	27.25	27.3	27.05	27.05	5541.0
2016-02-18	AFK	ETF	16.93	17.25	16.9	17.04	24654.0
2016-02-18	AFTY	ETF	12.03	12.03	11.995	11.995	1800.0
2016-02-18	AGG	ETF	109.5	109.81	109.45	109.77	2844400.0
2016-02-18	AGGY	ETF	49.65	49.66	49.54	49.64	2200.0
2016-02-18	AGQ	ETF	32.51	33.78	32.29	33.55	264500.0
2016-02-18	AGZ	ETF	114.66	114.8099	114.42	114.46	89378.0
2016-02-18	AGZD	ETF	23.52	23.525	23.52	23.52	17000.0
2016-02-18	AIA	ETF	39.28	39.28	38.91	38.91	25938.0
2016-02-18	AIQ	ETF	7.12	7.2	6.98	7.15	15592.0
2016-02-18	AIRR	ETF	14.95	15.0	14.86	14.97	3200.0
2016-02-18	AIVI	ETF	36.84	36.84	36.59	36.59	16200.0
2016-02-18	ALTY	ETF	12.996	12.996	12.996	12.996	100.0
2016-02-18	AMJ	ETF	25.13	25.44	24.29	24.78	3429059.0
2016-02-18	AMLP	ETF	49.6	49.7	47.25	48.7	3632540.0
2016-02-18	AMZA	ETF	80.0	80.0	76.0	79.75	5970.0
2016-02-18	ANGL	ETF	23.7	23.7	23.44	23.66	32600.0
2016-02-18	AOA	ETF	42.84	42.84	42.5	42.52	35800.0
2016-02-18	AOK	ETF	31.24	31.3	31.19	31.23	96245.0
2016-02-18	AOM	ETF	33.4	33.5199	33.36	33.4	46322.0
2016-02-18	AOR	ETF	37.58	37.58	37.3998	37.41	327960.0
2016-02-18	ARGT	ETF	17.71	17.82	17.65	17.82	14800.0
2016-02-18	ARKG	ETF	16.38	16.38	16.38	16.38	2000.0
2016-02-18	ARKK	ETF	16.07	16.07	16.07	16.07	2300.0
2016-02-18	ARKQ	ETF	15.84	15.84	15.79	15.81	2400.0
2016-02-18	ARKW	ETF	18.39	18.39	17.86	17.99	4300.0
2016-02-18	ASEA	ETF	12.38	12.38	12.33	12.33	2100.0
2016-02-18	ASHR	ETF	23.18	23.32	22.97	23.04	1293200.0
2016-02-18	ASHS	ETF	32.85	33.03	32.62	32.62	41100.0
2016-02-18	ASHX	ETF	20.6942	20.6942	20.58	20.58	931.0
2016-02-18	ATMP	ETF	16.6	16.8	16.12	16.4	55300.0
2016-02-18	BAB	ETF	30.01	30.06	29.7101	29.97	158345.0
2016-02-18	BAL	ETF	39.22	39.42	39.15	39.21	1835.0
2016-02-18	BBC	ETF	19.24	19.345	18.289	18.289	8209.0
2016-02-18	BBH	ETF	104.14	104.14	101.38	101.45	148500.0
2016-02-18	BBP	ETF	24.16	24.58	23.301	23.301	1600.0
2016-02-18	BCM	ETF	23.44	23.44	23.264	23.3185	2472.0

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

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