PREVIEW / etf_daily / 2012-08-03

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-03.parquet
  size:    38 KB
  rows:    942

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-08-03	SPY	ETF	138.56	139.64	136.68	139.35	157825000.0
2012-08-03	QQQ	ETF	65.38	65.88	65.19	65.6	42122944.0
2012-08-03	IWM	ETF	77.94	79.02	77.65	78.61	52414100.0
2012-08-03	DIA	ETF	130.06	131.07	129.88	130.73	7768300.0
2012-08-03	GLD	ETF	154.65	155.89	154.42	155.55	10670700.0
2012-08-03	TLT	ETF	127.84	128.03	126.77	127.42	9084800.0
2012-08-03	AADR	ETF	28.97	28.97	28.97	28.97	400.0
2012-08-03	AAXJ	ETF	53.4	53.74	53.22	53.63	264900.0
2012-08-03	ACTV	ETF	13.37	13.5	11.43	11.75	1646308.0
2012-08-03	ACWI	ETF	44.65	44.99	44.53	44.82	518900.0
2012-08-03	ACWV	ETF	55.92	56.26	55.6	55.95	67200.0
2012-08-03	ACWX	ETF	37.6	37.98	37.54	37.87	129026.0
2012-08-03	ADRE	ETF	38.31	38.5301	38.31	38.37	74334.0
2012-08-03	AFK	ETF	28.61	28.99	28.61	28.81	18349.0
2012-08-03	AGEM	ETF	21.96	21.96	21.96	21.96	230.0
2012-08-03	AGG	ETF	112.1	112.16	111.96	111.99	1832400.0
2012-08-03	AGQ	ETF	149.8	155.88	149.04	154.16	290100.0
2012-08-03	AGZ	ETF	113.64	113.79	113.5101	113.6	8531.0
2012-08-03	AIA	ETF	42.49	42.78	42.42	42.75	17157.0
2012-08-03	AIQ	ETF	4.85	4.95	4.75	4.9	7500.0
2012-08-03	AIVI	ETF	38.23	38.77	38.23	38.62	100700.0
2012-08-03	AMJ	ETF	39.53	39.72	39.31	39.48	2350164.0
2012-08-03	AMLP	ETF	82.5	82.75	82.05	82.4	297760.0
2012-08-03	ANGL	ETF	26.91	26.91	26.1	26.14	38300.0
2012-08-03	AOA	ETF	35.38	35.62	35.38	35.52	8300.0
2012-08-03	AOK	ETF	30.09	30.15	30.07	30.12	17188.0
2012-08-03	AOM	ETF	30.96	31.1	30.96	31.08	7022.0
2012-08-03	AOR	ETF	32.79	32.9501	32.78	32.9411	23421.0
2012-08-03	ARB	ETF	36.15	36.365	35.54	36.14	99433.0
2012-08-03	ARGT	ETF	16.16	16.56	16.16	16.56	1300.0
2012-08-03	ASEA	ETF	16.42	16.5	16.41	16.44	16300.0
2012-08-03	AWAY	ETF	23.33	23.82	23.033	23.74	333826.0
2012-08-03	BAB	ETF	30.41	30.41	30.27	30.325	144591.0
2012-08-03	BAL	ETF	47.72	48.84	47.6	48.59	14585.0
2012-08-03	BALT	ETF	3.38	3.48	3.33	3.39	78031.0
2012-08-03	BBH	ETF	50.0	50.0	49.38	49.41	11200.0
2012-08-03	BCM	ETF	43.94	43.9401	43.94	43.94	2069.0
2012-08-03	BIB	ETF	13.8325	13.9612	13.5539	13.5539	29000.0
2012-08-03	BICK	ETF	22.69	22.868	22.69	22.78	2879.0
2012-08-03	BIL	ETF	91.64	91.66	91.64	91.64	123350.0
2012-08-03	BIS	ETF	2937.6	2950.4	2934.4	2950.4	4.375
2012-08-03	BIV	ETF	89.66	89.71	89.47	89.62	205900.0
2012-08-03	BJK	ETF	30.29	30.62	30.2	30.61	6300.0
2012-08-03	BKF	ETF	36.08	36.5465	36.05	36.37	105081.0
2012-08-03	BKLN	ETF	24.63	24.65	24.59	24.65	139800.0
2012-08-03	BLV	ETF	97.67	97.67	96.92	97.43	38400.0
2012-08-03	BMVP	ETF	15.57	15.66	15.57	15.61	6166.0
2012-08-03	BND	ETF	84.94	84.95	84.78	84.79	1918100.0
2012-08-03	BNO	ETF	38.275	38.785	38.275	38.665	138800.0
2012-08-03	BOIL	ETF	937800.0	963800.0	910400.0	921200.0	9.6

> showing 50 of 942 rows — these rows as CSV

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