PREVIEW / etf_daily / 2014-05-30

all etf daily files

  file:    by_date/etf_daily/2014/2014-05-30.parquet
  size:    43 KB
  rows:    1,080

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-05-30	SPY	ETF	192.19	192.8	192.03	192.68	76316000.0
2014-05-30	QQQ	ETF	91.33	91.45	90.83	91.31	29916899.0
2014-05-30	IWM	ETF	113.33	113.43	112.34	112.86	38856000.0
2014-05-30	DIA	ETF	166.6	167.02	166.3	166.93	2769000.0
2014-05-30	GLD	ETF	120.76	120.81	119.62	120.43	8749600.0
2014-05-30	TLT	ETF	113.96	114.4	113.81	114.1	6518900.0
2014-05-30	AAXJ	ETF	61.98	62.06	61.73	61.8	339100.0
2014-05-30	ACWI	ETF	60.0	60.03	59.87	60.01	1183000.0
2014-05-30	ACWV	ETF	66.4	66.6	66.29	66.47	17900.0
2014-05-30	ACWX	ETF	48.13	48.2158	48.08	48.15	1232549.0
2014-05-30	ADRE	ETF	38.08	38.08	37.745	37.745	13920.0
2014-05-30	AFK	ETF	33.1	33.1	32.9	33.0444	31034.0
2014-05-30	AGG	ETF	109.52	109.67	109.45	109.67	5554700.0
2014-05-30	AGQ	ETF	58.65	58.65	56.25	57.24	551800.0
2014-05-30	AGZ	ETF	112.68	112.77	112.55	112.76	23527.0
2014-05-30	AGZD	ETF	24.925	25.015	24.925	25.015	34600.0
2014-05-30	AIA	ETF	48.45	48.6115	48.31	48.31	23684.0
2014-05-30	AIQ	ETF	29.0	31.0	29.0	29.92	49689.0
2014-05-30	AIRR	ETF	19.03	19.06	18.88	18.92	89100.0
2014-05-30	AIVI	ETF	51.08	51.11	50.94	51.01	43400.0
2014-05-30	ALTL	ETF	34.588	34.588	34.588	34.588	207.0
2014-05-30	AMJ	ETF	49.11	49.62	48.94	49.5	2128923.0
2014-05-30	AMLP	ETF	90.85	91.25	90.55	91.2	594700.0
2014-05-30	ANGL	ETF	28.23	28.23	28.23	28.23	1400.0
2014-05-30	AOA	ETF	46.26	46.28	46.17	46.27	23100.0
2014-05-30	AOK	ETF	32.79	32.86	32.79	32.86	14060.0
2014-05-30	AOM	ETF	35.35	35.36	35.29	35.36	66729.0
2014-05-30	AOR	ETF	39.87	39.87	39.78	39.87	17227.0
2014-05-30	ARGT	ETF	19.91	19.91	19.85	19.85	1200.0
2014-05-30	ASEA	ETF	16.72	16.72	16.6	16.65	18400.0
2014-05-30	ASHR	ETF	22.13	22.16	22.1	22.15	26300.0
2014-05-30	ASHS	ETF	25.71	25.73	25.58	25.63	4900.0
2014-05-30	ATMP	ETF	29.55	29.71	29.47	29.71	29400.0
2014-05-30	AVIV	ETF	27.61	27.94	27.49	27.75	298274.0
2014-05-30	AWAY	ETF	31.15	31.24	30.61	30.8	1942377.0
2014-05-30	BAB	ETF	29.65	29.65	29.52	29.575	67853.0
2014-05-30	BAL	ETF	52.72	53.06	52.7	52.8	10102.0
2014-05-30	BALT	ETF	6.63	6.66	6.32	6.41	554147.0
2014-05-30	BBH	ETF	90.83	91.06	90.06	90.62	62700.0
2014-05-30	BCHP	ETF	20.35	20.404	20.35	20.404	3400.0
2014-05-30	BFOR	ETF	7.5875	7.5875	7.545	7.57	48400.0
2014-05-30	BIB	ETF	40.86	41.03	39.84	40.385	376134.0
2014-05-30	BICK	ETF	25.79	25.79	25.53	25.53	2802.0
2014-05-30	BIL	ETF	91.52	91.54	91.52	91.54	213000.0
2014-05-30	BIS	ETF	656.4	667.6	648.0	657.2	10696.0
2014-05-30	BIV	ETF	84.94	84.99	84.8	84.91	283700.0
2014-05-30	BIZD	ETF	20.01	20.01	19.78	19.88	8300.0
2014-05-30	BJK	ETF	50.11	50.41	49.97	50.04	17200.0
2014-05-30	BKF	ETF	37.7	37.81	37.4801	37.52	89459.0
2014-05-30	BKLN	ETF	24.78	24.84	24.78	24.83	2506400.0

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

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