PREVIEW / etf_daily / 2014-09-08

all etf daily files

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

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-09-08	SPY	ETF	200.92	201.21	200.0	200.59	64146000.0
2014-09-08	QQQ	ETF	99.89	100.33	99.62	100.08	25581202.0
2014-09-08	IWM	ETF	116.26	116.8	115.83	116.56	20347300.0
2014-09-08	DIA	ETF	171.04	171.35	170.75	171.06	3139800.0
2014-09-08	GLD	ETF	121.58	121.61	120.37	120.73	7506500.0
2014-09-08	TLT	ETF	116.41	116.63	115.45	115.78	9326400.0
2014-09-08	AADR	ETF	38.66	38.71	38.37	38.37	600.0
2014-09-08	AAXJ	ETF	66.3	66.34	65.84	66.05	703000.0
2014-09-08	ACWI	ETF	60.96	60.96	60.58	60.72	555500.0
2014-09-08	ACWV	ETF	68.4	68.4	67.96	68.09	57500.0
2014-09-08	ACWX	ETF	47.79	47.82	47.49	47.57	107696.0
2014-09-08	ADRE	ETF	44.46	44.46	43.66	43.673	17303.0
2014-09-08	AFK	ETF	33.62	33.63	33.3	33.36	20233.0
2014-09-08	AGG	ETF	109.49	109.54	109.26	109.26	895300.0
2014-09-08	AGQ	ETF	58.39	58.51	57.05	57.78	244800.0
2014-09-08	AGZ	ETF	112.72	112.7788	112.4901	112.59	6080.0
2014-09-08	AGZD	ETF	24.93	25.025	24.88	24.98	29600.0
2014-09-08	AIA	ETF	51.04	51.04	50.71	50.77	9161.0
2014-09-08	AIQ	ETF	28.34	28.5	27.46	27.61	32730.0
2014-09-08	AIRR	ETF	19.53	19.61	19.48	19.5	18800.0
2014-09-08	AIVI	ETF	49.32	49.47	48.92	49.12	13700.0
2014-09-08	ALTL	ETF	36.22	36.22	36.17	36.2099	1936.0
2014-09-08	AMJ	ETF	53.66	53.9399	53.3476	53.58	601060.0
2014-09-08	AMLP	ETF	96.0	96.3	95.9	96.3	356640.0
2014-09-08	ANGL	ETF	28.0	28.21	28.0	28.03	1600.0
2014-09-08	AOA	ETF	47.19	47.2	46.97	47.08	25100.0
2014-09-08	AOK	ETF	32.93	32.93	32.8301	32.87	17013.0
2014-09-08	AOM	ETF	35.65	35.65	35.52	35.57	63669.0
2014-09-08	AOR	ETF	40.52	40.52	40.34	40.4	24564.0
2014-09-08	ARGT	ETF	21.63	21.63	21.22	21.34	165700.0
2014-09-08	ASEA	ETF	17.54	17.54	17.46	17.5	3100.0
2014-09-08	ASHR	ETF	26.23	26.23	25.95	25.98	255300.0
2014-09-08	ASHS	ETF	32.02	32.2	32.02	32.06	13900.0
2014-09-08	ATMP	ETF	32.74	32.74	32.48	32.59	11700.0
2014-09-08	AVIV	ETF	28.64	28.85	28.55	28.83	238035.0
2014-09-08	AWAY	ETF	31.34	34.02	31.21	33.96	1923896.0
2014-09-08	BAB	ETF	29.8	29.813	29.655	29.67	69153.0
2014-09-08	BAL	ETF	43.21	43.6699	43.21	43.64	5559.0
2014-09-08	BALT	ETF	5.73	5.99	5.7	5.97	399956.0
2014-09-08	BAR	ETF	3.47	3.47	3.3765	3.414	77090.0
2014-09-08	BBH	ETF	104.73	105.78	104.65	105.77	28100.0
2014-09-08	BCHP	ETF	20.47	20.47	20.47	20.47	55.0
2014-09-08	BCM	ETF	38.79	38.79	38.79	38.79	0.0
2014-09-08	BFOR	ETF	7.87	7.8975	7.85	7.875	56400.0
2014-09-08	BIB	ETF	50.465	52.005	50.465	51.93	286920.0
2014-09-08	BICK	ETF	27.945	27.945	27.66	27.66	1815.0
2014-09-08	BIL	ETF	91.52	91.52	91.5	91.5	116700.0
2014-09-08	BIS	ETF	502.0	502.0	488.04	488.8	9082.5
2014-09-08	BIV	ETF	84.81	84.81	84.47	84.53	300000.0
2014-09-08	BIZD	ETF	20.67	20.67	20.52	20.52	13900.0

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

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