PREVIEW / etf_daily / 2014-08-27

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-27.parquet
  size:    45 KB
  rows:    1,114

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
2014-08-27	SPY	ETF	200.43	200.57	199.94	200.25	47874000.0
2014-08-27	QQQ	ETF	99.53	99.64	99.31	99.52	15595925.0
2014-08-27	IWM	ETF	116.89	116.94	116.29	116.51	19070100.0
2014-08-27	DIA	ETF	171.15	171.21	170.75	171.01	5162400.0
2014-08-27	GLD	ETF	123.6	123.71	123.25	123.32	2576800.0
2014-08-27	TLT	ETF	117.7	118.41	117.4	118.35	7265800.0
2014-08-27	AADR	ETF	38.84	38.84	38.7	38.75	13300.0
2014-08-27	AAXJ	ETF	66.26	66.26	66.03	66.18	439400.0
2014-08-27	ACWI	ETF	60.93	61.01	60.87	60.99	737200.0
2014-08-27	ACWV	ETF	68.08	68.16	67.94	68.15	34100.0
2014-08-27	ACWX	ETF	48.06	48.06	47.94	48.0	426167.0
2014-08-27	ADRE	ETF	43.21	43.47	43.09	43.45	13111.0
2014-08-27	AFK	ETF	33.28	33.7	33.28	33.49	15166.0
2014-08-27	AGG	ETF	109.73	109.85	109.7	109.8	866100.0
2014-08-27	AGQ	ETF	60.38	60.53	59.66	60.39	108900.0
2014-08-27	AGZ	ETF	112.61	113.26	112.5	112.73	16076.0
2014-08-27	AGZD	ETF	25.035	25.035	25.035	25.035	600.0
2014-08-27	AIA	ETF	51.01	51.01	50.84	51.0	18929.0
2014-08-27	AIQ	ETF	27.77	28.76	27.77	28.25	34105.0
2014-08-27	AIRR	ETF	19.47	19.48	19.32	19.4	32100.0
2014-08-27	AIVI	ETF	49.98	49.99	49.79	49.86	29700.0
2014-08-27	ALTL	ETF	36.19	36.19	36.11	36.11	971.0
2014-08-27	AMJ	ETF	53.16	53.58	53.16	53.51	385137.0
2014-08-27	AMLP	ETF	95.8	95.9	95.5	95.8	1047240.0
2014-08-27	ANGL	ETF	28.32	28.35	28.18	28.26	2800.0
2014-08-27	AOA	ETF	47.22	47.22	47.08	47.1	26300.0
2014-08-27	AOK	ETF	32.96	33.01	32.96	33.01	30438.0
2014-08-27	AOM	ETF	35.68	35.68	35.6243	35.63	19801.0
2014-08-27	AOR	ETF	40.46	40.5	40.446	40.49	12550.0
2014-08-27	ARGT	ETF	21.02	21.06	20.87	20.97	10200.0
2014-08-27	ASEA	ETF	17.57	17.63	17.57	17.63	10300.0
2014-08-27	ASHR	ETF	24.6	24.6	24.52	24.59	556700.0
2014-08-27	ASHS	ETF	30.15	30.18	30.07	30.14	8900.0
2014-08-27	ATMP	ETF	32.37	32.51	32.35	32.49	21100.0
2014-08-27	AVIV	ETF	28.2	28.2	27.96	28.13	91301.0
2014-08-27	AWAY	ETF	34.26	34.3299	32.99	33.05	1215966.0
2014-08-27	BAB	ETF	29.79	29.85	29.7	29.82	54992.0
2014-08-27	BAL	ETF	44.95	45.52	44.83	45.35	25282.0
2014-08-27	BALT	ETF	5.84	5.84	5.69	5.74	280461.0
2014-08-27	BAR	ETF	3.6454	3.651	3.635	3.636	78250.0
2014-08-27	BBH	ETF	106.44	106.84	105.77	106.27	75800.0
2014-08-27	BCHP	ETF	20.4928	20.507	20.4928	20.507	592.0
2014-08-27	BCM	ETF	39.362	39.362	39.362	39.362	1837.0
2014-08-27	BFOR	ETF	7.885	7.8925	7.875	7.8875	139200.0
2014-08-27	BIB	ETF	52.92	53.3999	52.31	52.725	354150.0
2014-08-27	BICK	ETF	27.43	27.634	27.43	27.634	1221.0
2014-08-27	BIL	ETF	91.5	91.52	91.5	91.5	348050.0
2014-08-27	BIS	ETF	482.4	486.76	476.8	483.6	12679.5
2014-08-27	BIV	ETF	85.17	85.21	85.06	85.2	164800.0
2014-08-27	BIZD	ETF	20.46	20.46	20.4	20.46	12300.0

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

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