PREVIEW / etf_daily / 2012-11-20

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-20.parquet
  size:    39 KB
  rows:    947

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-20	SPY	ETF	138.91	139.42	138.08	139.19	119807400.0
2012-11-20	QQQ	ETF	63.77	63.89	63.19	63.8	52012655.0
2012-11-20	IWM	ETF	78.98	79.35	78.64	79.26	36928500.0
2012-11-20	DIA	ETF	127.31	127.87	126.75	127.71	7021800.0
2012-11-20	GLD	ETF	167.75	168.02	166.84	167.39	5496100.0
2012-11-20	TLT	ETF	125.48	125.67	124.38	124.4	4659300.0
2012-11-20	AADR	ETF	29.47	29.47	29.46	29.46	700.0
2012-11-20	AAXJ	ETF	56.19	56.34	55.93	56.34	94000.0
2012-11-20	ACTV	ETF	5.0	5.0	4.83	4.91	676601.0
2012-11-20	ACWI	ETF	45.92	46.1	45.74	46.07	412000.0
2012-11-20	ACWV	ETF	55.6	55.61	55.31	55.58	6700.0
2012-11-20	ACWX	ETF	39.26	39.4	39.11	39.4	152244.0
2012-11-20	ADRE	ETF	37.77	37.979	37.73	37.89	23216.0
2012-11-20	AFK	ETF	30.77	31.02	30.75	30.99	10164.0
2012-11-20	AGEM	ETF	21.94	22.0108	21.798	21.978	16583.0
2012-11-20	AGG	ETF	112.19	112.24	112.06	112.08	666800.0
2012-11-20	AGQ	ETF	211.88	213.12	208.92	212.72	247250.0
2012-11-20	AGZ	ETF	113.8964	113.964	113.64	113.64	23725.0
2012-11-20	AIA	ETF	44.36	44.59	44.29	44.59	13783.0
2012-11-20	AIQ	ETF	6.2	6.4	6.15	6.4	3108.0
2012-11-20	AIVI	ETF	38.93	39.14	38.86	39.06	17000.0
2012-11-20	AMJ	ETF	39.41	39.6198	39.31	39.55	415625.0
2012-11-20	AMLP	ETF	80.5	80.75	80.35	80.75	424720.0
2012-11-20	ANGL	ETF	26.61	26.71	26.56	26.69	10900.0
2012-11-20	AOA	ETF	35.96	36.08	35.88	36.06	9000.0
2012-11-20	AOK	ETF	30.27	30.3285	30.27	30.3085	7047.0
2012-11-20	AOM	ETF	31.2899	31.34	31.24	31.29	37295.0
2012-11-20	AOR	ETF	33.23	33.28	33.114	33.2299	158614.0
2012-11-20	ARB	ETF	36.05	36.05	34.98	35.4	87160.0
2012-11-20	ARGT	ETF	15.72	15.88	15.72	15.88	1200.0
2012-11-20	ASEA	ETF	16.53	16.55	16.42	16.55	22900.0
2012-11-20	AWAY	ETF	21.03	21.1299	20.5301	20.63	419342.0
2012-11-20	BAB	ETF	30.49	30.49	30.25	30.32	319424.0
2012-11-20	BAL	ETF	47.18	47.45	47.1328	47.45	3125.0
2012-11-20	BALT	ETF	2.9	2.9	2.79	2.81	168794.0
2012-11-20	BBH	ETF	52.9	53.82	52.88	53.82	22700.0
2012-11-20	BCM	ETF	44.49	44.49	44.27	44.27	3504.0
2012-11-20	BIB	ETF	13.7175	14.235	13.6877	14.235	82020.0
2012-11-20	BICK	ETF	23.19	23.309	23.17	23.2699	6990.0
2012-11-20	BIL	ETF	91.62	91.64	91.62	91.62	64900.0
2012-11-20	BIS	ETF	2749.2	2767.2	2736.0	2736.0	150.5
2012-11-20	BIV	ETF	90.3	90.35	90.16	90.2	287300.0
2012-11-20	BJK	ETF	34.33	34.41	34.24	34.41	1900.0
2012-11-20	BKF	ETF	37.36	37.51	37.1402	37.51	82943.0
2012-11-20	BKLN	ETF	24.61	24.61	24.59	24.59	381900.0
2012-11-20	BLV	ETF	97.11	97.24	96.66	96.67	42700.0
2012-11-20	BMVP	ETF	15.6167	15.6333	15.5533	15.6134	7016.0
2012-11-20	BND	ETF	84.92	84.94	84.79	84.82	770400.0
2012-11-20	BNO	ETF	40.66	40.845	39.92	40.275	72800.0
2012-11-20	BOIL	ETF	1075200.0	1120000.0	1071000.0	1114800.0	6.0

> showing 50 of 947 rows — these rows as CSV

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