PREVIEW / etf_daily / 2016-09-27

all etf daily files

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

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-27	SPY	ETF	214.05	215.68	213.62	215.57	78494800.0
2016-09-27	QQQ	ETF	117.31	118.5552	117.15	118.5	20238432.0
2016-09-27	IWM	ETF	123.17	123.88	122.81	123.73	16939500.0
2016-09-27	DIA	ETF	180.58	182.14	180.24	182.0	3717300.0
2016-09-27	GLD	ETF	126.86	126.9	126.34	126.62	6220700.0
2016-09-27	TLT	ETF	138.59	138.8	137.95	138.7	9450400.0
2016-09-27	AADR	ETF	40.1	40.1	39.68	39.7	1300.0
2016-09-27	AAXJ	ETF	60.28	60.7	60.15	60.7	1063200.0
2016-09-27	ACTX	ETF	6.4901	6.4901	5.9001	5.9001	81.0
2016-09-27	ACWI	ETF	58.48	58.95	58.4	58.93	1667700.0
2016-09-27	ACWV	ETF	76.35	76.69	76.29	76.56	127600.0
2016-09-27	ACWX	ETF	41.03	41.395	41.01	41.37	415488.0
2016-09-27	ADRE	ETF	34.67	34.9897	34.65	34.9897	30084.0
2016-09-27	AFK	ETF	20.2101	20.5908	20.2101	20.555	1518.0
2016-09-27	AFTY	ETF	13.364	13.4	13.36	13.4	3400.0
2016-09-27	AGG	ETF	112.57	112.61	112.41	112.51	2881300.0
2016-09-27	AGGY	ETF	52.09	52.09	51.996	52.08	9800.0
2016-09-27	AGQ	ETF	48.38	48.54	47.13	47.97	178400.0
2016-09-27	AGZ	ETF	115.6	115.62	115.5	115.52	12072.0
2016-09-27	AGZD	ETF	23.93	23.93	23.93	23.93	600.0
2016-09-27	AIA	ETF	49.57	49.92	49.56	49.9	22678.0
2016-09-27	AIQ	ETF	6.49	6.56	6.39	6.49	38276.0
2016-09-27	AIRR	ETF	19.96	20.062	19.916	20.03	3800.0
2016-09-27	AIVI	ETF	38.12	38.33	38.01	38.28	9600.0
2016-09-27	ALTY	ETF	15.69	15.77	15.69	15.75	32200.0
2016-09-27	AMJ	ETF	30.94	31.1	30.64	30.88	1282271.0
2016-09-27	AMLP	ETF	62.65	62.7	61.8	62.0	1007420.0
2016-09-27	AMZA	ETF	114.5	114.5	112.3	113.0	21160.0
2016-09-27	ANGL	ETF	28.63	28.76	28.6	28.68	58300.0
2016-09-27	AOA	ETF	47.07	47.41	47.07	47.4	27300.0
2016-09-27	AOK	ETF	33.2945	33.4	33.25	33.33	22583.0
2016-09-27	AOM	ETF	36.05	36.107	35.9354	36.06	67894.0
2016-09-27	AOR	ETF	40.81	41.1099	40.81	41.08	51786.0
2016-09-27	ARGT	ETF	23.05	23.07	22.87	22.99	24500.0
2016-09-27	ARKG	ETF	20.21	20.36	20.21	20.36	2800.0
2016-09-27	ARKK	ETF	22.0	22.105	21.996	22.105	1800.0
2016-09-27	ARKQ	ETF	21.73	21.744	21.71	21.71	600.0
2016-09-27	ARKW	ETF	25.14	25.39	25.14	25.37	26600.0
2016-09-27	ASEA	ETF	13.98	14.02	13.95	14.02	1400.0
2016-09-27	ASHR	ETF	24.28	24.4	24.28	24.37	563000.0
2016-09-27	ASHS	ETF	34.11	34.32	34.11	34.27	1700.0
2016-09-27	ATMP	ETF	22.55	22.86	22.55	22.74	59100.0
2016-09-27	BAB	ETF	31.41	31.48	31.37	31.46	214431.0
2016-09-27	BAL	ETF	46.64	46.64	46.2	46.2	1914.0
2016-09-27	BBC	ETF	22.9	23.35	22.9	23.32	14658.0
2016-09-27	BBH	ETF	116.51	117.81	116.19	117.81	35300.0
2016-09-27	BBP	ETF	34.07	34.19	33.76	34.19	7300.0
2016-09-27	BCM	ETF	25.6899	25.8048	25.6899	25.79	1789.0
2016-09-27	BFIT	ETF	15.96	15.96	15.96	15.96	110.0
2016-09-27	BFOR	ETF	7.9775	8.05	7.9775	8.035	15200.0

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

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