PREVIEW / etf_daily / 2014-06-13

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-13.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-13	SPY	ETF	193.92	194.32	193.3	194.13	82017000.0
2014-06-13	QQQ	ETF	92.47	92.55	91.92	92.32	39449997.0
2014-06-13	IWM	ETF	115.67	115.91	114.66	115.59	33779400.0
2014-06-13	DIA	ETF	167.54	167.83	167.13	167.62	2708700.0
2014-06-13	GLD	ETF	122.57	123.04	122.51	122.96	4026600.0
2014-06-13	TLT	ETF	111.57	112.62	111.53	112.15	5412500.0
2014-06-13	AAXJ	ETF	62.67	62.76	62.47	62.74	329800.0
2014-06-13	ACWI	ETF	60.32	60.55	60.32	60.52	637700.0
2014-06-13	ACWV	ETF	66.93	66.93	66.17	66.79	100500.0
2014-06-13	ACWX	ETF	48.65	48.67	48.52	48.61	61525.0
2014-06-13	ADRE	ETF	39.06	39.1965	39.06	39.1899	5231.0
2014-06-13	AFK	ETF	33.08	33.2201	32.65	32.99	48420.0
2014-06-13	AGG	ETF	108.75	108.91	108.71	108.88	1040900.0
2014-06-13	AGQ	ETF	61.87	62.82	61.67	62.63	279900.0
2014-06-13	AGZ	ETF	112.2375	112.3599	112.181	112.3199	6330.0
2014-06-13	AGZD	ETF	25.03	25.04	25.03	25.04	600.0
2014-06-13	AIA	ETF	48.32	48.48	48.29	48.48	69045.0
2014-06-13	AIQ	ETF	29.25	30.268	28.5	28.74	20681.0
2014-06-13	AIRR	ETF	19.12	19.16	18.99	19.02	18000.0
2014-06-13	AIVI	ETF	51.43	51.6	51.36	51.47	10800.0
2014-06-13	AMJ	ETF	50.0	50.19	49.72	50.19	182087.0
2014-06-13	AMLP	ETF	92.05	92.25	91.55	92.05	506580.0
2014-06-13	ANGL	ETF	28.35	28.35	28.3	28.3	400.0
2014-06-13	AOA	ETF	46.65	46.68	46.57	46.66	52800.0
2014-06-13	AOK	ETF	32.79	32.86	32.78	32.86	14586.0
2014-06-13	AOM	ETF	35.38	35.46	35.38	35.44	28138.0
2014-06-13	AOR	ETF	39.97	40.0899	39.9501	40.0	24824.0
2014-06-13	ARGT	ETF	21.19	21.19	20.91	21.1	4600.0
2014-06-13	ASEA	ETF	16.75	16.75	16.69	16.72	2100.0
2014-06-13	ASHR	ETF	22.39	22.48	22.37	22.48	155400.0
2014-06-13	ASHS	ETF	26.12	26.13	26.07	26.08	6900.0
2014-06-13	ATMP	ETF	29.95	29.99	29.78	29.99	48600.0
2014-06-13	AVIV	ETF	28.15	28.38	28.03	28.34	275005.0
2014-06-13	AWAY	ETF	31.73	32.43	30.72	32.25	3979208.0
2014-06-13	BAB	ETF	29.12	29.2377	29.111	29.16	53436.0
2014-06-13	BAL	ETF	52.529	52.6272	52.529	52.6	400.0
2014-06-13	BALT	ETF	6.29	6.37	6.19	6.27	505435.0
2014-06-13	BBH	ETF	93.12	93.12	91.93	92.55	47100.0
2014-06-13	BCHP	ETF	20.3001	20.41	20.3001	20.41	2636.0
2014-06-13	BFOR	ETF	7.6775	7.69	7.6425	7.6825	140000.0
2014-06-13	BIB	ETF	43.25	43.2596	42.25	43.07	329058.0
2014-06-13	BICK	ETF	26.44	26.61	26.44	26.53	7157.0
2014-06-13	BIL	ETF	91.5	91.52	91.5	91.52	382650.0
2014-06-13	BIS	ETF	613.6	628.0	610.0	616.4	15034.0
2014-06-13	BIV	ETF	84.0	84.23	83.99	84.18	156500.0
2014-06-13	BIZD	ETF	20.25	20.25	20.06	20.09	11800.0
2014-06-13	BJK	ETF	48.39	48.92	48.39	48.92	8900.0
2014-06-13	BKF	ETF	39.16	39.33	39.0	39.32	90916.0
2014-06-13	BKLN	ETF	24.84	24.85	24.82	24.85	2254600.0
2014-06-13	BLV	ETF	88.59	89.18	88.52	88.97	27400.0

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

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