PREVIEW / etf_daily / 2012-08-29

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-29.parquet
  size:    38 KB
  rows:    928

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-29	SPY	ETF	141.52	141.89	141.12	141.51	65421300.0
2012-08-29	QQQ	ETF	68.41	68.57	68.11	68.4	26674509.0
2012-08-29	IWM	ETF	81.52	81.96	81.14	81.6	30858800.0
2012-08-29	DIA	ETF	130.87	131.28	130.63	130.92	2400400.0
2012-08-29	GLD	ETF	161.6	161.68	160.18	160.59	9287700.0
2012-08-29	TLT	ETF	125.61	125.63	124.95	125.29	3762700.0
2012-08-29	AAXJ	ETF	53.35	53.44	53.12	53.26	178200.0
2012-08-29	ACTV	ETF	11.0	11.14	10.99	11.07	214580.0
2012-08-29	ACWI	ETF	45.59	45.73	45.56	45.64	1436900.0
2012-08-29	ACWV	ETF	55.98	56.04	55.98	56.04	1200.0
2012-08-29	ACWX	ETF	38.38	38.38	38.16	38.25	55963.0
2012-08-29	ADRE	ETF	38.05	38.05	37.62	37.76	34435.0
2012-08-29	AFK	ETF	29.44	29.63	29.44	29.6	6511.0
2012-08-29	AGEM	ETF	21.3	21.3854	21.3	21.3	2762.0
2012-08-29	AGG	ETF	112.01	112.04	111.9	111.95	717100.0
2012-08-29	AGQ	ETF	189.44	189.72	185.4	187.08	250550.0
2012-08-29	AGZ	ETF	113.72	113.74	113.67	113.74	12329.0
2012-08-29	AIA	ETF	42.25	42.321	42.12	42.19	12710.0
2012-08-29	AIQ	ETF	6.5	6.6	6.3	6.3	2381.0
2012-08-29	AIVI	ETF	39.7	39.72	39.55	39.6	29500.0
2012-08-29	AMJ	ETF	39.45	39.5	39.2	39.46	514656.0
2012-08-29	AMLP	ETF	81.5	81.55	81.3	81.4	261280.0
2012-08-29	ANGL	ETF	26.89	26.89	26.42	26.45	2000.0
2012-08-29	AOA	ETF	36.07	36.18	36.07	36.1	4200.0
2012-08-29	AOK	ETF	30.2799	30.28	30.22	30.2699	17724.0
2012-08-29	AOM	ETF	31.32	31.34	31.2333	31.2717	10687.0
2012-08-29	AOR	ETF	33.32	33.34	33.25	33.3283	12482.0
2012-08-29	ARB	ETF	36.28	36.28	35.42	35.47	95129.0
2012-08-29	ARGT	ETF	16.8	16.96	16.8	16.96	200.0
2012-08-29	ASEA	ETF	16.25	16.27	16.18	16.22	5400.0
2012-08-29	AWAY	ETF	23.87	23.87	23.34	23.51	181035.0
2012-08-29	BAB	ETF	30.1	30.29	30.1	30.21	204235.0
2012-08-29	BAL	ETF	50.1599	50.7	49.95	50.57	22841.0
2012-08-29	BALT	ETF	3.07	3.14	3.06	3.09	36422.0
2012-08-29	BBH	ETF	50.75	51.1	50.7	50.85	39000.0
2012-08-29	BCM	ETF	45.61	45.61	45.61	45.61	438.0
2012-08-29	BIB	ETF	14.375	14.4248	14.3075	14.3075	6952.0
2012-08-29	BICK	ETF	22.52	22.52	22.35	22.43	5552.0
2012-08-29	BIL	ETF	91.62	91.64	91.62	91.62	72350.0
2012-08-29	BIS	ETF	2846.4	2847.76	2812.8	2831.76	20.4
2012-08-29	BIV	ETF	89.56	89.59	89.4	89.51	155500.0
2012-08-29	BJK	ETF	32.23	32.26	32.1	32.2	12100.0
2012-08-29	BKF	ETF	36.08	36.09	35.69	35.85	88982.0
2012-08-29	BKLN	ETF	24.77	24.78	24.74	24.76	256600.0
2012-08-29	BLV	ETF	96.82	96.82	96.26	96.47	30200.0
2012-08-29	BMVP	ETF	15.967	16.025	15.95	16.017	4693.0
2012-08-29	BND	ETF	84.85	84.86	84.75	84.81	853600.0
2012-08-29	BNO	ETF	40.57	40.57	40.335	40.555	52600.0
2012-08-29	BOIL	ETF	746400.0	780000.0	744200.0	773800.0	10.2
2012-08-29	BOND	ETF	107.7	107.79	107.45	107.55	261770.0

> showing 50 of 928 rows — these rows as CSV

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