PREVIEW / etf_daily / 2012-04-27

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-27.parquet
  size:    39 KB
  rows:    938

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-04-27	SPY	ETF	140.58	140.79	139.8	140.39	130725000.0
2012-04-27	QQQ	ETF	67.12	67.45	66.77	67.24	46012481.0
2012-04-27	IWM	ETF	81.98	82.53	81.03	82.38	46796400.0
2012-04-27	DIA	ETF	132.09	132.41	131.66	132.0	3969500.0
2012-04-27	GLD	ETF	161.78	161.97	161.15	161.38	8906600.0
2012-04-27	TLT	ETF	117.02	117.36	116.79	117.29	3112900.0
2012-04-27	AAXJ	ETF	56.19	56.34	55.94	56.21	67000.0
2012-04-27	ACTV	ETF	16.95	17.07	16.86	16.96	446482.0
2012-04-27	ACWI	ETF	46.9	46.95	46.62	46.83	650600.0
2012-04-27	ACWV	ETF	54.61	54.73	54.38	54.73	70000.0
2012-04-27	ACWX	ETF	40.35	40.39	40.09	40.29	84977.0
2012-04-27	ADRE	ETF	41.16	41.412	41.12	41.4	24108.0
2012-04-27	AFK	ETF	30.04	30.05	29.7401	29.96	6595.0
2012-04-27	AGEM	ETF	22.71	22.912	22.71	22.9068	1142.0
2012-04-27	AGG	ETF	110.61	110.67	110.55	110.64	656600.0
2012-04-27	AGQ	ETF	204.04	204.68	201.24	202.96	262425.0
2012-04-27	AGZ	ETF	113.02	113.02	112.8001	112.97	9885.0
2012-04-27	AIA	ETF	45.13	45.13	44.9	45.12	4753.0
2012-04-27	AIQ	ETF	6.85	6.9	6.6	6.6	5898.0
2012-04-27	AIS	ETF	3.12	3.22	3.08	3.21	1785533.0
2012-04-27	AIVI	ETF	40.82	40.89	40.61	40.89	23000.0
2012-04-27	AMJ	ETF	39.57	39.8764	39.57	39.82	1011647.0
2012-04-27	AMLP	ETF	83.15	83.7	83.15	83.55	355600.0
2012-04-27	ANGL	ETF	25.53	25.55	25.42	25.46	65000.0
2012-04-27	AOA	ETF	36.36	36.4	36.27	36.39	7900.0
2012-04-27	AOK	ETF	30.1999	30.229	30.18	30.211	9049.0
2012-04-27	AOM	ETF	31.3	31.312	31.221	31.27	65063.0
2012-04-27	AOR	ETF	33.29	33.3779	33.24	33.35	20949.0
2012-04-27	ARB	ETF	38.56	38.75	37.9	38.6	205606.0
2012-04-27	ARGT	ETF	18.7	18.78	18.7	18.78	100.0
2012-04-27	ASEA	ETF	16.18	16.24	16.12	16.22	8000.0
2012-04-27	AWAY	ETF	25.53	26.15	25.53	26.03	375253.0
2012-04-27	BAB	ETF	29.38	29.4868	29.37	29.48	177072.0
2012-04-27	BAL	ETF	57.1	57.28	56.54	56.71	33823.0
2012-04-27	BALT	ETF	4.7	4.77	4.62	4.77	95109.0
2012-04-27	BBH	ETF	45.6	46.13	45.29	45.9	23500.0
2012-04-27	BCM	ETF	44.85	44.929	44.85	44.929	320.0
2012-04-27	BIB	ETF	12.32	12.5025	12.07	12.4275	30096.0
2012-04-27	BICK	ETF	25.41	25.44	25.316	25.401	19037.0
2012-04-27	BIL	ETF	91.64	91.66	91.64	91.64	100150.0
2012-04-27	BIS	ETF	3545.6	3545.6	3459.2	3473.6	16.75
2012-04-27	BIV	ETF	87.83	87.93	87.75	87.93	257500.0
2012-04-27	BJK	ETF	36.89	36.89	36.59	36.73	82800.0
2012-04-27	BKF	ETF	40.11	40.23	39.92	40.12	87390.0
2012-04-27	BKLN	ETF	24.53	24.58	24.48	24.57	122700.0
2012-04-27	BLNG	ETF	50.14	50.14	50.14	50.14	221.0
2012-04-27	BLV	ETF	91.31	91.54	91.17	91.53	20100.0
2012-04-27	BMVP	ETF	15.58	15.71	15.58	15.7	3377.0
2012-04-27	BND	ETF	83.83	83.89	83.77	83.87	890600.0
2012-04-27	BNO	ETF	42.175	42.175	42.065	42.11	3800.0

> showing 50 of 938 rows — these rows as CSV

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