PREVIEW / etf_daily / 2015-02-27

all etf daily files

  file:    by_date/etf_daily/2015/2015-02-27.parquet
  size:    47 KB
  rows:    1,171

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
2015-02-27	SPY	ETF	211.26	211.58	210.6	210.66	108076000.0
2015-02-27	QQQ	ETF	108.84	108.91	108.23	108.4	27757584.0
2015-02-27	IWM	ETF	123.03	123.36	122.55	122.58	23821700.0
2015-02-27	DIA	ETF	181.93	181.94	181.15	181.19	3161300.0
2015-02-27	GLD	ETF	116.74	117.07	116.16	116.16	8255600.0
2015-02-27	TLT	ETF	129.02	129.62	128.27	129.53	9225100.0
2015-02-27	AADR	ETF	39.33	39.33	39.18	39.25	900.0
2015-02-27	AAXJ	ETF	63.96	64.1	63.82	63.83	820500.0
2015-02-27	ACWI	ETF	61.07	61.21	60.91	60.91	1338200.0
2015-02-27	ACWV	ETF	71.87	72.08	71.75	71.84	141800.0
2015-02-27	ACWX	ETF	45.32	45.5099	45.25	45.25	496180.0
2015-02-27	ADRE	ETF	36.62	36.79	36.6	36.63	5508.0
2015-02-27	AFK	ETF	25.79	25.9124	25.55	25.77	18670.0
2015-02-27	AGG	ETF	111.14	111.22	110.89	111.2	3816400.0
2015-02-27	AGQ	ETF	41.95	42.11	41.44	41.53	145800.0
2015-02-27	AGZ	ETF	114.22	114.635	113.89	114.49	35783.0
2015-02-27	AGZD	ETF	24.575	24.635	24.56	24.615	9200.0
2015-02-27	AIA	ETF	49.48	49.534	49.3864	49.41	21843.0
2015-02-27	AIQ	ETF	24.7	24.76	23.86	23.91	14358.0
2015-02-27	AIRR	ETF	18.38	18.52	18.35	18.47	15200.0
2015-02-27	AIVI	ETF	45.52	45.65	45.47	45.5	26600.0
2015-02-27	ALTL	ETF	37.84	37.8723	37.78	37.8723	805.0
2015-02-27	AMJ	ETF	44.31	44.74	44.28	44.6	1089047.0
2015-02-27	AMLP	ETF	84.8	85.3	84.5	85.3	794340.0
2015-02-27	AMZA	ETF	223.09	223.85	222.5	223.85	370.0
2015-02-27	ANGL	ETF	27.49	27.66	27.12	27.34	18000.0
2015-02-27	AOA	ETF	47.97	48.0	47.79	47.88	49700.0
2015-02-27	AOK	ETF	33.01	33.07	32.94	32.99	56206.0
2015-02-27	AOM	ETF	35.78	35.8	35.69	35.72	30519.0
2015-02-27	AOR	ETF	41.1	41.31	41.03	41.11	47464.0
2015-02-27	ARGT	ETF	20.17	20.17	20.08	20.08	4600.0
2015-02-27	ARKG	ETF	23.4	23.4	23.18	23.25	57500.0
2015-02-27	ARKK	ETF	21.51	21.51	21.51	21.51	200.0
2015-02-27	ARKQ	ETF	20.39	20.39	20.349	20.349	2600.0
2015-02-27	ARKW	ETF	22.61	22.61	22.16	22.16	6100.0
2015-02-27	ASEA	ETF	15.72	15.75	15.7	15.7	2300.0
2015-02-27	ASHR	ETF	36.5	36.53	36.17	36.35	682400.0
2015-02-27	ASHS	ETF	39.59	39.59	39.45	39.51	5200.0
2015-02-27	ATMP	ETF	29.55	29.91	29.55	29.75	35200.0
2015-02-27	AVIV	ETF	35.99	36.27	35.69	35.98	159962.0
2015-02-27	AWAY	ETF	31.24	31.5	30.92	30.995	1341302.0
2015-02-27	BAB	ETF	30.28	30.44	30.125	30.36	128471.0
2015-02-27	BAL	ETF	44.44	44.44	43.38	44.17	17752.0
2015-02-27	BALT	ETF	1.84	1.86	1.75	1.79	491173.0
2015-02-27	BAR	ETF	2.854	2.854	2.854	2.854	2550.0
2015-02-27	BBC	ETF	32.02	32.02	30.81	31.07	84548.0
2015-02-27	BBH	ETF	128.98	129.3	127.47	127.98	133100.0
2015-02-27	BBP	ETF	31.07	31.07	29.9	30.13	9200.0
2015-02-27	BCHP	ETF	19.4799	19.4799	19.4799	19.4799	651.0
2015-02-27	BCM	ETF	31.9	32.19	31.9	32.0872	43591.0

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

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