PREVIEW / etf_daily / 2012-06-15

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-15.parquet
  size:    38 KB
  rows:    930

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-06-15	SPY	ETF	133.38	134.26	133.1	134.14	169444500.0
2012-06-15	QQQ	ETF	62.37	63.08	62.36	62.99	41536033.0
2012-06-15	IWM	ETF	76.35	77.32	76.1	77.22	57935000.0
2012-06-15	DIA	ETF	126.77	127.48	126.64	127.34	6268400.0
2012-06-15	GLD	ETF	157.75	158.46	157.42	157.84	13099300.0
2012-06-15	TLT	ETF	126.58	126.85	126.14	126.4	6421400.0
2012-06-15	AADR	ETF	28.13	28.13	28.11	28.11	1400.0
2012-06-15	AAXJ	ETF	52.01	52.48	51.79	52.43	920200.0
2012-06-15	ACTV	ETF	15.2	15.8	15.2	15.8	403689.0
2012-06-15	ACWI	ETF	43.25	43.61	43.21	43.56	636100.0
2012-06-15	ACWV	ETF	54.14	54.66	52.92	54.4	13900.0
2012-06-15	ACWX	ETF	36.55	36.73	36.45	36.7	245332.0
2012-06-15	ADRE	ETF	36.66	36.91	36.6318	36.89	22881.0
2012-06-15	AFK	ETF	27.26	27.4491	27.26	27.378	15447.0
2012-06-15	AGEM	ETF	20.55	20.78	20.47	20.742	3935.0
2012-06-15	AGG	ETF	111.35	111.39	111.23	111.38	1030800.0
2012-06-15	AGQ	ETF	166.92	168.44	165.92	166.8	216450.0
2012-06-15	AGZ	ETF	113.45	113.62	113.43	113.54	12491.0
2012-06-15	AIA	ETF	41.07	41.31	41.05	41.31	10038.0
2012-06-15	AIQ	ETF	4.9005	5.0	4.386	4.5635	24112.0
2012-06-15	AIVI	ETF	37.48	37.87	37.34	37.81	73300.0
2012-06-15	AMJ	ETF	36.28	36.48	36.16	36.21	1465154.0
2012-06-15	AMLP	ETF	77.9	78.35	77.9	78.05	332880.0
2012-06-15	ANGL	ETF	25.07	25.07	25.01	25.07	1200.0
2012-06-15	AOA	ETF	34.47	34.64	34.47	34.64	2800.0
2012-06-15	AOK	ETF	29.75	29.7901	29.7229	29.7901	10969.0
2012-06-15	AOM	ETF	30.52	30.64	30.52	30.6318	22696.0
2012-06-15	AOR	ETF	32.19	32.3083	32.162	32.3	14396.0
2012-06-15	ARB	ETF	33.96	34.7	33.92	34.28	213050.0
2012-06-15	ASEA	ETF	15.03	15.26	15.03	15.23	6800.0
2012-06-15	AWAY	ETF	21.07	21.35	20.72	21.19	484461.0
2012-06-15	BAB	ETF	29.87	29.92	29.7816	29.87	159616.0
2012-06-15	BAL	ETF	46.56	46.96	46.5	46.8511	12535.0
2012-06-15	BALT	ETF	3.23	3.37	3.17	3.3	94929.0
2012-06-15	BBH	ETF	45.41	45.9	45.41	45.9	7400.0
2012-06-15	BCM	ETF	40.59	40.59	40.47	40.5402	3351.0
2012-06-15	BIB	ETF	11.8525	12.1963	11.8525	12.1963	42128.0
2012-06-15	BICK	ETF	22.42	22.55	22.42	22.516	4108.0
2012-06-15	BIL	ETF	91.64	91.66	91.64	91.64	107400.0
2012-06-15	BIS	ETF	3499.2	3499.2	3422.4	3422.4	29.3
2012-06-15	BIV	ETF	88.79	88.85	88.6	88.85	144100.0
2012-06-15	BJK	ETF	31.52	31.69	31.51	31.63	14100.0
2012-06-15	BKF	ETF	35.92	36.19	35.72	36.16	66875.0
2012-06-15	BKLN	ETF	24.15	24.24	24.15	24.19	180100.0
2012-06-15	BLNG	ETF	48.2	48.2	47.99	47.99	8500.0
2012-06-15	BLV	ETF	95.22	95.22	94.9	95.07	17700.0
2012-06-15	BMVP	ETF	14.6467	14.7123	14.6467	14.7123	988.0
2012-06-15	BND	ETF	84.34	84.43	84.32	84.42	793200.0
2012-06-15	BNO	ETF	34.565	34.725	34.475	34.555	20600.0
2012-06-15	BOIL	ETF	742200.0	764200.0	737400.0	748000.0	13.0

> showing 50 of 930 rows — these rows as CSV

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