PREVIEW / etf_daily / 2012-02-15

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-15.parquet
  size:    38 KB
  rows:    908

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-02-15	SPY	ETF	135.63	135.83	134.29	134.56	195195100.0
2012-02-15	QQQ	ETF	63.52	63.86	62.67	62.77	105708895.0
2012-02-15	IWM	ETF	82.42	82.43	81.0	81.27	59836600.0
2012-02-15	DIA	ETF	129.0	129.04	127.57	127.86	9589200.0
2012-02-15	GLD	ETF	168.63	168.75	167.19	168.11	11638500.0
2012-02-15	TLT	ETF	117.66	118.27	117.49	117.55	6846100.0
2012-02-15	AADR	ETF	30.11	30.17	30.11	30.17	900.0
2012-02-15	AAXJ	ETF	57.52	57.65	57.13	57.31	379300.0
2012-02-15	ACTV	ETF	15.59	15.76	15.54	15.69	124319.0
2012-02-15	ACWI	ETF	46.0	46.02	45.55	45.61	1029700.0
2012-02-15	ACWX	ETF	40.39	40.3985	40.03	40.14	173953.0
2012-02-15	ADRE	ETF	43.54	43.57	43.02	43.09	74835.0
2012-02-15	AFK	ETF	29.24	29.3362	28.82	28.91	20175.0
2012-02-15	AGEM	ETF	23.77	23.8575	23.511	23.82	42003.0
2012-02-15	AGG	ETF	110.65	110.68	110.49	110.5	875500.0
2012-02-15	AGQ	ETF	244.36	244.64	233.76	238.0	522025.0
2012-02-15	AGZ	ETF	112.88	113.1075	112.736	113.06	12438.0
2012-02-15	AIA	ETF	44.66	44.702	44.4632	44.47	18151.0
2012-02-15	AIQ	ETF	6.9	7.25	6.75	6.95	20565.0
2012-02-15	AIS	ETF	2.58	2.61	2.46	2.51	1201388.0
2012-02-15	AIVI	ETF	41.43	41.43	40.98	41.07	89700.0
2012-02-15	AMJ	ETF	40.69	40.83	40.5306	40.83	2353676.0
2012-02-15	AMLP	ETF	84.3	84.65	84.15	84.65	332220.0
2012-02-15	AOA	ETF	35.73	35.73	35.42	35.49	11700.0
2012-02-15	AOK	ETF	30.05	30.05	29.93	29.933	133945.0
2012-02-15	AOM	ETF	31.01	31.01	30.8611	30.89	12697.0
2012-02-15	AOR	ETF	32.83	32.8388	32.65	32.65	18818.0
2012-02-15	ARB	ETF	36.37	36.74	34.26	34.54	385484.0
2012-02-15	ARGT	ETF	22.98	23.12	22.96	23.08	550.0
2012-02-15	ASEA	ETF	15.99	15.99	15.71	15.81	4000.0
2012-02-15	AWAY	ETF	26.76	26.76	26.06	26.34	174714.0
2012-02-15	BAB	ETF	29.26	29.38	29.25	29.31	161661.0
2012-02-15	BAL	ETF	56.74	57.54	56.6	56.89	15403.0
2012-02-15	BALT	ETF	4.7	4.74	4.36	4.4	348291.0
2012-02-15	BBH	ETF	43.74	44.04	43.45	43.65	20900.0
2012-02-15	BIB	ETF	11.7225	11.7225	11.4388	11.4415	55120.0
2012-02-15	BICK	ETF	28.02	28.09	27.8901	27.93	12104.0
2012-02-15	BIL	ETF	91.66	91.66	91.64	91.64	103650.0
2012-02-15	BIS	ETF	3856.0	3888.0	3817.6	3863.84	12.6
2012-02-15	BITS	ETF	22.28	22.28	21.8	22.08	315.0
2012-02-15	BIV	ETF	87.87	88.08	87.82	87.95	226400.0
2012-02-15	BJK	ETF	33.85	33.96	33.57	33.67	6500.0
2012-02-15	BKF	ETF	43.13	43.18	42.62	42.78	83910.0
2012-02-15	BKLN	ETF	24.39	24.53	24.39	24.48	216900.0
2012-02-15	BLV	ETF	91.4	91.6	91.25	91.31	20600.0
2012-02-15	BMVP	ETF	15.13	15.16	15.032	15.032	4949.0
2012-02-15	BND	ETF	83.84	83.88	83.69	83.69	1290200.0
2012-02-15	BNO	ETF	41.51	41.575	41.295	41.565	126000.0
2012-02-15	BOIL	ETF	1312000.0	1320000.0	1250000.0	1286000.0	6.8
2012-02-15	BRF	ETF	45.35	45.54	45.09	45.18	298213.0

> showing 50 of 908 rows — these rows as CSV

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