PREVIEW / etf_daily / 2014-07-28

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-28.parquet
  size:    45 KB
  rows:    1,104

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-07-28	SPY	ETF	197.76	198.09	196.62	197.8	69259000.0
2014-07-28	QQQ	ETF	96.8	97.02	96.02	96.77	25603360.0
2014-07-28	IWM	ETF	113.86	113.88	112.23	113.03	37373400.0
2014-07-28	DIA	ETF	169.23	169.65	168.37	169.41	3606100.0
2014-07-28	GLD	ETF	125.44	125.67	125.3	125.58	3212900.0
2014-07-28	TLT	ETF	115.59	115.9	115.12	115.51	5138300.0
2014-07-28	AADR	ETF	38.54	38.61	38.5	38.59	1300.0
2014-07-28	AAXJ	ETF	65.2	65.57	65.04	65.56	369200.0
2014-07-28	ACWI	ETF	60.76	60.8	60.43	60.75	556500.0
2014-07-28	ACWV	ETF	67.45	67.52	67.23	67.52	7600.0
2014-07-28	ACWX	ETF	48.28	48.35	48.0702	48.32	99518.0
2014-07-28	ADRE	ETF	41.79	41.8	41.5876	41.77	42295.0
2014-07-28	AFK	ETF	34.0	34.29	33.7701	34.29	29971.0
2014-07-28	AGG	ETF	109.37	109.43	109.27	109.35	673000.0
2014-07-28	AGQ	ETF	68.14	68.54	67.43	68.23	211300.0
2014-07-28	AGZ	ETF	112.4371	112.75	112.2	112.3833	8037.0
2014-07-28	AIA	ETF	49.98	50.34	49.98	50.34	8600.0
2014-07-28	AIQ	ETF	29.33	29.5	28.973	29.14	75614.0
2014-07-28	AIRR	ETF	18.25	18.28	18.13	18.19	24100.0
2014-07-28	AIVI	ETF	50.65	50.83	50.49	50.8	9300.0
2014-07-28	ALTL	ETF	35.65	35.74	35.49	35.6	971.0
2014-07-28	AMJ	ETF	52.16	52.3	51.97	52.2	490145.0
2014-07-28	AMLP	ETF	94.9	94.95	94.4	94.75	400360.0
2014-07-28	ANGL	ETF	28.24	28.24	28.08	28.1	4700.0
2014-07-28	AOA	ETF	46.83	46.85	46.57	46.79	90000.0
2014-07-28	AOK	ETF	32.8508	32.9	32.84	32.89	113296.0
2014-07-28	AOM	ETF	35.4685	35.47	35.35	35.46	79636.0
2014-07-28	AOR	ETF	40.23	40.23	40.06	40.2	118604.0
2014-07-28	ARGT	ETF	21.85	21.85	21.55	21.7	32000.0
2014-07-28	ASEA	ETF	17.47	17.52	17.44	17.51	9700.0
2014-07-28	ASHR	ETF	24.54	24.6	24.4	24.58	870200.0
2014-07-28	ASHS	ETF	28.38	28.63	28.34	28.62	5000.0
2014-07-28	ATMP	ETF	31.75	31.8	31.7	31.8	25800.0
2014-07-28	AVIV	ETF	28.89	29.07	28.7	28.93	97522.0
2014-07-28	AWAY	ETF	35.7	35.9	34.85	35.5	1484520.0
2014-07-28	BAB	ETF	29.57	29.65	29.509	29.6	90798.0
2014-07-28	BAL	ETF	44.32	44.32	44.0	44.212	30712.0
2014-07-28	BALT	ETF	5.31	5.41	5.24	5.29	321879.0
2014-07-28	BBH	ETF	96.57	96.77	95.58	96.7	67600.0
2014-07-28	BCHP	ETF	20.66	20.66	20.55	20.59	10475.0
2014-07-28	BCM	ETF	40.52	40.562	40.52	40.562	897.0
2014-07-28	BFOR	ETF	7.7875	7.7975	7.7125	7.75	115600.0
2014-07-28	BIB	ETF	45.075	45.25	43.7	44.4	392120.0
2014-07-28	BICK	ETF	27.23	27.39	27.23	27.39	1950.0
2014-07-28	BIL	ETF	91.5	91.52	91.5	91.52	73150.0
2014-07-28	BIS	ETF	576.4	590.8	571.36	582.0	11556.0
2014-07-28	BIV	ETF	84.7	84.75	84.58	84.66	133000.0
2014-07-28	BIZD	ETF	20.64	20.64	20.49	20.56	29800.0
2014-07-28	BJK	ETF	50.45	51.16	50.45	50.92	44100.0
2014-07-28	BKF	ETF	40.39	40.67	40.28	40.62	88567.0

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

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