PREVIEW / etf_daily / 2016-09-12

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-12.parquet
  size:    52 KB
  rows:    1,308

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-12	SPY	ETF	212.39	216.81	212.31	216.34	168110900.0
2016-09-12	QQQ	ETF	113.64	116.49	113.63	116.33	39645960.0
2016-09-12	IWM	ETF	120.69	122.97	120.58	122.94	33408100.0
2016-09-12	DIA	ETF	180.09	183.64	179.93	183.3	7056100.0
2016-09-12	GLD	ETF	126.31	126.92	125.97	126.59	11140300.0
2016-09-12	TLT	ETF	135.32	135.83	135.16	135.59	9096600.0
2016-09-12	AADR	ETF	39.24	39.92	38.65	39.72	1700.0
2016-09-12	AAXJ	ETF	58.64	59.77	58.43	59.58	1103100.0
2016-09-12	ACTX	ETF	3.54	4.13	3.54	3.54	1560.0
2016-09-12	ACWI	ETF	57.76	58.82	57.65	58.73	1898200.0
2016-09-12	ACWV	ETF	74.73	75.89	74.73	75.81	339500.0
2016-09-12	ACWX	ETF	40.71	41.36	40.61	41.31	660647.0
2016-09-12	ADRE	ETF	33.93	34.68	33.93	34.68	3481.0
2016-09-12	AFK	ETF	20.02	20.56	19.94	20.54	44362.0
2016-09-12	AFTY	ETF	13.42	13.59	13.42	13.5	11100.0
2016-09-12	AGG	ETF	111.76	111.89	111.65	111.82	2358200.0
2016-09-12	AGGY	ETF	51.69	51.76	51.62	51.723	4800.0
2016-09-12	AGQ	ETF	46.9	48.38	46.45	48.11	307900.0
2016-09-12	AGZ	ETF	115.34	115.35	115.1501	115.26	8868.0
2016-09-12	AGZD	ETF	23.965	23.965	23.965	23.965	400.0
2016-09-12	AIA	ETF	48.3	49.19	48.26	49.09	135363.0
2016-09-12	AIQ	ETF	6.45	7.24	6.2801	6.56	26512.0
2016-09-12	AIRR	ETF	19.4	19.56	19.365	19.55	24300.0
2016-09-12	AIVI	ETF	38.37	39.07	38.37	39.07	69700.0
2016-09-12	ALTY	ETF	15.41	15.63	15.32	15.63	5500.0
2016-09-12	AMJ	ETF	30.91	31.23	30.63	31.01	1878156.0
2016-09-12	AMLP	ETF	62.5	62.8	62.05	62.45	1981460.0
2016-09-12	AMZA	ETF	113.5	115.4	113.0	114.3	20340.0
2016-09-12	ANGL	ETF	28.36	28.45	28.3	28.44	207000.0
2016-09-12	AOA	ETF	46.51	47.32	46.5	47.26	31900.0
2016-09-12	AOK	ETF	33.0	33.1899	33.0	33.1899	23532.0
2016-09-12	AOM	ETF	35.69	35.9099	35.6	35.85	62559.0
2016-09-12	AOR	ETF	40.52	40.9	40.4249	40.86	122152.0
2016-09-12	ARGT	ETF	22.31	22.74	22.13	22.61	13200.0
2016-09-12	ARKG	ETF	18.77	18.77	18.77	18.77	200.0
2016-09-12	ARKQ	ETF	20.66	20.66	20.66	20.66	200.0
2016-09-12	ASEA	ETF	13.86	13.86	13.6	13.8	6100.0
2016-09-12	ASET	ETF	26.23	26.68	26.23	26.68	200.0
2016-09-12	ASHR	ETF	24.31	24.75	24.29	24.67	827400.0
2016-09-12	ASHS	ETF	34.16	34.51	34.16	34.51	5800.0
2016-09-12	ASHX	ETF	22.5	22.54	22.5	22.54	200.0
2016-09-12	ATMP	ETF	22.79	23.15	22.61	23.03	30200.0
2016-09-12	BAB	ETF	31.31	31.37	31.29	31.36	486903.0
2016-09-12	BAL	ETF	45.45	45.7	44.021	44.255	11855.0
2016-09-12	BBC	ETF	20.08	20.8264	20.046	20.81	5766.0
2016-09-12	BBH	ETF	112.5	116.11	112.5	115.94	80600.0
2016-09-12	BBP	ETF	30.81	31.8	30.81	31.8	5200.0
2016-09-12	BCM	ETF	26.06	26.06	26.01	26.03	730.0
2016-09-12	BFOR	ETF	7.9	8.0625	7.9	8.0625	100800.0
2016-09-12	BIB	ETF	44.5	48.05	44.4624	47.87	774410.0

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

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