PREVIEW / etf_daily / 2016-06-28

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-28.parquet
  size:    52 KB
  rows:    1,298

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-06-28	SPY	ETF	201.48	203.23	201.12	203.2	159382400.0
2016-06-28	QQQ	ETF	103.33	104.51	103.3	104.46	28260604.0
2016-06-28	IWM	ETF	109.65	110.88	109.57	110.37	42040600.0
2016-06-28	DIA	ETF	172.85	173.86	172.2	173.82	5642800.0
2016-06-28	GLD	ETF	125.56	126.02	125.06	125.32	16001500.0
2016-06-28	TLT	ETF	139.44	139.9	138.88	139.46	14006400.0
2016-06-28	AADR	ETF	36.12	37.58	36.12	37.58	1100.0
2016-06-28	AAXJ	ETF	52.96	53.09	52.63	53.06	874900.0
2016-06-28	ACTX	ETF	4.72	4.72	4.13	4.72	162.0
2016-06-28	ACWI	ETF	54.09	54.46	53.92	54.45	2003600.0
2016-06-28	ACWV	ETF	74.04	74.37	73.81	74.35	475900.0
2016-06-28	ACWX	ETF	37.61	37.78	37.36	37.78	1027412.0
2016-06-28	ADRE	ETF	29.79	30.06	29.79	29.9045	7274.0
2016-06-28	AFK	ETF	19.27	19.828	19.13	19.4	12131.0
2016-06-28	AFTY	ETF	12.267	12.267	12.21	12.21	1200.0
2016-06-28	AGG	ETF	112.54	112.54	112.37	112.47	2951700.0
2016-06-28	AGGY	ETF	51.71	51.753	51.55	51.753	5500.0
2016-06-28	AGQ	ETF	42.62	43.04	42.49	42.77	136100.0
2016-06-28	AGZ	ETF	116.38	116.38	115.64	115.78	24259.0
2016-06-28	AIA	ETF	43.04	43.27	42.9	43.27	162651.0
2016-06-28	AIQ	ETF	6.51	6.9999	6.48	6.5	32134.0
2016-06-28	AIRR	ETF	17.547	17.57	17.53	17.53	1600.0
2016-06-28	AIVI	ETF	36.0	36.08	35.66	36.04	62600.0
2016-06-28	ALTY	ETF	14.79	14.87	14.76	14.87	2300.0
2016-06-28	AMJ	ETF	30.63	31.29	30.42	31.22	3417928.0
2016-06-28	AMLP	ETF	62.25	63.3	61.55	63.25	1715680.0
2016-06-28	AMZA	ETF	112.2	116.3	109.5	113.3	20350.0
2016-06-28	ANGL	ETF	27.29	27.48	27.0	27.35	153500.0
2016-06-28	AOA	ETF	44.63	44.8	44.41	44.78	39600.0
2016-06-28	AOK	ETF	32.5	32.5899	32.3601	32.54	52365.0
2016-06-28	AOM	ETF	34.75	34.95	34.74	34.93	127929.0
2016-06-28	AOR	ETF	39.12	39.3107	39.0	39.25	75474.0
2016-06-28	ARGT	ETF	21.09	21.56	21.05	21.42	437400.0
2016-06-28	ARKG	ETF	16.4	16.4	16.387	16.387	400.0
2016-06-28	ARKK	ETF	18.66	18.698	18.66	18.698	600.0
2016-06-28	ARKQ	ETF	18.63	18.634	18.63	18.634	700.0
2016-06-28	ARKW	ETF	21.42	21.491	21.42	21.49	1100.0
2016-06-28	ASEA	ETF	13.13	13.19	13.13	13.18	2000.0
2016-06-28	ASHR	ETF	23.45	23.47	23.28	23.4	827700.0
2016-06-28	ASHS	ETF	33.71	33.82	33.6	33.7	10900.0
2016-06-28	ATMP	ETF	21.54	21.71	21.21	21.71	20000.0
2016-06-28	BAB	ETF	31.56	31.6	31.45	31.55	252257.0
2016-06-28	BAL	ETF	43.35	43.72	43.19	43.72	3940.0
2016-06-28	BBC	ETF	17.23	17.77	17.23	17.75	11498.0
2016-06-28	BBH	ETF	97.66	99.66	97.66	99.6	85300.0
2016-06-28	BBP	ETF	25.29	25.775	25.29	25.757	5300.0
2016-06-28	BCM	ETF	27.17	27.334	27.17	27.334	589.0
2016-06-28	BFOR	ETF	7.2275	7.3225	7.2275	7.315	124400.0
2016-06-28	BIB	ETF	35.5	36.91	35.4001	36.84	870006.0
2016-06-28	BICK	ETF	19.8801	20.05	19.8801	19.9701	3851.0

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

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