PREVIEW / etf_daily / 2014-02-12

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-12.parquet
  size:    43 KB
  rows:    1,067

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-02-12	SPY	ETF	182.25	182.83	181.71	182.07	94717700.0
2014-02-12	QQQ	ETF	88.97	89.1695	88.7	88.97	32533008.0
2014-02-12	IWM	ETF	112.2	113.01	111.97	112.47	42307500.0
2014-02-12	DIA	ETF	160.0	160.45	159.34	159.71	5249600.0
2014-02-12	GLD	ETF	124.4	124.98	124.13	124.43	6651900.0
2014-02-12	TLT	ETF	106.17	106.21	105.62	105.92	6723300.0
2014-02-12	AADR	ETF	37.11	37.11	36.51	36.56	1400.0
2014-02-12	AAXJ	ETF	57.48	57.72	57.2	57.25	853900.0
2014-02-12	ACWI	ETF	56.61	56.78	56.44	56.57	794700.0
2014-02-12	ACWV	ETF	61.97	62.3	61.97	62.05	23200.0
2014-02-12	ACWX	ETF	45.43	45.52	45.29	45.38	80768.0
2014-02-12	ADRE	ETF	34.68	34.779	34.401	34.44	13178.0
2014-02-12	AFK	ETF	30.49	30.49	30.11	30.25	10512.0
2014-02-12	AGG	ETF	107.58	107.61	107.45	107.54	714100.0
2014-02-12	AGQ	ETF	67.92	68.81	67.27	67.32	482000.0
2014-02-12	AGZ	ETF	111.45	111.66	111.45	111.47	7079.0
2014-02-12	AGZD	ETF	25.045	25.045	25.045	25.045	800.0
2014-02-12	AIA	ETF	44.88	45.03	44.684	44.73	12359.0
2014-02-12	AIQ	ETF	27.62	28.29	27.6	27.7	26213.0
2014-02-12	AIVI	ETF	47.31	47.47	47.24	47.34	12700.0
2014-02-12	ALTL	ETF	32.6552	32.69	32.6552	32.69	5600.0
2014-02-12	AMJ	ETF	47.34	47.5	47.13	47.2	402337.0
2014-02-12	AMLP	ETF	88.45	88.6	88.2	88.4	648500.0
2014-02-12	ANGL	ETF	27.0	27.19	27.0	27.19	3600.0
2014-02-12	AOA	ETF	44.16	44.25	44.04	44.11	22100.0
2014-02-12	AOK	ETF	31.95	32.029	31.95	31.97	22292.0
2014-02-12	AOM	ETF	34.27	34.29	34.18	34.23	42416.0
2014-02-12	AOR	ETF	38.31	38.36	38.208	38.27	126257.0
2014-02-12	ARGT	ETF	18.21	18.34	18.08	18.19	5200.0
2014-02-12	ASEA	ETF	15.21	15.21	15.1	15.11	22600.0
2014-02-12	ASHR	ETF	24.0	24.04	23.89	23.92	197400.0
2014-02-12	ATMP	ETF	27.96	27.96	27.73	27.74	11000.0
2014-02-12	AVIV	ETF	23.94	24.05	23.75	23.83	41338.0
2014-02-12	AWAY	ETF	40.09	41.95	40.0	41.53	1356073.0
2014-02-12	BAB	ETF	28.16	28.17	28.12	28.13	53132.0
2014-02-12	BAL	ETF	55.74	56.15	55.44	55.51	12269.0
2014-02-12	BALT	ETF	6.41	6.53	6.3	6.48	835976.0
2014-02-12	BBH	ETF	100.72	101.59	100.48	101.1	285700.0
2014-02-12	BCM	ETF	40.048	40.048	39.86	39.95	36368.0
2014-02-12	BFOR	ETF	7.25	7.2775	7.24	7.2675	164000.0
2014-02-12	BIB	ETF	48.485	48.485	47.22	47.475	718344.0
2014-02-12	BICK	ETF	23.23	23.24	23.0612	23.0612	584.0
2014-02-12	BIL	ETF	91.54	91.56	91.54	91.56	148050.0
2014-02-12	BIS	ETF	630.0	632.0	619.584	627.2	2030.5
2014-02-12	BIV	ETF	83.18	83.23	83.06	83.15	290700.0
2014-02-12	BIZD	ETF	20.87	21.03	20.87	20.98	2000.0
2014-02-12	BJK	ETF	52.56	52.64	52.07	52.26	18900.0
2014-02-12	BKF	ETF	35.19	35.3696	34.86	34.88	166725.0
2014-02-12	BKLN	ETF	24.89	24.92	24.88	24.92	3161600.0
2014-02-12	BLV	ETF	84.75	84.75	84.43	84.56	54200.0

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

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