PREVIEW / etf_daily / 2012-03-28

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-28.parquet
  size:    38 KB
  rows:    925

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
2012-03-28	SPY	ETF	141.1	141.32	139.64	140.47	148562100.0
2012-03-28	QQQ	ETF	68.25	68.51	67.54	67.938	44421855.0
2012-03-28	IWM	ETF	83.8	84.02	82.61	83.32	48836000.0
2012-03-28	DIA	ETF	131.73	131.86	130.41	130.98	5293700.0
2012-03-28	GLD	ETF	162.71	162.98	160.66	161.51	11008200.0
2012-03-28	TLT	ETF	112.92	113.94	112.85	113.28	7886000.0
2012-03-28	AADR	ETF	31.18	31.18	31.0	31.0	500.0
2012-03-28	AAXJ	ETF	56.75	56.87	56.07	56.36	338200.0
2012-03-28	ACTV	ETF	17.1	17.16	16.75	17.04	287306.0
2012-03-28	ACWI	ETF	47.39	47.39	46.87	47.12	933000.0
2012-03-28	ACWV	ETF	54.37	54.43	54.14	54.24	2900.0
2012-03-28	ACWX	ETF	41.16	41.16	40.59	40.83	87533.0
2012-03-28	ADRE	ETF	42.64	42.6792	41.9468	42.09	24559.0
2012-03-28	AFK	ETF	29.53	29.53	29.09	29.21	12179.0
2012-03-28	AGEM	ETF	23.36	23.36	23.16	23.16	1450.0
2012-03-28	AGG	ETF	109.73	109.88	109.68	109.72	812700.0
2012-03-28	AGQ	ETF	220.0	220.84	211.12	215.0	491600.0
2012-03-28	AGZ	ETF	112.3908	112.69	112.3908	112.56	11832.0
2012-03-28	AIA	ETF	45.0	45.0	44.53	44.65	7045.0
2012-03-28	AIQ	ETF	7.3	7.45	7.25	7.3	4190.0
2012-03-28	AIS	ETF	3.29	3.32	3.2	3.24	959553.0
2012-03-28	AIVI	ETF	42.15	42.15	41.47	41.72	53400.0
2012-03-28	AMJ	ETF	39.33	39.59	38.83	39.19	1479193.0
2012-03-28	AMLP	ETF	83.15	83.55	82.5	83.0	323320.0
2012-03-28	AOA	ETF	36.52	36.58	36.23	36.32	6900.0
2012-03-28	AOK	ETF	30.1599	30.17	30.1012	30.15	7639.0
2012-03-28	AOM	ETF	31.29	31.29	31.12	31.21	73664.0
2012-03-28	AOR	ETF	33.41	33.42	33.164	33.2595	10020.0
2012-03-28	ARB	ETF	36.52	36.88	36.19	36.7	248334.0
2012-03-28	ARGT	ETF	21.4	21.4	21.16	21.16	9900.0
2012-03-28	ASEA	ETF	15.93	16.07	15.93	16.05	11900.0
2012-03-28	AWAY	ETF	26.09	26.15	25.29	25.44	183709.0
2012-03-28	BAB	ETF	29.0	29.18	29.0	29.01	173831.0
2012-03-28	BAL	ETF	55.98	57.44	55.98	57.22	97770.0
2012-03-28	BALT	ETF	4.13	4.19	4.04	4.07	83221.0
2012-03-28	BBH	ETF	44.1	44.53	43.62	43.95	6900.0
2012-03-28	BCM	ETF	45.3	45.3	45.3	45.3	300.0
2012-03-28	BIB	ETF	12.1263	12.1263	11.6925	11.6962	18424.0
2012-03-28	BICK	ETF	26.48	26.488	26.0901	26.23	9411.0
2012-03-28	BIL	ETF	91.64	91.66	91.64	91.66	55800.0
2012-03-28	BIS	ETF	3657.6	3696.96	3657.6	3696.96	3.44
2012-03-28	BIV	ETF	86.9	87.07	86.82	86.82	200100.0
2012-03-28	BJK	ETF	36.24	36.24	35.56	35.81	17200.0
2012-03-28	BKF	ETF	41.36	41.36	40.609	40.8	72073.0
2012-03-28	BKLN	ETF	24.57	24.57	24.51	24.55	183500.0
2012-03-28	BLNG	ETF	50.9699	51.0099	50.53	50.684	8424.0
2012-03-28	BLV	ETF	89.17	89.69	89.1	89.38	40400.0
2012-03-28	BMVP	ETF	15.613	15.613	15.46	15.508	13879.0
2012-03-28	BND	ETF	83.29	83.37	83.21	83.27	639000.0
2012-03-28	BNO	ETF	43.545	43.655	43.42	43.655	124200.0

> showing 50 of 925 rows — these rows as CSV

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