PREVIEW / etf_daily / 2011-05-27

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-27.parquet
  size:    36 KB
  rows:    844

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-05-27	SPY	ETF	133.37	133.87	132.96	133.51	120921900.0
2011-05-27	QQQ	ETF	57.24	57.49	57.19	57.43	30132087.0
2011-05-27	IWM	ETF	83.46	83.93	83.26	83.65	46619400.0
2011-05-27	DIA	ETF	124.18	124.65	123.98	124.23	4402800.0
2011-05-27	GLD	ETF	149.02	149.92	148.96	149.7	10186200.0
2011-05-27	TLT	ETF	96.13	96.51	95.88	96.47	5390600.0
2011-05-27	AADR	ETF	31.52	31.52	31.52	31.52	400.0
2011-05-27	AAXJ	ETF	62.64	62.77	62.37	62.51	254400.0
2011-05-27	ACTV	ETF	16.05	18.8	15.9	18.8	411754.0
2011-05-27	ACWI	ETF	48.62	48.99	48.62	48.83	358700.0
2011-05-27	ACWX	ETF	45.41	45.53	45.31	45.39	65310.0
2011-05-27	ADRE	ETF	46.31	46.59	46.31	46.45	28637.0
2011-05-27	AFK	ETF	33.0899	33.096	32.883	32.8942	4321.0
2011-05-27	AGG	ETF	107.39	107.51	107.33	107.43	509700.0
2011-05-27	AGQ	ETF	403.48	407.68	392.0	402.0	980250.0
2011-05-27	AGZ	ETF	110.63	110.66	110.47	110.66	12558.0
2011-05-27	AIA	ETF	47.68	47.76	47.53	47.55	21101.0
2011-05-27	AIQ	ETF	21.35	21.45	21.05	21.4	15309.0
2011-05-27	AIS	ETF	1.84	1.84	1.81	1.82	536584.0
2011-05-27	AIVI	ETF	47.99	48.13	47.87	47.96	9000.0
2011-05-27	AMJ	ETF	36.74	36.77	36.48	36.72	597863.0
2011-05-27	AMLP	ETF	79.7	79.85	79.35	79.5	126260.0
2011-05-27	AOA	ETF	36.18	36.28	36.18	36.26	4000.0
2011-05-27	AOK	ETF	29.4892	29.5	29.46	29.4704	2415.0
2011-05-27	AOM	ETF	30.87	30.9	30.853	30.9	5948.0
2011-05-27	AOR	ETF	32.89	32.94	32.84	32.89	5747.0
2011-05-27	ARB	ETF	42.05	42.17	41.7	41.87	75162.0
2011-05-27	ASEA	ETF	16.34	16.45	16.22	16.41	1700.0
2011-05-27	BAB	ETF	26.54	26.63	26.53	26.63	97027.0
2011-05-27	BAL	ETF	84.59	85.298	84.0	84.77	30120.0
2011-05-27	BALT	ETF	6.41	6.67	6.15	6.38	309138.0
2011-05-27	BBH	ETF	34.6433	34.8333	34.6433	34.6933	9600.0
2011-05-27	BIB	ETF	9.8613	9.8978	9.7975	9.895	53064.0
2011-05-27	BICK	ETF	32.36	32.52	32.35	32.4	55604.0
2011-05-27	BIL	ETF	91.7	91.72	91.7	91.72	161350.0
2011-05-27	BIS	ETF	5926.4	5926.4	5884.8	5886.08	5.25
2011-05-27	BITS	ETF	23.6	24.12	23.04	24.12	350.0
2011-05-27	BIV	ETF	84.44	84.58	84.4	84.55	69300.0
2011-05-27	BJK	ETF	34.56	34.56	34.36	34.36	3600.0
2011-05-27	BKF	ETF	47.9	48.13	47.87	48.11	96141.0
2011-05-27	BKLN	ETF	25.07	25.07	25.0	25.05	146800.0
2011-05-27	BLV	ETF	81.59	81.93	81.52	81.89	9600.0
2011-05-27	BMVP	ETF	15.83	15.86	15.78	15.8	4708.0
2011-05-27	BND	ETF	81.59	81.62	81.54	81.59	774700.0
2011-05-27	BNO	ETF	38.33	38.405	38.105	38.26	68600.0
2011-05-27	BOSS	ETF	58.48	59.18	58.48	59.18	100.0
2011-05-27	BRF	ETF	56.14	56.67	55.7	56.67	204275.0
2011-05-27	BSCE	ETF	21.23	21.27	21.195	21.21	14960.0
2011-05-27	BSV	ETF	81.08	81.16	81.04	81.15	407600.0
2011-05-27	BTF	ETF	84.64999999999999	84.8	84.39999999999999	84.8	2090.0

> showing 50 of 844 rows — these rows as CSV

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