PREVIEW / etf_daily / 2016-09-29

all etf daily files

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

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-29	SPY	ETF	216.4	216.87	214.04	214.68	128070600.0
2016-09-29	QQQ	ETF	118.51	118.72	117.3338	117.84	27207499.0
2016-09-29	IWM	ETF	124.62	124.64	122.7	122.86	26657700.0
2016-09-29	DIA	ETF	182.82	183.42	180.65	181.22	3376400.0
2016-09-29	GLD	ETF	125.84	126.34	125.54	126.07	7448400.0
2016-09-29	TLT	ETF	137.56	139.07	137.45	138.75	8319800.0
2016-09-29	AADR	ETF	40.5	40.53	40.2	40.4	1900.0
2016-09-29	AAXJ	ETF	60.78	60.94	60.08	60.21	891700.0
2016-09-29	ACTX	ETF	5.9001	5.9001	4.72	4.72	247.0
2016-09-29	ACWI	ETF	59.16	59.35	58.52	58.69	1331000.0
2016-09-29	ACWV	ETF	76.53	76.56	75.86	75.95	209300.0
2016-09-29	ACWX	ETF	41.6	41.72	41.09	41.21	293959.0
2016-09-29	ADRE	ETF	35.05	35.0673	34.69	34.74	13432.0
2016-09-29	AFK	ETF	20.5	20.75	20.0928	20.0928	4539.0
2016-09-29	AFTY	ETF	13.435	13.435	13.435	13.435	300.0
2016-09-29	AGG	ETF	112.41	112.64	112.37	112.54	1668000.0
2016-09-29	AGGY	ETF	51.94	52.31	51.94	52.042	9300.0
2016-09-29	AGQ	ETF	47.79	48.31	47.32	47.7	168200.0
2016-09-29	AGZ	ETF	115.74	115.85	115.66	115.7601	37179.0
2016-09-29	AGZD	ETF	23.955	23.955	23.925	23.925	4400.0
2016-09-29	AIA	ETF	50.18	50.37	49.7467	49.82	99314.0
2016-09-29	AIQ	ETF	6.88	7.0	6.59	6.64	61606.0
2016-09-29	AIRR	ETF	20.31	20.41	20.21	20.27	6300.0
2016-09-29	AIVI	ETF	38.99	39.14	38.54	38.67	64500.0
2016-09-29	ALTY	ETF	15.7	15.7	15.6	15.6	1300.0
2016-09-29	AMJ	ETF	31.62	31.765	31.15	31.31	1676417.0
2016-09-29	AMLP	ETF	63.6	63.75	62.9	63.15	2120100.0
2016-09-29	AMZA	ETF	116.0	116.5	114.2	115.7	23290.0
2016-09-29	ANGL	ETF	28.85	28.91	28.66	28.77	289000.0
2016-09-29	AOA	ETF	47.59	47.63	47.13	47.23	39800.0
2016-09-29	AOK	ETF	33.45	33.45	33.2772	33.32	54189.0
2016-09-29	AOM	ETF	36.03	36.1599	35.9301	35.97	56864.0
2016-09-29	AOR	ETF	41.09	41.2	40.8574	40.99	40548.0
2016-09-29	ARGT	ETF	23.46	23.8	23.46	23.52	29400.0
2016-09-29	ARKG	ETF	19.7	19.7	19.63	19.63	1300.0
2016-09-29	ARKK	ETF	22.08	22.096	21.93	21.96	3600.0
2016-09-29	ARKQ	ETF	22.16	22.16	22.034	22.04	400.0
2016-09-29	ARKW	ETF	25.64	25.64	25.47	25.5	1100.0
2016-09-29	ASEA	ETF	14.12	14.15	13.96	14.11	11100.0
2016-09-29	ASET	ETF	26.84	26.9	26.7399	26.74	1252.0
2016-09-29	ASHR	ETF	24.45	24.56	24.4	24.43	593700.0
2016-09-29	ASHS	ETF	34.24	34.52	34.24	34.32	6700.0
2016-09-29	ASHX	ETF	22.3799	22.38	22.3799	22.38	538.0
2016-09-29	ATMP	ETF	23.36	23.52	23.11	23.26	88200.0
2016-09-29	BAB	ETF	31.4	31.4699	31.355	31.43	189932.0
2016-09-29	BAL	ETF	45.11	45.11	44.5401	44.71	8597.0
2016-09-29	BBC	ETF	23.01	23.01	22.185	22.2033	8558.0
2016-09-29	BBH	ETF	116.79	117.02	113.82	114.1	62800.0
2016-09-29	BBP	ETF	33.5	33.505	32.75	32.75	15900.0
2016-09-29	BCM	ETF	26.34	26.4191	26.3102	26.3771	5571.0

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

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