PREVIEW / etf_daily / 2016-02-19

all etf daily files

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

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-19	SPY	ETF	191.17	192.18	190.45	192.0	114793000.0
2016-02-19	QQQ	ETF	100.91	101.94	100.615	101.63	28257915.0
2016-02-19	IWM	ETF	99.56	100.56	99.11	100.45	32424800.0
2016-02-19	DIA	ETF	163.18	163.81	162.59	163.7	4660600.0
2016-02-19	GLD	ETF	117.26	117.97	117.1	117.58	15192000.0
2016-02-19	TLT	ETF	130.94	131.82	130.73	131.01	8188700.0
2016-02-19	AAXJ	ETF	49.11	49.39	48.96	49.15	460500.0
2016-02-19	ACTX	ETF	5.31	5.31	5.31	5.31	47.0
2016-02-19	ACWI	ETF	51.75	52.04	51.57	52.02	1372000.0
2016-02-19	ACWV	ETF	68.82	69.18	68.76	69.14	73200.0
2016-02-19	ACWX	ETF	36.46	36.64	36.3	36.59	492169.0
2016-02-19	ADRE	ETF	26.95	27.11	26.95	27.11	7942.0
2016-02-19	AFK	ETF	16.8	17.1292	16.8	16.88	31101.0
2016-02-19	AFTY	ETF	11.98	12.04	11.958	11.99	29400.0
2016-02-19	AGG	ETF	109.8	109.85	109.64	109.79	2278800.0
2016-02-19	AGGY	ETF	49.78	49.82	49.56	49.614	5600.0
2016-02-19	AGQ	ETF	32.86	33.27	32.84	32.99	127800.0
2016-02-19	AGZ	ETF	114.94	114.94	114.41	114.65	52801.0
2016-02-19	AGZD	ETF	23.59	23.64	23.48	23.51	1800.0
2016-02-19	AIA	ETF	38.77	39.0	38.74	38.87	17644.0
2016-02-19	AIQ	ETF	7.12	7.31	7.05	7.09	5937.0
2016-02-19	AIRR	ETF	14.87	14.93	14.81	14.91	2900.0
2016-02-19	AIVI	ETF	36.3	36.53	36.23	36.51	17300.0
2016-02-19	ALTY	ETF	13.24	13.24	12.88	12.99	900.0
2016-02-19	AMJ	ETF	24.41	24.47	23.8	24.33	3471617.0
2016-02-19	AMLP	ETF	48.25	48.25	46.6	47.65	2495540.0
2016-02-19	AMZA	ETF	78.8	78.8	75.89	78.3	3570.0
2016-02-19	ANGL	ETF	23.46	23.79	23.46	23.76	32300.0
2016-02-19	AOA	ETF	42.37	42.54	42.27	42.5	33900.0
2016-02-19	AOK	ETF	31.26	31.27	31.1901	31.22	55787.0
2016-02-19	AOM	ETF	33.39	33.43	33.34	33.41	93939.0
2016-02-19	AOR	ETF	37.31	37.45	37.15	37.39	279457.0
2016-02-19	ARGT	ETF	17.57	17.72	17.55	17.72	17600.0
2016-02-19	ARKG	ETF	15.87	16.45	15.87	16.45	1200.0
2016-02-19	ARKK	ETF	16.1	16.1	16.1	16.1	200.0
2016-02-19	ARKQ	ETF	15.92	15.92	15.87	15.92	4400.0
2016-02-19	ARKW	ETF	17.83	17.952	17.65	17.952	600.0
2016-02-19	ASEA	ETF	12.27	12.27	12.15	12.16	1900.0
2016-02-19	ASHR	ETF	23.05	23.16	22.97	23.12	1543600.0
2016-02-19	ASHS	ETF	32.93	33.1	32.77	32.97	87200.0
2016-02-19	ASHX	ETF	20.61	20.69	20.61	20.69	356.0
2016-02-19	ATMP	ETF	16.33	16.33	15.81	16.21	32900.0
2016-02-19	BAB	ETF	30.05	30.05	29.96	30.01	134396.0
2016-02-19	BAL	ETF	39.08	39.16	38.95	39.1	1739.0
2016-02-19	BBC	ETF	18.18	18.5146	18.18	18.5146	2027.0
2016-02-19	BBH	ETF	101.01	102.54	100.09	102.14	170800.0
2016-02-19	BBP	ETF	23.36	23.36	22.83	23.155	3500.0
2016-02-19	BCM	ETF	23.12	23.12	23.065	23.09	32814.0
2016-02-19	BFOR	ETF	6.88	6.905	6.88	6.9	19200.0
2016-02-19	BIB	ETF	40.25	42.0	39.7201	41.64	691559.0

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

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