PREVIEW / etf_daily / 2011-07-29

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-29.parquet
  size:    37 KB
  rows:    872

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-07-29	SPY	ETF	128.91	130.55	127.97	129.33	307038400.0
2011-07-29	QQQ	ETF	57.73	58.61	57.44	58.0	82860427.0
2011-07-29	IWM	ETF	78.72	80.18	78.14	79.74	93519600.0
2011-07-29	DIA	ETF	121.08	122.23	120.64	121.13	16015400.0
2011-07-29	GLD	ETF	158.43	159.25	157.68	158.29	17122800.0
2011-07-29	TLT	ETF	96.89	98.53	96.78	97.92	19582400.0
2011-07-29	AADR	ETF	30.64	30.64	30.64	30.64	100.0
2011-07-29	AAXJ	ETF	61.99	62.64	61.82	62.32	178400.0
2011-07-29	ACTV	ETF	18.0	18.61	17.95	18.15	85069.0
2011-07-29	ACWI	ETF	47.01	47.51	46.8	47.15	296400.0
2011-07-29	ACWX	ETF	43.69	44.12	43.51	43.83	86294.0
2011-07-29	ADRE	ETF	45.26	45.76	45.08	45.58	50839.0
2011-07-29	AFK	ETF	31.21	31.5008	31.13	31.3755	16770.0
2011-07-29	AGEM	ETF	25.45	25.92	25.428	25.61	8315.0
2011-07-29	AGG	ETF	107.8	108.2	107.7	108.16	1400700.0
2011-07-29	AGQ	ETF	432.26	436.28	421.42	425.6	612550.0
2011-07-29	AGZ	ETF	110.83	111.31	110.83	111.31	13113.0
2011-07-29	AIA	ETF	46.37	46.85	46.37	46.68	27211.0
2011-07-29	AIQ	ETF	16.55	18.15	16.45	18.05	33915.0
2011-07-29	AIS	ETF	2.31	2.3598	2.22	2.32	1331723.0
2011-07-29	AIVI	ETF	45.44	45.83	45.22	45.5	19600.0
2011-07-29	AMJ	ETF	36.13	36.5	35.8408	36.5	1782105.0
2011-07-29	AMLP	ETF	78.7	79.45	78.45	79.3	81760.0
2011-07-29	AOA	ETF	34.94	35.32	34.81	35.11	5900.0
2011-07-29	AOK	ETF	29.33	29.447	29.26	29.42	31539.0
2011-07-29	AOM	ETF	30.46	30.64	30.43	30.5792	20526.0
2011-07-29	AOR	ETF	32.16	32.372	32.05	32.28	47270.0
2011-07-29	ARB	ETF	39.42	40.11	38.63	39.12	182162.0
2011-07-29	ARGT	ETF	28.82	28.86	28.82	28.86	800.0
2011-07-29	ASEA	ETF	17.31	17.43	17.2	17.4	13500.0
2011-07-29	AWAY	ETF	40.88	40.88	38.86	39.31	134936.0
2011-07-29	BAB	ETF	26.85	27.0199	26.81	26.96	272491.0
2011-07-29	BAL	ETF	61.0	63.1	60.85	62.789	76853.0
2011-07-29	BALT	ETF	5.5	5.71	5.3	5.49	143193.0
2011-07-29	BBH	ETF	34.6367	34.74	34.1233	34.5933	27000.0
2011-07-29	BCM	ETF	48.03	48.07	47.97	48.07	1000.0
2011-07-29	BIB	ETF	8.835	9.1715	8.6512	9.0887	217072.0
2011-07-29	BICK	ETF	30.81	31.3	30.8	31.121	51803.0
2011-07-29	BIL	ETF	91.7	91.72	91.7	91.72	1060950.0
2011-07-29	BIS	ETF	6179.2	6252.8	6177.6	6252.784	40.0
2011-07-29	BITS	ETF	22.0	22.04	21.3232	21.88	690.0
2011-07-29	BIV	ETF	85.45	85.94	85.34	85.84	109200.0
2011-07-29	BJK	ETF	36.21	36.6	35.96	36.32	318600.0
2011-07-29	BKF	ETF	46.17	46.86	46.05	46.71	115496.0
2011-07-29	BKLN	ETF	24.74	24.76	24.69	24.7	107600.0
2011-07-29	BLNG	ETF	52.21	52.21	51.9585	51.9585	1165.0
2011-07-29	BLV	ETF	82.06	83.12	82.05	83.08	23900.0
2011-07-29	BMVP	ETF	14.8	15.03	14.68	14.92	25393.0
2011-07-29	BND	ETF	81.96	82.29	81.86	82.26	1959000.0
2011-07-29	BNO	ETF	38.815	39.105	38.735	38.975	168200.0

> showing 50 of 872 rows — these rows as CSV

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