PREVIEW / etf_daily / 2014-02-11

all etf daily files

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

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-11	SPY	ETF	180.16	182.44	180.04	181.98	117814100.0
2014-02-11	QQQ	ETF	87.94	88.97	87.89	88.8	38682035.0
2014-02-11	IWM	ETF	111.12	112.34	110.87	112.03	44394100.0
2014-02-11	DIA	ETF	158.06	160.09	157.94	159.76	7620400.0
2014-02-11	GLD	ETF	123.38	124.75	123.36	124.36	11546000.0
2014-02-11	TLT	ETF	106.61	106.69	106.16	106.47	5904900.0
2014-02-11	AADR	ETF	36.91	36.91	36.86	36.86	1000.0
2014-02-11	AAXJ	ETF	56.33	57.17	56.33	57.08	880000.0
2014-02-11	ACWI	ETF	55.82	56.6	55.82	56.48	1189300.0
2014-02-11	ACWV	ETF	61.56	62.16	61.17	62.08	35400.0
2014-02-11	ACWX	ETF	44.81	45.3868	44.81	45.31	335414.0
2014-02-11	ADRE	ETF	34.09	34.7	34.09	34.65	43904.0
2014-02-11	AFK	ETF	30.34	30.49	30.14	30.4	50274.0
2014-02-11	AGG	ETF	107.7	107.78	107.63	107.72	1493200.0
2014-02-11	AGQ	ETF	66.23	68.07	66.17	67.49	417500.0
2014-02-11	AGZ	ETF	111.7	111.7	111.56	111.58	11372.0
2014-02-11	AIA	ETF	44.35	44.7204	44.35	44.67	15651.0
2014-02-11	AIQ	ETF	27.76	27.98	27.6	27.68	41800.0
2014-02-11	AIVI	ETF	46.76	47.43	46.73	47.38	6600.0
2014-02-11	AMJ	ETF	46.71	47.41	46.71	47.27	944967.0
2014-02-11	AMLP	ETF	87.9	88.45	87.75	88.35	614040.0
2014-02-11	ANGL	ETF	27.15	27.15	26.98	26.98	1600.0
2014-02-11	AOA	ETF	43.67	44.1	43.66	44.06	18900.0
2014-02-11	AOK	ETF	31.84	32.06	31.84	32.06	20609.0
2014-02-11	AOM	ETF	34.09	34.26	34.07	34.23	25553.0
2014-02-11	AOR	ETF	38.03	38.3	38.01	38.26	166875.0
2014-02-11	ARGT	ETF	17.65	18.03	17.65	18.02	2700.0
2014-02-11	ASEA	ETF	14.94	15.18	14.94	15.17	11500.0
2014-02-11	ASHR	ETF	23.91	23.93	23.81	23.91	452000.0
2014-02-11	ATMP	ETF	27.77	28.9	27.7	28.9	13800.0
2014-02-11	AVIV	ETF	23.68	24.13	23.66	23.93	49408.0
2014-02-11	AWAY	ETF	40.0	40.29	39.76	40.0	568297.0
2014-02-11	BAB	ETF	28.2	28.25	28.126	28.16	213624.0
2014-02-11	BAL	ETF	54.6705	55.94	54.66	55.76	15774.0
2014-02-11	BALT	ETF	5.98	6.44	5.98	6.41	1533196.0
2014-02-11	BBH	ETF	99.7	100.55	99.0	100.39	219500.0
2014-02-11	BCM	ETF	40.01	40.01	39.7499	39.81	7168.0
2014-02-11	BFOR	ETF	7.165	7.2525	7.1625	7.24	355200.0
2014-02-11	BIB	ETF	46.375	47.25	45.435	47.025	952246.0
2014-02-11	BICK	ETF	22.95	22.95	22.95	22.95	380.0
2014-02-11	BIL	ETF	91.52	91.56	91.52	91.54	915250.0
2014-02-11	BIS	ETF	650.0	657.2	632.384	636.0	3025.0
2014-02-11	BIV	ETF	83.4	83.4	83.25	83.29	235900.0
2014-02-11	BIZD	ETF	20.79	20.95	20.79	20.95	1700.0
2014-02-11	BJK	ETF	51.38	52.29	51.25	52.07	53300.0
2014-02-11	BKF	ETF	34.56	35.15	34.51	35.09	52857.0
2014-02-11	BKLN	ETF	24.9	24.91	24.9	24.91	2271000.0
2014-02-11	BLV	ETF	84.91	85.07	84.74	84.92	144900.0
2014-02-11	BMVP	ETF	22.07	22.34	22.07	22.28	5245.0
2014-02-11	BND	ETF	81.03	81.07	80.97	81.03	5401900.0

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

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