PREVIEW / etf_daily / 2012-08-17

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-17.parquet
  size:    38 KB
  rows:    936

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-17	SPY	ETF	142.23	142.3	141.86	142.18	90813700.0
2012-08-17	QQQ	ETF	68.17	68.33	68.01	68.32	22584723.0
2012-08-17	IWM	ETF	81.22	81.86	80.99	81.71	33453500.0
2012-08-17	DIA	ETF	132.29	132.52	132.19	132.42	2484300.0
2012-08-17	GLD	ETF	157.06	157.07	156.22	156.72	7812100.0
2012-08-17	TLT	ETF	121.4	122.12	121.32	121.6	6341100.0
2012-08-17	AAXJ	ETF	54.4	54.43	54.15	54.29	180300.0
2012-08-17	ACTV	ETF	11.5	11.63	11.4	11.5	378282.0
2012-08-17	ACWI	ETF	46.01	46.04	45.87	45.99	157800.0
2012-08-17	ACWV	ETF	55.89	56.01	55.85	55.86	7700.0
2012-08-17	ACWX	ETF	38.85	38.85	38.65	38.79	108150.0
2012-08-17	ADRE	ETF	38.97	39.14	38.89	39.03	22321.0
2012-08-17	AFK	ETF	29.24	29.56	29.02	29.33	65119.0
2012-08-17	AGEM	ETF	22.09	22.09	22.09	22.09	262.0
2012-08-17	AGG	ETF	111.19	111.29	111.15	111.23	505700.0
2012-08-17	AGQ	ETF	159.44	159.56	156.6	157.44	118575.0
2012-08-17	AGZ	ETF	113.2089	113.34	113.15	113.2501	28470.0
2012-08-17	AIA	ETF	43.1	43.12	43.0292	43.11	14530.0
2012-08-17	AIQ	ETF	6.35	6.9	6.0	6.9	14309.0
2012-08-17	AIVI	ETF	39.77	39.93	39.72	39.93	33300.0
2012-08-17	AMJ	ETF	40.05	40.2	39.96	40.14	368597.0
2012-08-17	AMLP	ETF	81.9	82.0	81.7	81.9	271440.0
2012-08-17	ANGL	ETF	26.1	26.1	26.1	26.1	100.0
2012-08-17	AOA	ETF	36.1	36.2	36.1	36.16	13100.0
2012-08-17	AOK	ETF	30.18	30.2	30.14	30.14	22458.0
2012-08-17	AOM	ETF	31.27	31.27	31.2104	31.24	19339.0
2012-08-17	AOR	ETF	33.2745	33.33	33.25	33.33	17561.0
2012-08-17	ARB	ETF	36.42	37.19	36.4	37.18	66795.0
2012-08-17	ARGT	ETF	17.24	17.24	17.16	17.16	17650.0
2012-08-17	ASEA	ETF	16.49	16.49	16.33	16.42	3300.0
2012-08-17	AWAY	ETF	24.65	25.1	24.65	25.0	327092.0
2012-08-17	BAB	ETF	29.58	29.71	29.58	29.66	149121.0
2012-08-17	BAL	ETF	48.24	48.8924	48.24	48.65	4293.0
2012-08-17	BALT	ETF	3.13	3.18	3.0	3.0	111641.0
2012-08-17	BBH	ETF	50.04	50.05	49.5	49.87	11100.0
2012-08-17	BCM	ETF	44.718	44.718	44.69	44.69	1426.0
2012-08-17	BIB	ETF	13.715	13.82	13.52	13.8187	66296.0
2012-08-17	BICK	ETF	23.3	23.409	23.3	23.409	896.0
2012-08-17	BIL	ETF	91.62	91.64	91.62	91.62	190050.0
2012-08-17	BIS	ETF	2924.8	2990.4	2924.8	2990.4	228.0
2012-08-17	BIV	ETF	88.65	88.77	88.56	88.7	151200.0
2012-08-17	BJK	ETF	31.98	32.11	31.95	32.02	2000.0
2012-08-17	BKF	ETF	36.99	37.25	36.81	36.97	69228.0
2012-08-17	BKLN	ETF	24.66	24.66	24.63	24.66	269400.0
2012-08-17	BLV	ETF	93.96	94.35	93.86	94.09	28500.0
2012-08-17	BMVP	ETF	16.0333	16.0434	16.0134	16.0434	1610.0
2012-08-17	BND	ETF	84.16	84.29	84.16	84.23	799100.0
2012-08-17	BNO	ETF	41.11	41.17	40.7	40.98	66200.0
2012-08-17	BOIL	ETF	821600.0	835600.0	810000.0	828200.0	3.8
2012-08-17	BOND	ETF	106.51	106.61	106.471	106.53	182114.0

> showing 50 of 936 rows — these rows as CSV

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