PREVIEW / etf_daily / 2012-07-10

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-10.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-07-10	SPY	ETF	136.01	136.23	133.68	134.14	167884800.0
2012-07-10	QQQ	ETF	64.33	64.51	63.12	63.37	47365647.0
2012-07-10	IWM	ETF	80.81	80.96	78.98	79.33	49990800.0
2012-07-10	DIA	ETF	127.96	128.14	125.91	126.35	6730900.0
2012-07-10	GLD	ETF	155.13	155.18	151.78	152.15	9747900.0
2012-07-10	TLT	ETF	127.86	128.74	127.72	128.44	4288000.0
2012-07-10	AADR	ETF	28.5	28.5	28.5	28.5	200.0
2012-07-10	AAXJ	ETF	52.5	52.55	51.54	51.74	194400.0
2012-07-10	ACTV	ETF	15.0	15.0604	14.91	14.94	226172.0
2012-07-10	ACWI	ETF	43.84	43.85	43.13	43.27	617500.0
2012-07-10	ACWV	ETF	54.65	54.75	54.65	54.65	2900.0
2012-07-10	ACWX	ETF	36.96	36.96	36.34	36.48	316286.0
2012-07-10	ADRE	ETF	37.75	37.75	36.758	36.89	28508.0
2012-07-10	AFK	ETF	27.93	27.9634	27.41	27.43	19911.0
2012-07-10	AGEM	ETF	20.6656	20.6656	20.6309	20.6309	1427.0
2012-07-10	AGG	ETF	111.76	111.91	111.73	111.85	521600.0
2012-07-10	AGQ	ETF	151.6	151.8	144.0	145.04	341525.0
2012-07-10	AGZ	ETF	113.69	113.77	113.61	113.769	11043.0
2012-07-10	AIA	ETF	40.93	40.93	40.1457	40.27	7086.0
2012-07-10	AIQ	ETF	4.5	4.65	4.35	4.6	12216.0
2012-07-10	AIVI	ETF	37.44	37.5	36.79	36.91	47800.0
2012-07-10	AMJ	ETF	39.07	39.29	38.66	39.09	967777.0
2012-07-10	AMLP	ETF	80.7	81.25	80.55	80.8	362480.0
2012-07-10	ANGL	ETF	25.5	25.5	25.29	25.29	200.0
2012-07-10	AOA	ETF	35.03	35.03	34.56	34.56	5400.0
2012-07-10	AOK	ETF	29.9	29.938	29.82	29.82	13480.0
2012-07-10	AOM	ETF	30.7511	30.7511	30.59	30.59	28181.0
2012-07-10	AOR	ETF	32.51	32.57	32.21	32.26	7006.0
2012-07-10	ARB	ETF	35.1	35.31	34.45	34.55	101825.0
2012-07-10	ASEA	ETF	15.73	15.81	15.55	15.55	20700.0
2012-07-10	AWAY	ETF	20.51	20.9752	20.2	20.33	205341.0
2012-07-10	BAB	ETF	30.11	30.19	30.06	30.18	208279.0
2012-07-10	BAL	ETF	47.1399	47.1399	46.6	46.69	33491.0
2012-07-10	BALT	ETF	3.66	3.67	3.42	3.53	60906.0
2012-07-10	BBH	ETF	48.25	48.29	47.5	47.61	16700.0
2012-07-10	BCM	ETF	42.5199	42.5199	42.15	42.15	808.0
2012-07-10	BIB	ETF	13.985	13.985	13.29	13.3	109096.0
2012-07-10	BICK	ETF	22.15	22.1585	22.02	22.02	1388.0
2012-07-10	BIL	ETF	91.62	91.64	91.62	91.62	451450.0
2012-07-10	BIS	ETF	2992.0	3016.0	2992.0	3016.0	18.1
2012-07-10	BIV	ETF	89.41	89.55	89.37	89.54	189000.0
2012-07-10	BJK	ETF	31.42	31.47	31.22	31.22	15300.0
2012-07-10	BKF	ETF	35.91	35.91	34.93	35.04	52560.0
2012-07-10	BKLN	ETF	24.49	24.52	24.47	24.49	158600.0
2012-07-10	BLV	ETF	96.38	96.99	96.38	96.95	47200.0
2012-07-10	BMVP	ETF	15.43	15.43	15.17	15.17	4168.0
2012-07-10	BND	ETF	84.75	84.83	84.7	84.81	791600.0
2012-07-10	BNO	ETF	35.18	35.18	34.615	34.685	37400.0
2012-07-10	BOIL	ETF	894600.0	899400.0	840000.0	845200.0	27.8
2012-07-10	BOND	ETF	106.4	106.5	106.378	106.46	409474.0

> showing 50 of 922 rows — these rows as CSV

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