PREVIEW / etf_daily / 2012-11-07

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-07.parquet
  size:    39 KB
  rows:    955

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-11-07	SPY	ETF	141.66	141.68	139.06	139.72	264304500.0
2012-11-07	QQQ	ETF	65.04	65.1	63.9	64.17	70737600.0
2012-11-07	IWM	ETF	81.37	81.37	79.91	80.34	65095500.0
2012-11-07	DIA	ETF	131.05	131.05	128.65	129.25	18648300.0
2012-11-07	GLD	ETF	166.87	167.13	165.04	166.49	13195200.0
2012-11-07	TLT	ETF	123.95	124.53	123.76	124.0	10071000.0
2012-11-07	AADR	ETF	30.0	30.0	29.74	29.74	4000.0
2012-11-07	AAXJ	ETF	57.12	57.28	56.47	56.75	298800.0
2012-11-07	ACTV	ETF	5.83	5.83	5.5	5.75	1960035.0
2012-11-07	ACWI	ETF	46.79	46.79	45.96	46.25	471000.0
2012-11-07	ACWV	ETF	55.91	55.96	55.42	55.86	23500.0
2012-11-07	ACWX	ETF	39.68	39.7	39.27	39.45	271179.0
2012-11-07	ADRE	ETF	39.23	39.28	38.8	39.02	142587.0
2012-11-07	AFK	ETF	32.08	32.12	31.42	31.73	37112.0
2012-11-07	AGEM	ETF	22.47	22.62	22.27	22.53	1587.0
2012-11-07	AGG	ETF	112.16	112.21	112.0	112.0	1563100.0
2012-11-07	AGQ	ETF	197.76	198.76	189.0	196.64	473450.0
2012-11-07	AGZ	ETF	113.7591	113.86	113.67	113.78	34678.0
2012-11-07	AIA	ETF	45.09	45.17	44.6	44.9355	19456.0
2012-11-07	AIQ	ETF	7.5	7.5	7.25	7.25	255480.0
2012-11-07	AIVI	ETF	39.73	39.73	39.3	39.64	49500.0
2012-11-07	AMJ	ETF	40.87	40.91	40.11	40.45	1023158.0
2012-11-07	AMLP	ETF	81.95	82.1	81.05	81.55	638300.0
2012-11-07	ANGL	ETF	26.78	26.82	26.77	26.79	3500.0
2012-11-07	AOA	ETF	36.52	36.52	35.98	36.14	28600.0
2012-11-07	AOK	ETF	30.47	30.47	30.31	30.4	11550.0
2012-11-07	AOM	ETF	31.55	31.55	31.3057	31.37	25837.0
2012-11-07	AOR	ETF	33.58	33.58	33.2799	33.33	21474.0
2012-11-07	ARB	ETF	37.32	37.65	35.98	36.05	143068.0
2012-11-07	ARGT	ETF	16.28	16.3	16.08	16.3	6000.0
2012-11-07	ASEA	ETF	16.6	16.66	16.47	16.51	6400.0
2012-11-07	AWAY	ETF	22.17	22.5962	22.0	22.19	959734.0
2012-11-07	BAB	ETF	30.3	30.33	30.19	30.28	562203.0
2012-11-07	BAL	ETF	46.2	46.2	45.9094	46.03	15945.0
2012-11-07	BALT	ETF	3.38	3.41	3.29	3.35	72300.0
2012-11-07	BBH	ETF	51.32	51.63	50.5	50.84	60000.0
2012-11-07	BCM	ETF	44.06	44.06	44.036	44.036	1198.0
2012-11-07	BIB	ETF	13.2925	13.4225	12.715	12.9875	150928.0
2012-11-07	BICK	ETF	24.01	24.01	23.7835	23.89	18760.0
2012-11-07	BIL	ETF	91.62	91.64	91.62	91.64	1984650.0
2012-11-07	BIS	ETF	2913.6	3038.08	2913.6	2995.6	36.9
2012-11-07	BIV	ETF	90.35	90.43	90.23	90.28	350600.0
2012-11-07	BJK	ETF	34.73	34.73	34.35	34.59	2300.0
2012-11-07	BKF	ETF	38.87	38.97	38.43	38.58	78637.0
2012-11-07	BKLN	ETF	24.88	24.89	24.85	24.86	744400.0
2012-11-07	BLV	ETF	97.04	97.1	96.82	96.86	65800.0
2012-11-07	BMVP	ETF	15.973	15.973	15.691	15.763	9205.0
2012-11-07	BND	ETF	85.0	85.02	84.83	84.85	1036900.0
2012-11-07	BNO	ETF	39.74	39.74	38.745	38.765	146000.0
2012-11-07	BOIL	ETF	991800.0	1001600.0	980000.0	991600.0	5.4

> showing 50 of 955 rows — these rows as CSV

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