PREVIEW / etf_daily / 2014-09-02

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-02.parquet
  size:    46 KB
  rows:    1,127

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-02	SPY	ETF	200.97	201.0	199.86	200.61	72426000.0
2014-09-02	QQQ	ETF	100.04	100.1	99.6601	100.07	18331922.0
2014-09-02	IWM	ETF	116.98	117.5	116.5	117.2	38816400.0
2014-09-02	DIA	ETF	170.94	171.07	170.04	170.58	3458700.0
2014-09-02	GLD	ETF	121.97	122.08	121.43	121.65	10128600.0
2014-09-02	TLT	ETF	117.28	117.38	116.7	116.73	10506000.0
2014-09-02	AADR	ETF	39.11	39.11	39.02	39.03	1600.0
2014-09-02	AAXJ	ETF	65.65	65.76	65.33	65.43	406500.0
2014-09-02	ACWI	ETF	60.99	60.99	60.68	60.88	895500.0
2014-09-02	ACWV	ETF	68.39	68.39	67.97	68.18	49100.0
2014-09-02	ACWX	ETF	47.89	47.89	47.68	47.81	226311.0
2014-09-02	ADRE	ETF	43.62	43.94	43.4401	43.88	49944.0
2014-09-02	AFK	ETF	33.5	33.52	33.29	33.52	23719.0
2014-09-02	AGG	ETF	109.55	109.63	109.45	109.45	1029300.0
2014-09-02	AGQ	ETF	59.14	59.37	58.13	58.65	366900.0
2014-09-02	AGZ	ETF	113.16	113.16	112.39	112.46	6693.0
2014-09-02	AGZD	ETF	24.75	25.075	24.75	25.075	3400.0
2014-09-02	AIA	ETF	50.44	50.44	50.186	50.25	48444.0
2014-09-02	AIQ	ETF	28.45	28.51	27.98	28.22	20858.0
2014-09-02	AIRR	ETF	19.4	19.61	19.4	19.57	65300.0
2014-09-02	AIVI	ETF	49.77	49.77	49.53	49.63	9300.0
2014-09-02	AMJ	ETF	53.94	54.05	53.63	53.71	760269.0
2014-09-02	AMLP	ETF	96.65	96.75	96.15	96.3	555100.0
2014-09-02	ANGL	ETF	28.09	28.42	28.09	28.19	8600.0
2014-09-02	AOA	ETF	47.18	47.2	47.02	47.16	12500.0
2014-09-02	AOK	ETF	32.9	32.999	32.9	32.98	43129.0
2014-09-02	AOM	ETF	35.75	35.75	35.57	35.64	32788.0
2014-09-02	AOR	ETF	40.58	40.58	40.4048	40.48	31547.0
2014-09-02	ARGT	ETF	20.93	21.19	20.92	21.04	37700.0
2014-09-02	ASEA	ETF	17.37	17.42	17.33	17.35	2700.0
2014-09-02	ASHR	ETF	25.28	25.28	25.13	25.17	1172900.0
2014-09-02	ASHS	ETF	31.45	31.45	31.2	31.3	7500.0
2014-09-02	ATMP	ETF	32.96	32.96	32.55	32.58	7000.0
2014-09-02	AVIV	ETF	29.22	29.36	29.02	29.03	295656.0
2014-09-02	AWAY	ETF	33.21	33.35	32.78	32.79	709947.0
2014-09-02	BAB	ETF	29.96	29.96	29.82	29.84	82897.0
2014-09-02	BAL	ETF	44.1	44.1	43.71	44.04	6556.0
2014-09-02	BALT	ETF	5.9	5.9	5.74	5.79	308287.0
2014-09-02	BAR	ETF	3.522	3.522	3.48	3.5	155410.0
2014-09-02	BBH	ETF	107.79	108.0	106.54	106.94	148400.0
2014-09-02	BCHP	ETF	20.5	20.5	20.321	20.321	1572.0
2014-09-02	BCM	ETF	39.01	39.03	38.9509	39.0	1771.0
2014-09-02	BFOR	ETF	7.8875	7.9375	7.8825	7.9125	190800.0
2014-09-02	BIB	ETF	53.99	54.16	52.681	53.065	322000.0
2014-09-02	BICK	ETF	27.64	27.7336	27.64	27.7336	1656.0
2014-09-02	BIL	ETF	91.5	91.52	91.5	91.5	598400.0
2014-09-02	BIS	ETF	476.0	483.2	470.0	478.8	7785.5
2014-09-02	BIV	ETF	85.03	85.03	84.7	84.73	203900.0
2014-09-02	BIZD	ETF	20.66	20.66	20.57	20.59	13700.0
2014-09-02	BJK	ETF	47.15	47.15	46.16	46.47	84300.0

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

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