PREVIEW / etf_daily / 2014-06-16

all etf daily files

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

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-16	SPY	ETF	193.89	194.7	193.66	194.29	87424000.0
2014-06-16	QQQ	ETF	92.16	92.67	91.96	92.4	25218557.0
2014-06-16	IWM	ETF	115.49	116.15	115.1	116.15	30051100.0
2014-06-16	DIA	ETF	167.39	167.97	167.15	167.69	3068300.0
2014-06-16	GLD	ETF	122.88	123.01	122.3	122.42	5832800.0
2014-06-16	TLT	ETF	112.21	112.63	112.1	112.43	5184600.0
2014-06-16	AAXJ	ETF	62.51	62.75	62.5	62.64	630400.0
2014-06-16	ACWI	ETF	60.3	60.6	60.3	60.5	245600.0
2014-06-16	ACWV	ETF	66.85	66.96	66.71	66.82	54400.0
2014-06-16	ACWX	ETF	48.6	48.6582	48.494	48.58	80222.0
2014-06-16	ADRE	ETF	39.13	39.13	38.89	38.94	7771.0
2014-06-16	AFK	ETF	33.18	33.43	32.9724	32.99	23388.0
2014-06-16	AGG	ETF	108.87	108.96	108.8	108.82	1308900.0
2014-06-16	AGQ	ETF	62.4	62.8	61.89	62.15	305800.0
2014-06-16	AGZ	ETF	112.35	112.35	112.241	112.2775	11979.0
2014-06-16	AIA	ETF	48.42	48.42	48.33	48.37	9282.0
2014-06-16	AIQ	ETF	28.51	28.51	27.68	27.82	20117.0
2014-06-16	AIRR	ETF	18.88	19.01	18.87	19.0	10400.0
2014-06-16	AIVI	ETF	51.38	51.47	51.38	51.42	27100.0
2014-06-16	AMJ	ETF	50.12	50.7381	50.12	50.66	401221.0
2014-06-16	AMLP	ETF	92.15	92.75	92.0	92.75	778420.0
2014-06-16	ANGL	ETF	28.34	28.34	28.32	28.34	4100.0
2014-06-16	AOA	ETF	46.83	46.83	46.51	46.65	16400.0
2014-06-16	AOK	ETF	32.95	32.95	32.806	32.86	15387.0
2014-06-16	AOM	ETF	35.58	35.58	35.39	35.47	47561.0
2014-06-16	AOR	ETF	40.17	40.17	39.9901	40.08	42267.0
2014-06-16	ARGT	ETF	20.59	20.6	20.13	20.32	9700.0
2014-06-16	ASEA	ETF	16.83	16.83	16.64	16.71	2700.0
2014-06-16	ASHR	ETF	22.68	22.68	22.5	22.58	119400.0
2014-06-16	ASHS	ETF	26.2	26.21	25.98	26.1	7700.0
2014-06-16	ATMP	ETF	29.99	30.57	29.99	30.5	90200.0
2014-06-16	AVIV	ETF	28.35	28.709	28.33	28.49	387604.0
2014-06-16	AWAY	ETF	32.05	32.46	31.39	31.64	1500573.0
2014-06-16	BAB	ETF	29.17	29.26	29.12	29.22	77906.0
2014-06-16	BAL	ETF	52.3838	52.85	52.32	52.376	7377.0
2014-06-16	BALT	ETF	6.31	6.64	6.29	6.62	602796.0
2014-06-16	BBH	ETF	92.59	93.54	91.97	92.49	44300.0
2014-06-16	BCHP	ETF	20.35	20.35	20.35	20.35	350.0
2014-06-16	BCM	ETF	41.25	41.25	41.25	41.25	395.0
2014-06-16	BFOR	ETF	7.665	7.71	7.665	7.705	198000.0
2014-06-16	BIB	ETF	42.655	44.0	42.565	43.295	448384.0
2014-06-16	BICK	ETF	26.48	26.53	26.47	26.5	7130.0
2014-06-16	BIL	ETF	91.5	91.54	91.5	91.54	601050.0
2014-06-16	BIS	ETF	621.2	622.8	603.2	612.0	7172.0
2014-06-16	BIV	ETF	84.23	84.25	84.13	84.21	390900.0
2014-06-16	BIZD	ETF	20.08	20.12	20.04	20.12	12200.0
2014-06-16	BJK	ETF	48.68	48.68	48.22	48.42	7200.0
2014-06-16	BKF	ETF	39.11	39.165	38.96	39.04	522030.0
2014-06-16	BKLN	ETF	24.84	24.86	24.84	24.85	1204100.0
2014-06-16	BLV	ETF	88.94	89.21	88.93	89.08	69100.0

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

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