PREVIEW / etf_daily / 2016-12-27

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-27.parquet
  size:    54 KB
  rows:    1,360

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-12-27	SPY	ETF	226.02	226.73	226.0	226.27	42672500.0
2016-12-27	QQQ	ETF	120.44	121.52	120.41	120.82	16110554.0
2016-12-27	IWM	ETF	136.23	137.3	136.21	136.65	13571700.0
2016-12-27	DIA	ETF	199.16	199.54	199.13	199.21	2340700.0
2016-12-27	GLD	ETF	108.61	108.67	108.24	108.56	3685500.0
2016-12-27	TLT	ETF	117.42	117.7	117.23	117.67	5276600.0
2016-12-27	AADR	ETF	39.69	39.89	39.54	39.89	3200.0
2016-12-27	AAXJ	ETF	54.27	54.47	54.27	54.32	1934400.0
2016-12-27	ACSI	ETF	27.4288	27.47	27.4	27.44	11423.0
2016-12-27	ACTX	ETF	16.5201	19.4702	16.5201	18.2902	1257.0
2016-12-27	ACWF	ETF	24.0642	24.0642	24.02	24.02	1495.0
2016-12-27	ACWI	ETF	59.45	59.58	59.35	59.44	2609700.0
2016-12-27	ACWV	ETF	72.52	72.64	72.47	72.5	164500.0
2016-12-27	ACWX	ETF	40.1	40.15	40.06	40.07	1868422.0
2016-12-27	ADRE	ETF	32.12	32.31	32.12	32.25	10901.0
2016-12-27	AFK	ETF	19.25	19.56	19.14	19.55	60744.0
2016-12-27	AFTY	ETF	12.99	13.07	12.99	13.05	7000.0
2016-12-27	AGG	ETF	107.19	107.34	107.19	107.34	2661500.0
2016-12-27	AGGY	ETF	49.12	49.2	49.07	49.2	10400.0
2016-12-27	AGQ	ETF	31.78	32.37	31.66	32.29	133000.0
2016-12-27	AGZ	ETF	112.05	112.15	111.9966	112.1	24923.0
2016-12-27	AGZD	ETF	24.015	24.015	24.015	24.015	800.0
2016-12-27	AIA	ETF	45.65	45.78	45.65	45.74	20949.0
2016-12-27	AIQ	ETF	9.55	9.6	9.5	9.55	49008.0
2016-12-27	AIRR	ETF	24.24	24.3	24.139	24.219	81000.0
2016-12-27	AIVI	ETF	37.29	37.31	37.22	37.26	26000.0
2016-12-27	ALTY	ETF	15.16	15.16	15.1	15.1	500.0
2016-12-27	AMJ	ETF	31.78	31.92	31.69	31.74	1580685.0
2016-12-27	AMLP	ETF	63.6	63.75	63.35	63.55	1320900.0
2016-12-27	AMZA	ETF	113.7	114.4	113.3	113.7	50960.0
2016-12-27	ANGL	ETF	29.09	29.09	29.02	29.04	162800.0
2016-12-27	AOA	ETF	47.72	47.78	47.64	47.7	206600.0
2016-12-27	AOK	ETF	32.58	32.59	32.51	32.55	140491.0
2016-12-27	AOM	ETF	35.4	35.44	35.3	35.42	273539.0
2016-12-27	AOR	ETF	40.96	40.96	40.75	40.75	491047.0
2016-12-27	ARGT	ETF	22.74	22.84	22.65	22.83	17600.0
2016-12-27	ARKG	ETF	17.58	17.687	17.575	17.6	1400.0
2016-12-27	ARKK	ETF	20.36	20.715	20.34	20.715	700.0
2016-12-27	ARKQ	ETF	22.64	22.734	22.64	22.717	1900.0
2016-12-27	ARKW	ETF	25.54	25.717	25.54	25.61	4600.0
2016-12-27	ASEA	ETF	12.99	13.05	12.99	13.04	2800.0
2016-12-27	ASHR	ETF	23.7	23.77	23.7	23.73	420500.0
2016-12-27	ASHS	ETF	32.53	32.69	32.53	32.62	10500.0
2016-12-27	ASHX	ETF	19.2532	19.2532	19.22	19.22	450.0
2016-12-27	ATMP	ETF	23.73	23.88	23.73	23.78	93100.0
2016-12-27	BAB	ETF	28.88	28.9529	28.82	28.86	208635.0
2016-12-27	BAL	ETF	45.76	45.9589	45.631	45.76	8430.0
2016-12-27	BBC	ETF	19.03	19.4	18.87	18.87	7261.0
2016-12-27	BBH	ETF	109.45	110.63	109.04	109.11	94600.0
2016-12-27	BBP	ETF	34.25	34.25	33.76	33.76	12900.0

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

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