PREVIEW / etf_daily / 2013-02-11

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-11.parquet
  size:    40 KB
  rows:    967

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
2013-02-11	SPY	ETF	151.74	151.9	151.39	151.77	73775000.0
2013-02-11	QQQ	ETF	68.02	68.06	67.78	68.01	17650349.0
2013-02-11	IWM	ETF	90.71	90.75	90.26	90.7	15722100.0
2013-02-11	DIA	ETF	139.62	139.68	139.21	139.52	2542800.0
2013-02-11	GLD	ETF	159.78	159.98	159.25	159.7	12083500.0
2013-02-11	TLT	ETF	117.05	117.38	116.92	117.03	3679900.0
2013-02-11	AADR	ETF	33.16	33.16	33.16	33.16	200.0
2013-02-11	AAXJ	ETF	60.1	60.24	59.87	60.14	677900.0
2013-02-11	ACTV	ETF	6.03	6.03	5.52	5.61	1973945.0
2013-02-11	ACWI	ETF	50.06	50.06	49.89	49.98	221500.0
2013-02-11	ACWV	ETF	58.43	58.52	58.31	58.42	21000.0
2013-02-11	ACWX	ETF	42.88	42.88	42.7	42.84	117561.0
2013-02-11	ADRE	ETF	40.22	40.22	40.04	40.1	22715.0
2013-02-11	AFK	ETF	31.38	31.52	31.3501	31.47	48105.0
2013-02-11	AGEM	ETF	23.44	23.44	23.44	23.44	531.0
2013-02-11	AGG	ETF	110.25	110.25	110.14	110.17	1384100.0
2013-02-11	AGQ	ETF	182.56	183.32	179.96	182.04	318475.0
2013-02-11	AGZ	ETF	113.1	113.12	112.968	113.04	15309.0
2013-02-11	AIA	ETF	47.03	47.23	46.99	47.2184	12218.0
2013-02-11	AIQ	ETF	6.86	7.05	6.55	6.91	23519.0
2013-02-11	AIVI	ETF	42.53	42.54	42.3	42.5	34100.0
2013-02-11	ALTL	ETF	28.08	28.16	28.08	28.16	800.0
2013-02-11	AMJ	ETF	43.0	43.36	43.0	43.32	1273478.0
2013-02-11	AMLP	ETF	84.6	85.55	84.6	85.3	387020.0
2013-02-11	ANGL	ETF	26.73	26.9	26.73	26.89	1100.0
2013-02-11	AOA	ETF	38.95	38.95	38.81	38.88	11200.0
2013-02-11	AOK	ETF	30.83	30.9	30.83	30.89	18132.0
2013-02-11	AOM	ETF	32.31	32.35	32.31	32.35	24972.0
2013-02-11	AOR	ETF	35.0	35.029	34.9705	35.02	17547.0
2013-02-11	ARB	ETF	47.0	47.1	46.95	47.0	248046.0
2013-02-11	ARGT	ETF	17.92	17.96	17.6	17.74	3100.0
2013-02-11	ASEA	ETF	17.1	17.1	17.08	17.08	7800.0
2013-02-11	AWAY	ETF	24.39	24.45	23.9	24.39	319838.0
2013-02-11	BAB	ETF	30.17	30.22	30.17	30.2	135911.0
2013-02-11	BAL	ETF	54.06	54.4	53.85	54.3505	39008.0
2013-02-11	BALT	ETF	3.1	3.1	3.02	3.09	23447.0
2013-02-11	BBH	ETF	58.12	58.29	57.62	57.69	31900.0
2013-02-11	BIB	ETF	16.6625	16.7	16.3077	16.34	37672.0
2013-02-11	BICK	ETF	25.19	25.22	25.1656	25.2	8296.0
2013-02-11	BIL	ETF	91.6	91.62	91.6	91.62	205000.0
2013-02-11	BIS	ETF	2289.6	2304.8	2275.072	2304.8	127.5
2013-02-11	BIV	ETF	87.41	87.44	87.32	87.37	255200.0
2013-02-11	BJK	ETF	39.03	39.12	38.93	38.99	2800.0
2013-02-11	BKF	ETF	41.16	41.16	40.92	41.03	49550.0
2013-02-11	BKLN	ETF	25.0	25.0	24.98	24.99	1555800.0
2013-02-11	BLV	ETF	91.11	91.4	91.07	91.26	93800.0
2013-02-11	BMVP	ETF	17.953	17.953	17.877	17.914	4756.0
2013-02-11	BND	ETF	83.31	83.37	83.28	83.29	2254800.0
2013-02-11	BNO	ETF	43.94	44.08	43.815	44.015	83600.0
2013-02-11	BOIL	ETF	708800.0	738400.0	706400.0	733600.0	12.8

> showing 50 of 967 rows — these rows as CSV

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