PREVIEW / etf_daily / 2012-08-14

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-14.parquet
  size:    38 KB
  rows:    922

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-14	SPY	ETF	141.29	141.38	140.37	140.79	102379400.0
2012-08-14	QQQ	ETF	67.28	67.41	66.86	67.05	24218673.0
2012-08-14	IWM	ETF	80.3	80.42	79.27	79.6	26052900.0
2012-08-14	DIA	ETF	132.05	132.16	131.32	131.66	3421500.0
2012-08-14	GLD	ETF	155.06	155.58	154.83	155.13	5075200.0
2012-08-14	TLT	ETF	123.96	124.41	123.75	123.79	7994000.0
2012-08-14	AAXJ	ETF	54.66	54.66	54.31	54.44	120800.0
2012-08-14	ACTV	ETF	11.26	11.535	11.26	11.45	334427.0
2012-08-14	ACWI	ETF	45.67	45.71	45.42	45.54	232800.0
2012-08-14	ACWV	ETF	55.93	56.0	55.7	55.7	6500.0
2012-08-14	ACWX	ETF	38.58	38.61	38.4	38.49	1119542.0
2012-08-14	ADRE	ETF	39.2	39.23	38.86	38.94	14527.0
2012-08-14	AFK	ETF	29.27	29.3599	29.1001	29.1001	17529.0
2012-08-14	AGEM	ETF	22.02	22.04	21.97	21.97	1215.0
2012-08-14	AGG	ETF	111.59	111.68	111.54	111.6	567100.0
2012-08-14	AGQ	ETF	153.76	154.76	153.36	154.24	113250.0
2012-08-14	AGZ	ETF	113.51	113.53	113.342	113.42	19414.0
2012-08-14	AIA	ETF	43.77	43.92	43.7188	43.7188	8469.0
2012-08-14	AIQ	ETF	5.45	6.5	5.45	5.75	19422.0
2012-08-14	AIVI	ETF	39.3	39.34	39.08	39.19	20800.0
2012-08-14	AMJ	ETF	39.59	39.71	39.48	39.71	385559.0
2012-08-14	AMLP	ETF	81.4	81.45	81.1	81.35	403100.0
2012-08-14	ANGL	ETF	26.35	26.35	26.35	26.35	300.0
2012-08-14	AOA	ETF	35.97	36.0	35.83	35.83	8200.0
2012-08-14	AOK	ETF	30.15	30.21	30.15	30.18	10239.0
2012-08-14	AOM	ETF	31.24	31.24	31.16	31.17	82100.0
2012-08-14	AOR	ETF	33.33	33.33	33.11	33.15	60495.0
2012-08-14	ARB	ETF	36.3	36.62	35.25	35.41	139772.0
2012-08-14	ARGT	ETF	17.3	17.32	17.22	17.32	2600.0
2012-08-14	ASEA	ETF	16.47	16.53	16.42	16.47	4700.0
2012-08-14	AWAY	ETF	23.95	24.05	23.61	23.88	319431.0
2012-08-14	BAB	ETF	30.03	30.03	29.89	29.91	568934.0
2012-08-14	BAL	ETF	47.98	47.98	47.27	47.73	12049.0
2012-08-14	BALT	ETF	3.34	3.41	3.3	3.32	39903.0
2012-08-14	BBH	ETF	49.98	50.27	49.83	50.12	13700.0
2012-08-14	BCM	ETF	44.2	44.2	44.0	44.0001	2789.0
2012-08-14	BIB	ETF	13.755	13.901	13.755	13.8825	15720.0
2012-08-14	BICK	ETF	23.29	23.39	23.27	23.2812	3623.0
2012-08-14	BIL	ETF	91.62	91.64	91.62	91.62	179250.0
2012-08-14	BIS	ETF	2937.6	2948.8	2937.6	2942.4	9.85
2012-08-14	BIV	ETF	89.15	89.18	89.0	89.03	180300.0
2012-08-14	BJK	ETF	30.92	30.97	30.88	30.91	3100.0
2012-08-14	BKF	ETF	37.18	37.22	36.79	36.87	34623.0
2012-08-14	BKLN	ETF	24.77	24.77	24.69	24.74	266800.0
2012-08-14	BLV	ETF	95.54	95.73	95.38	95.44	152700.0
2012-08-14	BMVP	ETF	15.9158	15.9444	15.9158	15.9167	25365.0
2012-08-14	BND	ETF	84.52	84.54	84.43	84.48	1119600.0
2012-08-14	BNO	ETF	40.39	40.42	40.17	40.42	52400.0
2012-08-14	BOIL	ETF	850800.0	895000.0	848200.0	882600.0	9.2
2012-08-14	BOND	ETF	107.05	107.06	106.85	106.95	407204.0

> showing 50 of 922 rows — these rows as CSV

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