PREVIEW / etf_daily / 2012-05-18

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-18.parquet
  size:    39 KB
  rows:    943

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-05-18	SPY	ETF	131.37	131.6	129.55	129.74	319615900.0
2012-05-18	QQQ	ETF	61.79	61.96	60.76	60.81	79496446.0
2012-05-18	IWM	ETF	75.39	75.91	74.49	74.69	77636200.0
2012-05-18	DIA	ETF	124.53	124.65	123.09	123.31	10861600.0
2012-05-18	GLD	ETF	154.46	155.13	153.97	154.55	12994200.0
2012-05-18	TLT	ETF	123.27	124.44	123.11	124.2	10137700.0
2012-05-18	AAXJ	ETF	50.8	50.94	50.25	50.31	673000.0
2012-05-18	ACTV	ETF	12.62	13.1	12.44	12.93	458127.0
2012-05-18	ACWI	ETF	42.73	42.74	42.19	42.27	1259100.0
2012-05-18	ACWV	ETF	52.76	52.76	52.18	52.32	8800.0
2012-05-18	ACWX	ETF	36.17	36.19	35.73	35.8	163969.0
2012-05-18	ADRE	ETF	36.52	36.66	35.0	36.27	35119.0
2012-05-18	AFK	ETF	27.51	27.78	27.14	27.2	13326.0
2012-05-18	AGEM	ETF	20.13	20.18	20.0	20.042	1418.0
2012-05-18	AGG	ETF	110.99	111.08	110.9	111.0	1184700.0
2012-05-18	AGQ	ETF	166.52	171.96	166.2	168.6	454675.0
2012-05-18	AGZ	ETF	113.21	113.43	113.05	113.27	12246.0
2012-05-18	AIA	ETF	40.35	40.35	39.76	39.9	9592.0
2012-05-18	AIQ	ETF	5.25	5.55	5.1	5.4	9493.0
2012-05-18	AIS	ETF	2.94	2.99	2.85	2.9	1241666.0
2012-05-18	AIVI	ETF	37.54	37.61	37.06	37.09	70300.0
2012-05-18	AMJ	ETF	37.81	37.88	36.808	36.87	2556700.0
2012-05-18	AMLP	ETF	79.3	79.75	78.3	78.45	523560.0
2012-05-18	ANGL	ETF	25.09	25.12	24.83	24.83	11000.0
2012-05-18	AOA	ETF	34.12	34.12	33.75	33.75	14000.0
2012-05-18	AOK	ETF	29.6	29.6	29.4858	29.51	27609.0
2012-05-18	AOM	ETF	30.32	30.32	30.142	30.18	9410.0
2012-05-18	AOR	ETF	31.82	31.86	31.618	31.65	11976.0
2012-05-18	ARB	ETF	34.85	35.01	34.15	34.52	231500.0
2012-05-18	ARGT	ETF	15.92	15.92	15.6	15.6	3600.0
2012-05-18	ASEA	ETF	15.15	15.15	15.02	15.07	46100.0
2012-05-18	AWAY	ETF	25.22	25.81	24.26	24.74	563572.0
2012-05-18	BAB	ETF	29.76	30.49	29.7	29.87	1207073.0
2012-05-18	BAL	ETF	47.84	48.39	47.69	48.27	52850.0
2012-05-18	BALT	ETF	3.84	3.84	3.66	3.67	146153.0
2012-05-18	BBH	ETF	45.63	45.63	44.81	44.87	23000.0
2012-05-18	BCM	ETF	42.1	42.13	42.071	42.071	1385.0
2012-05-18	BIB	ETF	11.8138	11.8138	11.3112	11.324	73464.0
2012-05-18	BICK	ETF	22.05	22.06	21.7076	21.7076	9718.0
2012-05-18	BIL	ETF	91.64	91.66	91.64	91.66	575400.0
2012-05-18	BIS	ETF	3651.2	3776.0	3651.2	3772.8	39.85
2012-05-18	BIV	ETF	88.25	88.45	88.16	88.35	145300.0
2012-05-18	BJK	ETF	32.1	32.41	31.62	31.67	16000.0
2012-05-18	BKF	ETF	35.08	35.1	34.42	34.63	325200.0
2012-05-18	BKLN	ETF	24.34	24.39	24.19	24.19	671800.0
2012-05-18	BLV	ETF	93.83	94.63	93.52	94.08	45600.0
2012-05-18	BMVP	ETF	14.45	14.45	14.29	14.29	31472.0
2012-05-18	BND	ETF	84.05	84.19	84.01	84.09	1041300.0
2012-05-18	BNO	ETF	38.04	38.11	37.72	37.72	85600.0
2012-05-18	BOIL	ETF	966600.0	1040000.0	964800.0	1007800.0	16.4

> showing 50 of 943 rows — these rows as CSV

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