PREVIEW / etf_daily / 2013-02-06

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-06.parquet
  size:    39 KB
  rows:    960

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-06	SPY	ETF	150.52	151.26	150.41	151.16	138762800.0
2013-02-06	QQQ	ETF	67.22	67.55	67.04	67.24	43595136.0
2013-02-06	IWM	ETF	89.65	90.52	89.57	90.46	24297800.0
2013-02-06	DIA	ETF	138.88	139.7	138.88	139.58	3113900.0
2013-02-06	GLD	ETF	162.13	162.63	161.99	162.39	6138700.0
2013-02-06	TLT	ETF	116.52	116.97	116.05	116.93	5892000.0
2013-02-06	AADR	ETF	33.4	33.4	33.4	33.4	100.0
2013-02-06	AAXJ	ETF	59.86	60.13	59.63	60.1	1050400.0
2013-02-06	ACTV	ETF	5.5	5.74	5.49	5.68	510528.0
2013-02-06	ACWI	ETF	49.76	49.99	49.71	49.99	824000.0
2013-02-06	ACWV	ETF	57.99	58.29	57.99	58.18	20400.0
2013-02-06	ACWX	ETF	42.74	42.97	42.7	42.97	254305.0
2013-02-06	ADRE	ETF	40.22	40.29	40.14	40.29	61832.0
2013-02-06	AFK	ETF	32.0	32.0	31.44	31.75	38352.0
2013-02-06	AGEM	ETF	23.58	23.58	23.3901	23.5699	1790.0
2013-02-06	AGG	ETF	110.12	110.26	110.11	110.21	1229600.0
2013-02-06	AGQ	ETF	190.0	192.76	189.8	192.04	175400.0
2013-02-06	AGZ	ETF	112.8301	113.05	112.8301	113.05	13810.0
2013-02-06	AIA	ETF	46.67	46.77	46.51	46.7699	42043.0
2013-02-06	AIQ	ETF	6.6	6.69	6.6	6.66	12297.0
2013-02-06	AIVI	ETF	42.26	42.62	42.26	42.62	53800.0
2013-02-06	AMJ	ETF	42.89	43.07	42.77	42.89	695587.0
2013-02-06	AMLP	ETF	86.2	86.2	85.75	85.9	767980.0
2013-02-06	ANGL	ETF	26.84	26.93	26.84	26.93	200.0
2013-02-06	AOA	ETF	38.69	38.83	38.68	38.83	16300.0
2013-02-06	AOK	ETF	30.85	30.9	30.8401	30.9	55795.0
2013-02-06	AOM	ETF	32.47	32.47	32.26	32.38	33187.0
2013-02-06	AOR	ETF	34.96	35.0	34.93	34.96	10023.0
2013-02-06	ARB	ETF	46.91	47.1	46.91	47.04	650294.0
2013-02-06	ARGT	ETF	18.08	18.3	18.06	18.3	4450.0
2013-02-06	ASEA	ETF	16.99	17.01	16.9	17.01	36700.0
2013-02-06	AWAY	ETF	23.75	24.08	23.7	24.06	299383.0
2013-02-06	BAB	ETF	30.09	30.15	30.02	30.14	256473.0
2013-02-06	BAL	ETF	53.15	53.7	53.02	53.651	61835.0
2013-02-06	BALT	ETF	3.17	3.17	3.07	3.16	30862.0
2013-02-06	BBH	ETF	58.37	58.61	57.81	58.14	37700.0
2013-02-06	BCM	ETF	45.13	45.284	45.13	45.19	39361.0
2013-02-06	BIB	ETF	16.71	16.7895	16.3575	16.4875	46276.0
2013-02-06	BICK	ETF	25.25	25.25	25.208	25.248	840.0
2013-02-06	BIL	ETF	91.62	91.62	91.6	91.62	282550.0
2013-02-06	BIS	ETF	2276.0	2281.6	2276.0	2281.6	38.75
2013-02-06	BIV	ETF	87.26	87.35	87.14	87.29	274500.0
2013-02-06	BJK	ETF	38.09	38.3	37.87	38.3	218500.0
2013-02-06	BKF	ETF	41.34	41.47	41.13	41.47	144514.0
2013-02-06	BKLN	ETF	25.07	25.07	25.05	25.06	2544800.0
2013-02-06	BLV	ETF	90.76	91.08	90.58	91.07	44200.0
2013-02-06	BMVP	ETF	17.74	17.81	17.62	17.81	27482.0
2013-02-06	BND	ETF	83.3	83.43	83.27	83.4	2416200.0
2013-02-06	BNO	ETF	43.215	43.6	43.15	43.55	74000.0
2013-02-06	BOIL	ETF	801600.0	814200.0	794000.0	806000.0	10.6

> showing 50 of 960 rows — these rows as CSV

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