PREVIEW / etf_daily / 2012-05-03

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-03.parquet
  size:    38 KB
  rows:    941

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-05-03	SPY	ETF	140.34	140.45	138.99	139.25	143759700.0
2012-05-03	QQQ	ETF	67.1	67.15	66.175	66.35	51307361.0
2012-05-03	IWM	ETF	81.66	81.76	80.17	80.62	61487800.0
2012-05-03	DIA	ETF	132.41	132.58	131.5	131.81	5043100.0
2012-05-03	GLD	ETF	159.16	159.48	158.37	158.97	13172000.0
2012-05-03	TLT	ETF	116.64	117.37	116.56	117.22	3522900.0
2012-05-03	AADR	ETF	30.17	30.2	30.17	30.2	700.0
2012-05-03	AAXJ	ETF	56.66	56.77	56.25	56.4	112000.0
2012-05-03	ACTV	ETF	16.72	16.85	15.98	16.0	146464.0
2012-05-03	ACWI	ETF	46.66	46.68	46.19	46.28	901300.0
2012-05-03	ACWV	ETF	54.92	54.92	54.55	54.6	102000.0
2012-05-03	ACWX	ETF	40.01	40.04	39.5915	39.7	97448.0
2012-05-03	ADRE	ETF	41.53	41.53	40.84	41.06	21110.0
2012-05-03	AFK	ETF	29.94	30.02	29.94	29.98	5900.0
2012-05-03	AGEM	ETF	22.73	22.73	22.61	22.61	2169.0
2012-05-03	AGG	ETF	110.43	110.56	110.41	110.56	575400.0
2012-05-03	AGQ	ETF	191.0	192.08	184.08	188.16	387350.0
2012-05-03	AGZ	ETF	112.91	112.93	112.8001	112.92	13264.0
2012-05-03	AIA	ETF	45.52	45.629	45.15	45.17	24640.0
2012-05-03	AIQ	ETF	7.3	7.5	6.55	7.35	17502.0
2012-05-03	AIS	ETF	3.19	3.19	3.05	3.06	921866.0
2012-05-03	AIVI	ETF	40.42	40.42	39.99	40.13	26000.0
2012-05-03	AMJ	ETF	40.08	40.3	39.65	39.74	784026.0
2012-05-03	AMLP	ETF	84.2	84.45	83.5	83.75	393960.0
2012-05-03	ANGL	ETF	25.56	25.56	25.45	25.47	74000.0
2012-05-03	AOA	ETF	36.17	36.17	35.94	36.01	4000.0
2012-05-03	AOK	ETF	30.19	30.19	30.0872	30.1	65947.0
2012-05-03	AOM	ETF	31.27	31.275	31.1345	31.16	17596.0
2012-05-03	AOR	ETF	33.31	33.31	33.09	33.14	18976.0
2012-05-03	ARB	ETF	37.43	37.43	36.32	36.94	307622.0
2012-05-03	ARGT	ETF	18.44	18.5	18.2	18.2	1200.0
2012-05-03	ASEA	ETF	16.37	16.38	16.23	16.25	29000.0
2012-05-03	AWAY	ETF	25.63	26.0	25.38	25.57	292802.0
2012-05-03	BAB	ETF	29.35	29.459	29.33	29.44	111092.0
2012-05-03	BAL	ETF	55.35	55.65	55.35	55.47	42993.0
2012-05-03	BALT	ETF	4.26	4.32	4.2	4.22	100907.0
2012-05-03	BBH	ETF	46.3	46.3	45.7	45.77	84500.0
2012-05-03	BCM	ETF	44.13	44.13	44.032	44.032	1103.0
2012-05-03	BIB	ETF	12.4262	12.4262	12.0613	12.0613	13808.0
2012-05-03	BICK	ETF	25.1	25.258	25.05	25.09	2834.0
2012-05-03	BIL	ETF	91.64	91.66	91.64	91.64	84800.0
2012-05-03	BIS	ETF	3512.0	3512.0	3481.6	3507.2	22.5
2012-05-03	BIV	ETF	87.76	87.93	87.72	87.86	205900.0
2012-05-03	BJK	ETF	36.65	36.74	36.27	36.42	14900.0
2012-05-03	BKF	ETF	40.0	40.0	39.438	39.67	81722.0
2012-05-03	BKLN	ETF	24.7	24.73	24.61	24.69	142000.0
2012-05-03	BLV	ETF	91.1	91.39	91.04	91.29	21000.0
2012-05-03	BMVP	ETF	15.613	15.613	15.566	15.566	815.0
2012-05-03	BND	ETF	83.65	83.85	83.65	83.85	1258600.0
2012-05-03	BNO	ETF	41.48	41.48	40.86	40.935	80000.0

> showing 50 of 941 rows — these rows as CSV

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