PREVIEW / etf_daily / 2011-09-13

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-13.parquet
  size:    36 KB
  rows:    866

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
2011-09-13	SPY	ETF	117.05	118.18	116.22	117.74	272514700.0
2011-09-13	QQQ	ETF	54.08	54.69	53.8	54.58	59019983.0
2011-09-13	IWM	ETF	68.54	69.46	67.83	69.18	84144100.0
2011-09-13	DIA	ETF	110.68	111.37	109.82	110.92	10836700.0
2011-09-13	GLD	ETF	177.52	179.54	176.29	178.54	17246400.0
2011-09-13	TLT	ETF	113.4	113.59	112.11	112.21	9282400.0
2011-09-13	AADR	ETF	28.04	28.1	27.9	28.1	2100.0
2011-09-13	AAXJ	ETF	52.76	53.12	52.38	53.03	270800.0
2011-09-13	ACTV	ETF	14.44	15.16	14.39	14.78	47069.0
2011-09-13	ACWI	ETF	40.85	41.32	40.68	41.22	456600.0
2011-09-13	ACWX	ETF	36.69	37.0	36.45	36.93	196973.0
2011-09-13	ADRE	ETF	39.75	39.904	39.38	39.84	47238.0
2011-09-13	AFK	ETF	28.77	28.99	28.5	28.9	6253.0
2011-09-13	AGEM	ETF	22.06	22.18	21.954	22.18	1559.0
2011-09-13	AGG	ETF	110.04	110.06	109.85	109.98	701400.0
2011-09-13	AGQ	ETF	428.28	442.7	423.12	434.8	425100.0
2011-09-13	AGZ	ETF	112.44	112.6355	112.34	112.42	41885.0
2011-09-13	AIA	ETF	39.95	40.15	39.64	40.08	97195.0
2011-09-13	AIQ	ETF	6.3995	6.6	6.0	6.5	30639.0
2011-09-13	AIS	ETF	2.31	2.31	2.26	2.28	313418.0
2011-09-13	AIVI	ETF	38.64	39.09	38.4	38.98	44900.0
2011-09-13	AMJ	ETF	34.82	34.94	34.51	34.81	502220.0
2011-09-13	AMLP	ETF	76.4	77.05	76.4	77.0	66920.0
2011-09-13	AOA	ETF	31.53	31.73	31.35	31.69	5600.0
2011-09-13	AOK	ETF	28.95	28.95	28.85	28.91	44275.0
2011-09-13	AOM	ETF	29.34	29.45	28.99	29.45	22457.0
2011-09-13	AOR	ETF	30.19	30.31	30.125	30.3	10396.0
2011-09-13	ARB	ETF	34.55	35.77	34.25	35.42	140033.0
2011-09-13	ARGT	ETF	22.84	22.84	22.84	22.84	1550.0
2011-09-13	ASEA	ETF	15.4	15.5	15.37	15.38	16400.0
2011-09-13	AWAY	ETF	40.4	41.44	39.8	40.46	33268.0
2011-09-13	BAB	ETF	28.21	28.32	28.042	28.26	122203.0
2011-09-13	BAL	ETF	70.56	70.56	69.03	69.99	58514.0
2011-09-13	BALT	ETF	5.06	5.32	5.06	5.3	209509.0
2011-09-13	BBH	ETF	32.1333	32.41	32.0133	32.41	5400.0
2011-09-13	BCM	ETF	47.2968	47.2968	47.2968	47.2968	148.0
2011-09-13	BIB	ETF	7.2237	7.4115	7.1638	7.3676	33864.0
2011-09-13	BICK	ETF	25.37	25.432	25.0739	25.35	25415.0
2011-09-13	BIL	ETF	91.7	91.7	91.68	91.68	568550.0
2011-09-13	BIS	ETF	6708.8	6708.8	6694.4	6694.4	2.56
2011-09-13	BITS	ETF	20.96	21.08	20.0	20.24	575.0
2011-09-13	BIV	ETF	88.27	88.27	88.0	88.18	85800.0
2011-09-13	BJK	ETF	32.04	32.19	31.87	32.17	13600.0
2011-09-13	BKF	ETF	39.1	39.2171	38.6	38.98	206063.0
2011-09-13	BKLN	ETF	23.49	23.49	23.22	23.25	125000.0
2011-09-13	BLV	ETF	89.61	89.61	88.01	88.94	58600.0
2011-09-13	BMVP	ETF	13.07	13.19	13.07	13.16	8977.0
2011-09-13	BND	ETF	83.68	83.68	83.44	83.54	995300.0
2011-09-13	BNO	ETF	36.99	37.19	36.81	36.945	51600.0
2011-09-13	BRF	ETF	47.68	47.68	46.51	46.82	350814.0

> showing 50 of 866 rows — these rows as CSV

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