PREVIEW / etf_daily / 2011-09-27

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-27.parquet
  size:    36 KB
  rows:    873

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-27	SPY	ETF	118.53	119.56	116.84	117.54	311753900.0
2011-09-27	QQQ	ETF	55.7	56.2	54.98	55.35	81148487.0
2011-09-27	IWM	ETF	67.85	69.39	67.27	67.8	93999600.0
2011-09-27	DIA	ETF	112.41	113.45	111.09	111.71	13564400.0
2011-09-27	GLD	ETF	161.61	162.29	159.91	160.63	25124200.0
2011-09-27	TLT	ETF	116.75	117.3	116.26	117.07	13589600.0
2011-09-27	AADR	ETF	26.93	27.41	26.93	27.41	6400.0
2011-09-27	AAXJ	ETF	49.72	50.42	49.34	49.56	434100.0
2011-09-27	ACTV	ETF	15.47	16.0	14.74	14.95	81522.0
2011-09-27	ACWI	ETF	41.12	41.52	40.56	40.78	619300.0
2011-09-27	ACWX	ETF	36.57	37.01	36.23	36.37	281397.0
2011-09-27	ADRE	ETF	37.83	38.3675	37.59	37.79	69227.0
2011-09-27	AFK	ETF	26.92	27.14	26.7	26.71	9306.0
2011-09-27	AGEM	ETF	21.01	21.19	20.99	21.05	4109.0
2011-09-27	AGG	ETF	109.72	109.85	109.61	109.83	1287400.0
2011-09-27	AGQ	ETF	257.12	258.48	233.44	242.46	1497850.0
2011-09-27	AGZ	ETF	112.5	112.58	112.3	112.44	11399.0
2011-09-27	AIA	ETF	38.75	39.1692	38.34	38.9723	39099.0
2011-09-27	AIQ	ETF	6.4	6.4	5.95	6.05	75889.0
2011-09-27	AIS	ETF	2.45	2.48	2.34	2.39	977182.0
2011-09-27	AIVI	ETF	39.32	39.91	39.05	39.24	130500.0
2011-09-27	AMJ	ETF	34.77	36.0	34.65	34.81	612251.0
2011-09-27	AMLP	ETF	78.2	78.75	77.05	77.15	182400.0
2011-09-27	AOA	ETF	31.6	31.82	31.28	31.36	13700.0
2011-09-27	AOK	ETF	29.1	29.1	28.81	28.86	21921.0
2011-09-27	AOM	ETF	29.2	29.38	29.19	29.23	35242.0
2011-09-27	AOR	ETF	30.22	30.31	30.0	30.0	17748.0
2011-09-27	ARB	ETF	37.15	38.46	36.93	37.48	136478.0
2011-09-27	ARGT	ETF	21.2	21.24	21.2	21.24	300.0
2011-09-27	ASEA	ETF	14.38	14.53	14.26	14.28	5600.0
2011-09-27	AWAY	ETF	36.49	38.58	35.575	37.21	209304.0
2011-09-27	BAB	ETF	28.73	28.73	28.24	28.31	297186.0
2011-09-27	BAL	ETF	63.0799	63.22	61.41	61.49	43979.0
2011-09-27	BALT	ETF	5.0	5.25	4.95	5.03	141996.0
2011-09-27	BBH	ETF	33.2567	33.7233	33.2567	33.4167	27900.0
2011-09-27	BCM	ETF	43.46	43.58	43.27	43.37	4710.0
2011-09-27	BIB	ETF	7.5812	7.7611	7.5187	7.5187	59168.0
2011-09-27	BICK	ETF	23.22	23.84	23.22	23.4	13451.0
2011-09-27	BIL	ETF	91.68	91.7	91.68	91.68	404150.0
2011-09-27	BIS	ETF	6448.0	6577.6	6342.4	6550.4	21.55
2011-09-27	BITS	ETF	22.0	22.16	21.28	22.16	1758.0
2011-09-27	BIV	ETF	87.46	87.64	87.35	87.55	290000.0
2011-09-27	BJK	ETF	30.69	31.19	30.42	30.5	27900.0
2011-09-27	BKF	ETF	36.32	36.8	36.091	36.17	146685.0
2011-09-27	BKLN	ETF	23.32	23.33	23.23	23.29	93300.0
2011-09-27	BLNG	ETF	50.89	51.05	50.31	50.31	800.0
2011-09-27	BLV	ETF	90.14	90.44	89.83	90.31	86600.0
2011-09-27	BMVP	ETF	13.027	13.11	12.843	12.846	7134.0
2011-09-27	BND	ETF	83.62	83.67	83.46	83.62	1943800.0
2011-09-27	BNO	ETF	35.68	36.215	35.62	36.005	341400.0

> showing 50 of 873 rows — these rows as CSV

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