PREVIEW / etf_daily / 2012-08-27

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-27.parquet
  size:    38 KB
  rows:    934

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-08-27	SPY	ETF	141.89	142.08	141.34	141.54	68785900.0
2012-08-27	QQQ	ETF	68.6	68.67	68.25	68.4	20671323.0
2012-08-27	IWM	ETF	81.23	81.41	80.58	80.98	23628400.0
2012-08-27	DIA	ETF	131.42	131.57	130.95	131.06	1806500.0
2012-08-27	GLD	ETF	161.77	162.29	161.34	161.36	5380200.0
2012-08-27	TLT	ETF	125.34	125.8	125.27	125.54	3906100.0
2012-08-27	AADR	ETF	29.2	29.2	29.2	29.2	100.0
2012-08-27	AAXJ	ETF	53.73	53.73	53.34	53.46	132500.0
2012-08-27	ACTV	ETF	11.08	11.18	11.0	11.04	357835.0
2012-08-27	ACWI	ETF	45.81	45.92	45.64	45.69	231400.0
2012-08-27	ACWV	ETF	56.01	56.13	56.01	56.03	4500.0
2012-08-27	ACWX	ETF	38.51	38.6	38.35	38.38	906007.0
2012-08-27	ADRE	ETF	38.21	38.3099	38.06	38.0802	40584.0
2012-08-27	AFK	ETF	29.45	29.518	29.33	29.34	15653.0
2012-08-27	AGEM	ETF	21.61	21.6792	21.55	21.56	4006.0
2012-08-27	AGG	ETF	111.9	112.0	111.89	111.97	493100.0
2012-08-27	AGQ	ETF	189.32	193.44	187.12	187.12	446025.0
2012-08-27	AGZ	ETF	113.52	113.7	113.52	113.58	16208.0
2012-08-27	AIA	ETF	42.09	42.1498	41.93	42.0504	15794.0
2012-08-27	AIQ	ETF	6.95	6.976	6.45	6.6	17906.0
2012-08-27	AIVI	ETF	39.89	39.96	39.74	39.78	18700.0
2012-08-27	AMJ	ETF	39.2	39.44	39.09	39.2	329775.0
2012-08-27	AMLP	ETF	81.0	81.5	80.9	81.05	491200.0
2012-08-27	ANGL	ETF	26.41	26.55	26.41	26.55	400.0
2012-08-27	AOA	ETF	36.21	36.21	36.06	36.1	16400.0
2012-08-27	AOK	ETF	30.25	30.29	30.23	30.23	9195.0
2012-08-27	AOM	ETF	31.34	31.3499	31.2704	31.32	15126.0
2012-08-27	AOR	ETF	33.27	33.37	33.25	33.25	10965.0
2012-08-27	ARB	ETF	36.0	36.0	35.2	35.6	124992.0
2012-08-27	ARGT	ETF	17.0	17.0	17.0	17.0	50.0
2012-08-27	ASEA	ETF	16.32	16.38	16.31	16.31	7300.0
2012-08-27	AWAY	ETF	24.0	24.1	23.66	23.9	238449.0
2012-08-27	BAB	ETF	30.2	30.25	30.14	30.24	218291.0
2012-08-27	BAL	ETF	49.93	50.295	49.93	50.17	3020.0
2012-08-27	BALT	ETF	3.06	3.1	3.03	3.04	28894.0
2012-08-27	BBH	ETF	50.8	51.0	50.62	50.72	8500.0
2012-08-27	BIB	ETF	14.275	14.3837	14.1562	14.3525	21656.0
2012-08-27	BICK	ETF	22.77	22.879	22.672	22.77	5731.0
2012-08-27	BIL	ETF	91.62	91.64	91.62	91.62	101300.0
2012-08-27	BIS	ETF	2844.8	2844.8	2812.8	2812.8	26.25
2012-08-27	BIV	ETF	89.52	89.55	89.42	89.43	492500.0
2012-08-27	BJK	ETF	32.02	32.12	31.93	31.95	19200.0
2012-08-27	BKF	ETF	36.39	36.39	36.15	36.2	71861.0
2012-08-27	BKLN	ETF	24.74	24.75	24.7	24.73	200900.0
2012-08-27	BLV	ETF	96.6	96.68	96.45	96.52	114100.0
2012-08-27	BMVP	ETF	15.99	16.0367	15.9633	15.9679	1733.0
2012-08-27	BND	ETF	84.8	84.86	84.78	84.85	715600.0
2012-08-27	BNO	ETF	40.52	40.61	40.175	40.425	114600.0
2012-08-27	BOIL	ETF	811200.0	816200.0	766600.0	771800.0	16.0
2012-08-27	BOND	ETF	107.48	107.57	107.4001	107.56	226851.0

> showing 50 of 934 rows — these rows as CSV

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