PREVIEW / etf_daily / 2012-01-27

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-27.parquet
  size:    37 KB
  rows:    892

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-01-27	SPY	ETF	131.24	132.05	131.15	131.82	135259100.0
2012-01-27	QQQ	ETF	60.09	60.51	60.06	60.4	45540388.0
2012-01-27	IWM	ETF	78.8	79.78	78.77	79.72	52203500.0
2012-01-27	DIA	ETF	126.47	126.76	126.01	126.45	6136400.0
2012-01-27	GLD	ETF	167.44	169.0	167.41	168.97	13030100.0
2012-01-27	TLT	ETF	117.83	118.33	117.01	118.08	5165300.0
2012-01-27	AAXJ	ETF	55.46	55.77	55.18	55.65	1091600.0
2012-01-27	ACTV	ETF	14.52	14.59	14.5	14.53	55751.0
2012-01-27	ACWI	ETF	44.5	44.82	44.5	44.75	507100.0
2012-01-27	ACWV	ETF	52.4	52.4	52.4	52.4	200.0
2012-01-27	ACWX	ETF	39.09	39.35	39.065	39.31	328937.0
2012-01-27	ADRE	ETF	42.6	42.874	42.56	42.77	19411.0
2012-01-27	AFK	ETF	28.0	28.27	27.98	28.076	13200.0
2012-01-27	AGEM	ETF	23.25	23.25	23.15	23.18	3767.0
2012-01-27	AGG	ETF	110.53	110.62	110.37	110.54	778100.0
2012-01-27	AGQ	ETF	239.32	247.0	239.04	246.44	650150.0
2012-01-27	AGZ	ETF	113.27	113.27	113.047	113.2	10732.0
2012-01-27	AIA	ETF	43.27	43.68	43.27	43.58	19698.0
2012-01-27	AIQ	ETF	5.7	5.75	5.6	5.7	4174.0
2012-01-27	AIS	ETF	2.41	2.46	2.38	2.46	707858.0
2012-01-27	AIVI	ETF	40.59	40.89	40.48	40.77	220100.0
2012-01-27	AMJ	ETF	40.0	40.05	39.55	39.6	610523.0
2012-01-27	AMLP	ETF	84.45	84.8	83.85	84.0	351620.0
2012-01-27	AOA	ETF	34.67	34.88	34.67	34.88	14200.0
2012-01-27	AOK	ETF	29.77	29.8	29.734	29.79	16392.0
2012-01-27	AOM	ETF	30.57	30.62	30.49	30.61	168860.0
2012-01-27	AOR	ETF	32.16	32.269	32.14	32.26	102999.0
2012-01-27	ARB	ETF	36.34	37.06	36.19	36.98	194637.0
2012-01-27	ARGT	ETF	24.06	24.06	23.9	23.9	150.0
2012-01-27	ASEA	ETF	15.67	15.79	15.65	15.75	56500.0
2012-01-27	AWAY	ETF	27.01	27.78	26.42	27.24	284793.0
2012-01-27	BAB	ETF	28.89	28.91	28.72	28.85	185579.0
2012-01-27	BAL	ETF	59.33	59.66	59.14	59.66	8155.0
2012-01-27	BALT	ETF	4.09	4.15	4.05	4.12	95738.0
2012-01-27	BBH	ETF	41.6433	43.1933	41.6433	42.6167	18300.0
2012-01-27	BCM	ETF	45.46	45.517	45.438	45.517	800.0
2012-01-27	BIB	ETF	10.4925	10.69	10.4925	10.625	44800.0
2012-01-27	BICK	ETF	26.71	26.94	26.71	26.89	25764.0
2012-01-27	BIL	ETF	91.64	91.66	91.64	91.64	153850.0
2012-01-27	BIS	ETF	4387.2	4387.2	4216.0	4224.0	58.0
2012-01-27	BITS	ETF	22.6	22.76	22.28	22.76	981.0
2012-01-27	BIV	ETF	87.71	87.88	87.61	87.8	147300.0
2012-01-27	BJK	ETF	33.04	33.32	33.04	33.28	11600.0
2012-01-27	BKF	ETF	41.34	41.638	41.34	41.58	70489.0
2012-01-27	BKLN	ETF	24.34	24.4	24.28	24.39	69300.0
2012-01-27	BLV	ETF	91.28	91.61	90.9	91.59	22700.0
2012-01-27	BMVP	ETF	14.297	14.42	14.277	14.394	4631.0
2012-01-27	BND	ETF	83.82	83.91	83.72	83.9	1708100.0
2012-01-27	BNO	ETF	38.815	38.95	38.68	38.82	78800.0
2012-01-27	BOIL	ETF	1481000.0	1670000.0	1473000.0	1660000.0	4.0

> showing 50 of 892 rows — these rows as CSV

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