PREVIEW / etf_daily / 2012-08-09

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-09.parquet
  size:    38 KB
  rows:    934

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-09	SPY	ETF	140.29	140.89	140.15	140.61	90291700.0
2012-08-09	QQQ	ETF	66.62	66.91	66.49	66.82	20726183.0
2012-08-09	IWM	ETF	79.76	80.39	79.69	80.2	24045900.0
2012-08-09	DIA	ETF	131.5	131.87	131.11	131.57	3355100.0
2012-08-09	GLD	ETF	156.36	157.0	156.28	156.99	3177800.0
2012-08-09	TLT	ETF	124.77	125.3	123.75	125.07	7553500.0
2012-08-09	AADR	ETF	29.75	29.75	29.38	29.38	300.0
2012-08-09	AAXJ	ETF	54.37	54.72	54.35	54.42	154500.0
2012-08-09	ACTV	ETF	11.49	11.63	11.42	11.6	435843.0
2012-08-09	ACWI	ETF	45.39	45.64	45.38	45.54	99900.0
2012-08-09	ACWV	ETF	55.93	55.93	55.15	55.25	65200.0
2012-08-09	ACWX	ETF	38.35	38.65	38.35	38.56	227676.0
2012-08-09	ADRE	ETF	39.04	39.332	38.68	39.15	32802.0
2012-08-09	AFK	ETF	28.95	29.221	28.86	29.1	75420.0
2012-08-09	AGEM	ETF	22.2	22.225	21.988	21.988	894.0
2012-08-09	AGG	ETF	111.63	111.78	111.55	111.69	835900.0
2012-08-09	AGQ	ETF	156.52	158.72	156.32	157.8	108125.0
2012-08-09	AGZ	ETF	113.47	113.47	113.35	113.388	4328.0
2012-08-09	AIA	ETF	43.5	43.839	43.5	43.52	15289.0
2012-08-09	AIQ	ETF	5.4	5.65	4.975	5.65	16760.0
2012-08-09	AIVI	ETF	39.14	39.41	39.12	39.28	18400.0
2012-08-09	AMJ	ETF	39.36	39.5	39.19	39.44	436746.0
2012-08-09	AMLP	ETF	80.75	81.15	80.7	81.05	326460.0
2012-08-09	ANGL	ETF	26.25	26.25	26.2	26.25	4400.0
2012-08-09	AOA	ETF	35.77	35.94	35.77	35.9	3400.0
2012-08-09	AOK	ETF	30.17	30.19	30.14	30.15	17497.0
2012-08-09	AOM	ETF	31.18	31.23	31.135	31.21	16396.0
2012-08-09	AOR	ETF	33.12	33.19	33.08	33.17	38671.0
2012-08-09	ARB	ETF	35.74	36.12	35.43	35.96	108553.0
2012-08-09	ARGT	ETF	17.24	17.52	17.24	17.32	2350.0
2012-08-09	ASEA	ETF	16.55	16.55	16.41	16.43	6300.0
2012-08-09	AWAY	ETF	23.92	24.18	23.9	23.97	334569.0
2012-08-09	BAB	ETF	30.08	30.12	29.98	30.06	130810.0
2012-08-09	BAL	ETF	50.44	50.98	50.08	50.12	14514.0
2012-08-09	BALT	ETF	3.31	3.39	3.28	3.34	9381.0
2012-08-09	BBH	ETF	49.66	50.06	49.61	49.76	5000.0
2012-08-09	BCM	ETF	44.39	44.66	44.39	44.5901	628.0
2012-08-09	BIB	ETF	13.6679	13.7875	13.5625	13.6475	13312.0
2012-08-09	BICK	ETF	23.49	23.54	23.4381	23.44	4343.0
2012-08-09	BIL	ETF	91.62	91.64	91.62	91.62	65400.0
2012-08-09	BIS	ETF	2972.8	2972.8	2972.8	2972.8	1.25
2012-08-09	BIV	ETF	89.15	89.23	89.0	89.11	342200.0
2012-08-09	BJK	ETF	31.21	31.32	31.09	31.1	2000.0
2012-08-09	BKF	ETF	37.17	37.4	37.0402	37.13	50362.0
2012-08-09	BKLN	ETF	24.7	24.73	24.63	24.71	401200.0
2012-08-09	BLV	ETF	95.98	96.17	95.46	96.07	89000.0
2012-08-09	BMVP	ETF	15.87	15.87	15.83	15.84	3200.0
2012-08-09	BND	ETF	84.54	84.64	84.44	84.58	1676600.0
2012-08-09	BNO	ETF	39.905	40.305	39.905	40.28	40600.0
2012-08-09	BOIL	ETF	940800.0	1062000.0	927000.0	939000.0	24.0

> showing 50 of 934 rows — these rows as CSV

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