PREVIEW / etf_daily / 2016-09-20

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-20.parquet
  size:    51 KB
  rows:    1,285

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-09-20	SPY	ETF	214.41	214.59	213.38	213.42	69665300.0
2016-09-20	QQQ	ETF	117.19	117.48	116.8	117.0	18078584.0
2016-09-20	IWM	ETF	123.2	123.23	122.15	122.15	16877900.0
2016-09-20	DIA	ETF	181.81	182.04	181.03	181.05	1997800.0
2016-09-20	GLD	ETF	125.31	125.59	125.17	125.44	5672000.0
2016-09-20	TLT	ETF	135.15	135.58	134.67	134.78	6054800.0
2016-09-20	AADR	ETF	39.9	39.9	39.72	39.77	800.0
2016-09-20	AAXJ	ETF	60.05	60.11	59.71	59.72	1337600.0
2016-09-20	ACTX	ETF	8.2601	8.2601	5.9001	7.0211	3390.0
2016-09-20	ACWI	ETF	58.39	58.44	58.14	58.19	3545100.0
2016-09-20	ACWV	ETF	75.62	75.76	75.41	75.41	272200.0
2016-09-20	ACWX	ETF	40.93	40.9849	40.77	40.81	206134.0
2016-09-20	ADRE	ETF	34.221	34.221	34.07	34.11	7724.0
2016-09-20	AFK	ETF	20.375	20.375	20.05	20.05	1492.0
2016-09-20	AFTY	ETF	13.48	13.48	13.43	13.44	2200.0
2016-09-20	AGG	ETF	111.9	111.94	111.74	111.75	2078500.0
2016-09-20	AGGY	ETF	51.64	51.87	51.64	51.74	27200.0
2016-09-20	AGQ	ETF	47.84	48.66	47.76	48.57	54400.0
2016-09-20	AGZ	ETF	115.01	115.4399	115.01	115.11	29414.0
2016-09-20	AIA	ETF	49.43	49.55	49.33	49.35	52943.0
2016-09-20	AIQ	ETF	6.43	6.73	6.351	6.54	25648.0
2016-09-20	AIRR	ETF	19.67	19.695	19.62	19.65	11100.0
2016-09-20	AIVI	ETF	38.2	38.2	38.01	38.08	45400.0
2016-09-20	ALTY	ETF	15.57	15.58	15.54	15.54	1000.0
2016-09-20	AMJ	ETF	30.17	30.52	30.15	30.15	1020562.0
2016-09-20	AMLP	ETF	61.75	61.9	61.05	61.15	655240.0
2016-09-20	AMZA	ETF	112.9	113.0	112.0	112.5	11810.0
2016-09-20	ANGL	ETF	28.47	28.47	28.35	28.36	415300.0
2016-09-20	AOA	ETF	46.96	47.09	46.8	46.83	25800.0
2016-09-20	AOK	ETF	33.11	33.1499	33.0003	33.07	43836.0
2016-09-20	AOM	ETF	35.77	35.77	35.6015	35.64	82088.0
2016-09-20	AOR	ETF	40.67	40.745	40.5896	40.64	46936.0
2016-09-20	ARGT	ETF	22.81	22.81	22.59	22.61	28000.0
2016-09-20	ARKG	ETF	19.75	19.81	19.74	19.779	500.0
2016-09-20	ARKK	ETF	21.45	21.45	21.45	21.45	1100.0
2016-09-20	ARKQ	ETF	21.22	21.23	21.22	21.22	600.0
2016-09-20	ARKW	ETF	24.54	24.54	24.54	24.54	300.0
2016-09-20	ASEA	ETF	13.84	13.89	13.83	13.86	2400.0
2016-09-20	ASHR	ETF	24.71	24.75	24.57	24.59	615400.0
2016-09-20	ASHS	ETF	34.72	34.75	34.62	34.62	3200.0
2016-09-20	ATMP	ETF	22.43	22.58	22.36	22.42	26900.0
2016-09-20	BAB	ETF	31.19	31.25	31.13	31.13	92731.0
2016-09-20	BAL	ETF	45.69	47.0699	45.65	47.01	12917.0
2016-09-20	BBC	ETF	22.5	22.83	22.5	22.73	6112.0
2016-09-20	BBH	ETF	117.63	118.25	117.15	117.69	87300.0
2016-09-20	BBP	ETF	33.5	33.81	33.5	33.68	7300.0
2016-09-20	BCM	ETF	25.56	25.835	25.56	25.768	4016.0
2016-09-20	BFIT	ETF	15.8199	15.8199	15.8199	15.8199	120.0
2016-09-20	BFOR	ETF	8.0	8.0	7.9525	7.965	16800.0
2016-09-20	BIB	ETF	50.33	51.14	49.83	50.68	576250.0

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

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