PREVIEW / etf_daily / 2014-06-02

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-02.parquet
  size:    44 KB
  rows:    1,088

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-06-02	SPY	ETF	192.95	192.99	191.97	192.9	64656000.0
2014-06-02	QQQ	ETF	91.43	91.44	90.64	91.22	30415405.0
2014-06-02	IWM	ETF	113.07	113.1	111.36	112.25	40369700.0
2014-06-02	DIA	ETF	167.25	167.4	166.63	167.2	4453300.0
2014-06-02	GLD	ETF	119.93	120.46	119.61	119.7	5916100.0
2014-06-02	TLT	ETF	113.04	113.68	112.55	112.96	11728200.0
2014-06-02	AAXJ	ETF	62.22	62.22	62.02	62.08	712700.0
2014-06-02	ACWI	ETF	60.05	60.14	59.91	60.11	1832000.0
2014-06-02	ACWV	ETF	66.37	66.61	66.37	66.56	35700.0
2014-06-02	ACWX	ETF	48.34	48.34	48.1769	48.23	222519.0
2014-06-02	ADRE	ETF	37.94	37.94	37.8	37.86	23289.0
2014-06-02	AFK	ETF	33.1	33.22	32.85	33.13	62268.0
2014-06-02	AGG	ETF	109.29	109.36	109.09	109.13	2822900.0
2014-06-02	AGQ	ETF	57.25	57.64	56.69	56.99	187900.0
2014-06-02	AGZ	ETF	112.38	112.51	112.38	112.4866	10095.0
2014-06-02	AGZD	ETF	24.97	25.0	24.97	24.985	4000.0
2014-06-02	AIA	ETF	48.67	48.67	48.54	48.62	26755.0
2014-06-02	AIQ	ETF	29.9	30.07	28.96	29.33	21288.0
2014-06-02	AIRR	ETF	18.64	18.82	18.62	18.75	6600.0
2014-06-02	AIVI	ETF	51.18	51.18	51.02	51.18	13300.0
2014-06-02	AMJ	ETF	49.45	49.85	49.2	49.79	1018432.0
2014-06-02	AMLP	ETF	91.2	91.7	91.0	91.65	512020.0
2014-06-02	ANGL	ETF	28.12	28.25	28.04	28.04	2100.0
2014-06-02	AOA	ETF	46.39	46.39	46.16	46.31	20600.0
2014-06-02	AOK	ETF	32.89	32.89	32.811	32.8201	12395.0
2014-06-02	AOM	ETF	35.41	35.41	35.29	35.33	22802.0
2014-06-02	AOR	ETF	39.93	39.93	39.7601	39.87	18498.0
2014-06-02	ARGT	ETF	19.96	20.06	19.88	20.01	33300.0
2014-06-02	ASEA	ETF	16.64	16.69	16.62	16.68	8100.0
2014-06-02	ASHR	ETF	22.11	22.28	22.11	22.26	37700.0
2014-06-02	ASHS	ETF	25.73	25.8	25.68	25.73	13000.0
2014-06-02	ATMP	ETF	30.02	30.02	29.71	29.91	44800.0
2014-06-02	AVIV	ETF	27.9	28.05	27.61	27.89	141219.0
2014-06-02	AWAY	ETF	30.87	31.2	30.37	30.75	1533211.0
2014-06-02	BAB	ETF	29.49	29.5382	29.3501	29.44	112896.0
2014-06-02	BAL	ETF	52.83	53.36	52.69	53.21	22744.0
2014-06-02	BALT	ETF	6.46	6.46	6.2	6.27	489967.0
2014-06-02	BBH	ETF	90.91	91.26	89.74	90.99	54900.0
2014-06-02	BCHP	ETF	20.45	20.4999	20.45	20.4999	350.0
2014-06-02	BCM	ETF	41.12	41.12	40.7301	40.7301	951.0
2014-06-02	BFOR	ETF	7.575	7.5875	7.525	7.5825	168800.0
2014-06-02	BIB	ETF	40.595	40.745	39.255	40.37	268874.0
2014-06-02	BICK	ETF	25.678	25.678	25.6143	25.635	1377.0
2014-06-02	BIL	ETF	91.52	91.54	91.52	91.52	66000.0
2014-06-02	BIS	ETF	650.4	676.4	650.4	657.2	6309.5
2014-06-02	BIV	ETF	84.6	84.64	84.33	84.47	234600.0
2014-06-02	BIZD	ETF	19.95	19.96	19.42	19.83	14800.0
2014-06-02	BJK	ETF	50.18	50.41	50.01	50.31	17900.0
2014-06-02	BKF	ETF	37.75	37.87	37.72	37.78	92733.0
2014-06-02	BKLN	ETF	24.83	24.83	24.79	24.81	1938000.0

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

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