PREVIEW / etf_daily / 2014-06-10

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-10.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-10	SPY	ETF	195.34	195.64	194.92	195.6	57129000.0
2014-06-10	QQQ	ETF	92.67	92.96	92.56	92.91	20635286.0
2014-06-10	IWM	ETF	116.63	116.83	115.96	116.67	39799900.0
2014-06-10	DIA	ETF	169.15	169.37	168.84	169.35	2821400.0
2014-06-10	GLD	ETF	121.29	121.47	121.21	121.39	3556600.0
2014-06-10	TLT	ETF	111.04	111.27	110.83	111.02	5986000.0
2014-06-10	AADR	ETF	38.34	38.37	38.34	38.37	500.0
2014-06-10	AAXJ	ETF	63.13	63.28	63.04	63.26	316900.0
2014-06-10	ACWI	ETF	60.83	60.92	60.67	60.92	296900.0
2014-06-10	ACWV	ETF	67.08	67.22	66.91	67.06	198800.0
2014-06-10	ACWX	ETF	48.6	48.78	48.6	48.78	172083.0
2014-06-10	ADRE	ETF	38.96	39.2	38.96	39.131	8511.0
2014-06-10	AFK	ETF	33.47	33.5	33.02	33.41	18447.0
2014-06-10	AGG	ETF	108.66	108.74	108.62	108.62	823300.0
2014-06-10	AGQ	ETF	59.4	59.78	59.36	59.74	214400.0
2014-06-10	AGZ	ETF	112.36	112.43	111.559	112.161	5922.0
2014-06-10	AIA	ETF	48.8	48.904	48.77	48.85	13548.0
2014-06-10	AIQ	ETF	29.95	30.75	29.79	30.05	28945.0
2014-06-10	AIRR	ETF	19.69	19.69	19.49	19.56	29800.0
2014-06-10	AIVI	ETF	51.53	51.71	51.52	51.69	15200.0
2014-06-10	ALTL	ETF	35.2599	35.2599	35.1425	35.1425	840.0
2014-06-10	AMJ	ETF	50.31	50.532	50.08	50.45	334875.0
2014-06-10	AMLP	ETF	92.2	92.75	92.15	92.5	511800.0
2014-06-10	ANGL	ETF	28.23	28.5	28.23	28.49	2300.0
2014-06-10	AOA	ETF	46.93	46.93	46.78	46.9	13300.0
2014-06-10	AOK	ETF	32.8	32.9	32.8	32.9	30244.0
2014-06-10	AOM	ETF	35.55	35.56	35.5001	35.52	28753.0
2014-06-10	AOR	ETF	40.26	40.26	40.1214	40.22	31954.0
2014-06-10	ARGT	ETF	21.47	21.61	21.32	21.35	28900.0
2014-06-10	ASEA	ETF	16.83	16.88	16.81	16.88	19200.0
2014-06-10	ASHR	ETF	22.29	22.36	22.26	22.26	241100.0
2014-06-10	ASHS	ETF	25.78	25.81	25.72	25.75	5100.0
2014-06-10	ATMP	ETF	30.07	30.28	30.07	30.19	177300.0
2014-06-10	AVIV	ETF	29.28	29.33	28.67	28.76	448316.0
2014-06-10	AWAY	ETF	29.66	29.99	28.91	29.52	2206843.0
2014-06-10	BAB	ETF	29.19	29.2	29.12	29.1398	136440.0
2014-06-10	BAL	ETF	52.01	52.6099	52.0	52.5852	3361.0
2014-06-10	BALT	ETF	6.4	6.64	6.35	6.64	376193.0
2014-06-10	BBH	ETF	93.34	94.1	92.9	93.81	113100.0
2014-06-10	BCHP	ETF	20.53	20.54	20.53	20.54	1000.0
2014-06-10	BCM	ETF	40.824	40.824	40.82	40.82	1185.0
2014-06-10	BFOR	ETF	7.765	7.765	7.71	7.7425	92800.0
2014-06-10	BIB	ETF	43.18	43.88	42.45	43.57	479950.0
2014-06-10	BICK	ETF	26.6	26.654	26.56	26.61	3380.0
2014-06-10	BIL	ETF	91.52	91.54	91.52	91.54	153750.0
2014-06-10	BIS	ETF	617.6	624.8	604.064	607.2	7769.0
2014-06-10	BIV	ETF	84.0	84.04	83.91	84.01	400600.0
2014-06-10	BIZD	ETF	19.99	20.11	19.98	20.09	11300.0
2014-06-10	BJK	ETF	47.85	48.04	47.62	47.93	18600.0
2014-06-10	BKF	ETF	39.04	39.32	39.04	39.27	38511.0

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

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