PREVIEW / etf_daily / 2016-09-28

all etf daily files

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

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-28	SPY	ETF	215.83	216.82	214.71	216.64	87411000.0
2016-09-28	QQQ	ETF	118.62	118.77	118.09	118.7	14794330.0
2016-09-28	IWM	ETF	123.95	124.76	123.07	124.68	19426400.0
2016-09-28	DIA	ETF	182.36	183.23	181.52	183.1	6413000.0
2016-09-28	GLD	ETF	126.25	126.4	125.73	126.22	6757700.0
2016-09-28	TLT	ETF	138.5	139.15	138.22	138.4	7958700.0
2016-09-28	AADR	ETF	39.88	40.13	39.76	40.13	19000.0
2016-09-28	AAXJ	ETF	60.7	61.13	60.33	61.1	1027800.0
2016-09-28	ACTX	ETF	6.4901	6.4901	5.31	6.3721	427.0
2016-09-28	ACWI	ETF	58.99	59.35	58.71	59.31	1034600.0
2016-09-28	ACWV	ETF	76.61	76.78	76.25	76.75	128500.0
2016-09-28	ACWX	ETF	41.5	41.74	41.2499	41.73	209626.0
2016-09-28	ADRE	ETF	35.02	35.25	34.795	35.25	3477.0
2016-09-28	AFK	ETF	20.46	20.5834	20.22	20.5834	11576.0
2016-09-28	AFTY	ETF	13.32	13.41	13.32	13.41	1200.0
2016-09-28	AGG	ETF	112.58	112.61	112.47	112.54	2853900.0
2016-09-28	AGGY	ETF	52.035	52.1	52.003	52.08	5400.0
2016-09-28	AGNG	ETF	16.87	16.87	16.817	16.817	700.0
2016-09-28	AGQ	ETF	47.5	48.29	46.81	48.11	185000.0
2016-09-28	AGZ	ETF	115.732	115.79	115.54	115.6675	13398.0
2016-09-28	AGZD	ETF	23.88	23.985	23.875	23.985	2000.0
2016-09-28	AIA	ETF	49.94	50.43	49.789	50.375	84270.0
2016-09-28	AIQ	ETF	6.5	6.74	6.5	6.54	52303.0
2016-09-28	AIRR	ETF	20.11	20.11	20.11	20.11	300.0
2016-09-28	AIVI	ETF	38.48	38.82	38.33	38.81	49000.0
2016-09-28	ALTY	ETF	15.88	15.88	15.642	15.76	44700.0
2016-09-28	AMJ	ETF	31.0	31.64	30.63	31.57	2426210.0
2016-09-28	AMLP	ETF	62.55	63.55	62.0	63.55	3159220.0
2016-09-28	AMZA	ETF	113.2	116.3	112.9	115.8	19210.0
2016-09-28	ANGL	ETF	28.68	28.84	28.62	28.82	131200.0
2016-09-28	AOA	ETF	47.58	47.64	47.26	47.64	21300.0
2016-09-28	AOK	ETF	33.35	33.43	33.29	33.37	23279.0
2016-09-28	AOM	ETF	36.07	36.16	35.9322	36.16	83387.0
2016-09-28	AOR	ETF	41.08	41.23	40.9494	41.23	38775.0
2016-09-28	ARGT	ETF	22.99	23.49	22.94	23.4	23200.0
2016-09-28	ARKG	ETF	20.47	20.47	20.215	20.215	2200.0
2016-09-28	ARKK	ETF	22.09	22.16	22.02	22.16	19000.0
2016-09-28	ARKQ	ETF	22.0	22.041	22.0	22.041	1300.0
2016-09-28	ARKW	ETF	25.438	25.563	25.36	25.563	2900.0
2016-09-28	ASEA	ETF	14.0	14.0	13.91	13.91	1100.0
2016-09-28	ASHR	ETF	24.37	24.48	24.3	24.47	266300.0
2016-09-28	ASHS	ETF	34.28	34.39	34.28	34.39	7900.0
2016-09-28	ATMP	ETF	22.67	23.36	22.61	23.36	23800.0
2016-09-28	BAB	ETF	31.48	31.54	31.4	31.47	181975.0
2016-09-28	BAL	ETF	45.74	45.77	45.3	45.54	7820.0
2016-09-28	BBC	ETF	22.97	23.32	22.92	23.187	10957.0
2016-09-28	BBH	ETF	117.91	117.97	116.36	116.86	53500.0
2016-09-28	BBP	ETF	34.44	34.44	33.564	33.79	4700.0
2016-09-28	BCM	ETF	26.1199	26.305	26.1113	26.2346	1390.0
2016-09-28	BFOR	ETF	8.0575	8.085	8.03	8.085	88400.0

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

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