PREVIEW / etf_daily / 2012-03-15

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-15.parquet
  size:    38 KB
  rows:    927

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-15	SPY	ETF	140.12	140.78	139.76	140.72	165118500.0
2012-03-15	QQQ	ETF	66.69	66.82	66.35	66.68	65531134.0
2012-03-15	IWM	ETF	82.25	83.12	82.03	83.07	58740500.0
2012-03-15	DIA	ETF	132.01	132.49	131.67	132.41	5716900.0
2012-03-15	GLD	ETF	159.73	161.98	159.28	161.08	12689300.0
2012-03-15	TLT	ETF	110.9	111.74	110.88	111.21	14154000.0
2012-03-15	AAXJ	ETF	57.53	57.9	57.45	57.82	168600.0
2012-03-15	ACTV	ETF	17.3	17.39	16.63	16.96	290582.0
2012-03-15	ACWI	ETF	47.13	47.42	47.05	47.39	1684300.0
2012-03-15	ACWV	ETF	53.94	53.94	53.88	53.88	900.0
2012-03-15	ACWX	ETF	41.13	41.33	40.99	41.3	95025.0
2012-03-15	ADRE	ETF	43.36	43.36	43.05	43.22	30839.0
2012-03-15	AFK	ETF	29.54	29.78	29.5	29.78	3240.0
2012-03-15	AGEM	ETF	24.09	24.14	23.91	24.01	10369.0
2012-03-15	AGG	ETF	109.26	109.46	109.25	109.27	800500.0
2012-03-15	AGQ	ETF	216.56	226.8	213.88	221.2	490800.0
2012-03-15	AGZ	ETF	112.2179	112.39	112.176	112.29	8002.0
2012-03-15	AIA	ETF	45.36	45.5571	45.3	45.5571	4010.0
2012-03-15	AIQ	ETF	6.9	10.95	6.8	8.1	164071.0
2012-03-15	AIS	ETF	2.8	2.82	2.69	2.76	1219134.0
2012-03-15	AIVI	ETF	41.88	42.07	41.67	42.05	38500.0
2012-03-15	AMJ	ETF	39.88	39.88	39.32	39.66	951230.0
2012-03-15	AMLP	ETF	83.6	83.75	83.05	83.65	334560.0
2012-03-15	AOA	ETF	36.33	36.54	36.3	36.5	8700.0
2012-03-15	AOK	ETF	30.08	30.14	30.066	30.14	58912.0
2012-03-15	AOM	ETF	31.16	31.28	31.16	31.28	15212.0
2012-03-15	AOR	ETF	33.23	33.38	33.22	33.3799	14105.0
2012-03-15	ARB	ETF	35.08	35.98	35.02	35.91	135772.0
2012-03-15	ARGT	ETF	21.8	21.96	21.78	21.94	9300.0
2012-03-15	ASEA	ETF	16.06	16.11	15.99	16.08	7800.0
2012-03-15	AWAY	ETF	26.06	26.32	25.73	26.28	347388.0
2012-03-15	BAB	ETF	28.74	28.81	28.5	28.67	384877.0
2012-03-15	BAL	ETF	53.24	53.46	52.8053	52.866	11160.0
2012-03-15	BALT	ETF	3.85	3.925	3.79	3.92	195542.0
2012-03-15	BBH	ETF	42.66	43.15	42.64	43.15	22400.0
2012-03-15	BCM	ETF	45.82	46.04	45.82	45.988	10256.0
2012-03-15	BIB	ETF	11.335	11.5625	11.335	11.5612	53920.0
2012-03-15	BICK	ETF	27.4	27.47	27.3648	27.45	7329.0
2012-03-15	BIL	ETF	91.66	91.66	91.64	91.64	468050.0
2012-03-15	BITS	ETF	20.96	21.56	17.0	17.2	17502.0
2012-03-15	BIV	ETF	86.53	86.76	86.5	86.6	283800.0
2012-03-15	BJK	ETF	35.14	35.67	35.09	35.57	34200.0
2012-03-15	BKF	ETF	42.99	43.059	42.7752	43.02	46093.0
2012-03-15	BKLN	ETF	24.47	24.52	24.46	24.5	323300.0
2012-03-15	BLV	ETF	88.03	88.46	88.0	88.23	37300.0
2012-03-15	BMVP	ETF	15.425	15.477	15.393	15.473	6689.0
2012-03-15	BND	ETF	82.85	82.97	82.8	82.86	747300.0
2012-03-15	BNO	ETF	43.545	43.58	42.715	43.04	634200.0
2012-03-15	BOIL	ETF	962000.0	1017000.0	955000.0	964000.0	4.0
2012-03-15	BOND	ETF	100.55	100.6	100.4	100.51	189958.0

> showing 50 of 927 rows — these rows as CSV

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