PREVIEW / etf_daily / 2013-02-04

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-04.parquet
  size:    40 KB
  rows:    970

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-04	SPY	ETF	150.32	151.27	149.43	149.54	159073600.0
2013-02-04	QQQ	ETF	67.25	67.4599	66.46	66.48	48483691.0
2013-02-04	IWM	ETF	89.82	90.18	89.15	89.28	27006300.0
2013-02-04	DIA	ETF	138.81	138.98	138.36	138.57	6536200.0
2013-02-04	GLD	ETF	161.19	162.42	161.15	162.0	7354900.0
2013-02-04	TLT	ETF	116.59	117.28	116.42	117.02	9291900.0
2013-02-04	AADR	ETF	33.73	33.73	33.12	33.12	5100.0
2013-02-04	AAXJ	ETF	60.47	60.49	59.85	59.95	742200.0
2013-02-04	ACTV	ETF	5.76	5.8	5.5	5.58	574501.0
2013-02-04	ACWI	ETF	50.03	50.03	49.6	49.63	1279800.0
2013-02-04	ACWV	ETF	58.03	58.09	57.75	57.84	53900.0
2013-02-04	ACWX	ETF	43.07	43.07	42.67	42.75	334689.0
2013-02-04	ADRE	ETF	40.73	40.82	40.52	40.53	36555.0
2013-02-04	AFK	ETF	31.51	31.77	31.4	31.45	44314.0
2013-02-04	AGEM	ETF	23.65	23.75	23.5601	23.713	1982.0
2013-02-04	AGG	ETF	110.09	110.28	110.09	110.25	805400.0
2013-02-04	AGQ	ETF	188.0	193.2	187.6	190.88	292250.0
2013-02-04	AGZ	ETF	112.99	113.08	112.8999	113.08	9999.0
2013-02-04	AIA	ETF	47.19	47.19	46.6828	46.78	29842.0
2013-02-04	AIQ	ETF	6.59	6.69	6.38	6.67	22799.0
2013-02-04	AIVI	ETF	42.92	42.94	42.35	42.46	38400.0
2013-02-04	AMJ	ETF	43.3	43.5	43.1	43.23	674334.0
2013-02-04	AMLP	ETF	86.0	86.5	86.0	86.4	624120.0
2013-02-04	ANGL	ETF	26.68	27.27	26.57	26.8	11400.0
2013-02-04	AOA	ETF	38.76	38.77	38.53	38.54	33500.0
2013-02-04	AOK	ETF	30.78	30.8779	30.78	30.82	20431.0
2013-02-04	AOM	ETF	32.25	32.46	32.19	32.24	80947.0
2013-02-04	AOR	ETF	34.96	35.01	34.79	34.82	101339.0
2013-02-04	ARB	ETF	46.97	47.0401	46.87	46.87	204604.0
2013-02-04	ARGT	ETF	18.36	18.58	18.24	18.26	9050.0
2013-02-04	ASEA	ETF	17.12	17.18	16.99	17.01	29700.0
2013-02-04	AWAY	ETF	23.84	24.0299	23.64	23.7	275146.0
2013-02-04	BAB	ETF	30.14	30.22	30.11	30.2	245756.0
2013-02-04	BAL	ETF	53.48	53.81	53.3	53.44	216298.0
2013-02-04	BALT	ETF	3.27	3.27	3.15	3.15	50040.0
2013-02-04	BBH	ETF	58.38	58.4	57.36	57.62	32200.0
2013-02-04	BCM	ETF	45.24	45.36	45.21	45.232	2878.0
2013-02-04	BIB	ETF	16.6525	16.7123	16.2003	16.2982	46640.0
2013-02-04	BICK	ETF	25.61	25.61	25.4226	25.44	9118.0
2013-02-04	BIL	ETF	91.6	91.62	91.6	91.6	112550.0
2013-02-04	BIS	ETF	2288.8	2324.8	2288.8	2324.8	26.35
2013-02-04	BIV	ETF	87.04	87.29	87.03	87.21	282200.0
2013-02-04	BJK	ETF	39.06	39.06	38.67	38.69	23500.0
2013-02-04	BKF	ETF	41.73	41.78	41.32	41.41	59012.0
2013-02-04	BKLN	ETF	25.11	25.11	25.06	25.09	2307600.0
2013-02-04	BLNG	ETF	49.9	49.9	49.89	49.9	6985.0
2013-02-04	BLV	ETF	90.81	90.99	90.42	90.82	82900.0
2013-02-04	BMVP	ETF	17.56	17.61	17.51	17.51	3002.0
2013-02-04	BND	ETF	83.22	83.36	83.19	83.34	1742600.0
2013-02-04	BNO	ETF	43.165	43.285	42.99	43.03	55800.0

> showing 50 of 970 rows — these rows as CSV

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