PREVIEW / etf_daily / 2012-07-03

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-03.parquet
  size:    38 KB
  rows:    918

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-07-03	SPY	ETF	136.48	137.51	136.34	137.41	80450000.0
2012-07-03	QQQ	ETF	64.38	64.89	64.29	64.89	15895085.0
2012-07-03	IWM	ETF	80.56	81.6	80.43	81.53	32322500.0
2012-07-03	DIA	ETF	128.37	129.23	128.24	129.15	2717700.0
2012-07-03	GLD	ETF	156.97	157.72	156.77	157.46	5037700.0
2012-07-03	TLT	ETF	125.95	126.0	125.21	125.25	5773100.0
2012-07-03	AAXJ	ETF	53.09	53.65	52.87	53.64	798200.0
2012-07-03	ACTV	ETF	15.48	15.6	15.11	15.34	203829.0
2012-07-03	ACWI	ETF	44.15	44.58	44.13	44.56	428100.0
2012-07-03	ACWV	ETF	54.94	55.13	54.78	54.99	8100.0
2012-07-03	ACWX	ETF	37.39	37.849	37.39	37.81	119511.0
2012-07-03	ADRE	ETF	38.0	38.49	38.0	38.49	52004.0
2012-07-03	AFK	ETF	28.26	28.64	28.26	28.6	37079.0
2012-07-03	AGEM	ETF	21.18	21.5225	21.18	21.45	2464.0
2012-07-03	AGG	ETF	111.21	111.29	111.18	111.21	1002900.0
2012-07-03	AGQ	ETF	159.92	163.36	159.24	162.0	276875.0
2012-07-03	AGZ	ETF	113.51	113.63	113.4101	113.46	13231.0
2012-07-03	AIA	ETF	41.72	42.0	41.54	41.9285	4801.0
2012-07-03	AIQ	ETF	4.9	5.0	4.9	4.95	1005.0
2012-07-03	AIVI	ETF	38.21	38.5	38.13	38.42	56800.0
2012-07-03	AMJ	ETF	38.98	39.25	38.94	39.25	790032.0
2012-07-03	AMLP	ETF	80.1	80.85	80.1	80.45	212720.0
2012-07-03	AOA	ETF	35.14	35.36	35.14	35.32	4900.0
2012-07-03	AOK	ETF	29.92	29.9899	29.9	29.94	3505.0
2012-07-03	AOM	ETF	30.79	30.898	30.79	30.8899	12667.0
2012-07-03	AOR	ETF	32.6	32.76	32.6	32.6718	6597.0
2012-07-03	ARB	ETF	35.79	36.0	35.43	36.0	65552.0
2012-07-03	ARGT	ETF	16.36	16.82	16.36	16.82	1200.0
2012-07-03	ASEA	ETF	15.8	16.04	15.8	16.0	1900.0
2012-07-03	AWAY	ETF	21.95	22.1	21.59	22.04	192110.0
2012-07-03	BAB	ETF	29.87	29.87	29.7301	29.76	74133.0
2012-07-03	BAL	ETF	47.2899	47.81	47.2899	47.65	3600.0
2012-07-03	BALT	ETF	3.47	3.56	3.43	3.49	17658.0
2012-07-03	BBH	ETF	48.6	48.63	48.09	48.5	19500.0
2012-07-03	BCM	ETF	42.55	42.77	42.55	42.77	875.0
2012-07-03	BIB	ETF	13.8637	14.0725	13.75	13.9337	51600.0
2012-07-03	BICK	ETF	22.86	23.03	22.76	23.03	2864.0
2012-07-03	BIL	ETF	91.62	91.64	91.62	91.62	313050.0
2012-07-03	BIS	ETF	2998.4	2998.4	2969.312	2972.8	16.6
2012-07-03	BIV	ETF	88.99	89.0	88.84	88.88	227800.0
2012-07-03	BJK	ETF	31.78	32.04	31.78	31.95	3200.0
2012-07-03	BKF	ETF	36.29	36.78	36.1701	36.75	72867.0
2012-07-03	BKLN	ETF	24.42	24.44	24.36	24.44	87500.0
2012-07-03	BLV	ETF	95.36	95.43	95.04	95.09	29700.0
2012-07-03	BMVP	ETF	15.4733	15.4967	15.4733	15.4841	11520.0
2012-07-03	BND	ETF	84.42	84.42	84.23	84.25	1731700.0
2012-07-03	BNO	ETF	35.71	35.99	35.5	35.74	178800.0
2012-07-03	BOIL	ETF	925600.0	948000.0	924200.0	944600.0	5.2
2012-07-03	BOND	ETF	105.96	105.96	105.8	105.84	208768.0
2012-07-03	BRF	ETF	37.01	37.38	36.9	37.29	176453.0

> showing 50 of 918 rows — these rows as CSV

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