PREVIEW / etf_daily / 2012-07-17

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-17.parquet
  size:    38 KB
  rows:    923

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-17	SPY	ETF	135.97	136.64	134.55	136.36	138860300.0
2012-07-17	QQQ	ETF	63.58	63.74	62.63	63.53	42476969.0
2012-07-17	IWM	ETF	79.98	80.15	78.65	79.73	43662500.0
2012-07-17	DIA	ETF	127.53	128.15	126.29	127.82	3326900.0
2012-07-17	GLD	ETF	154.01	154.5	152.45	153.47	13021800.0
2012-07-17	TLT	ETF	129.26	129.82	128.64	128.75	5590900.0
2012-07-17	AADR	ETF	27.86	27.98	27.86	27.98	500.0
2012-07-17	AAXJ	ETF	52.1	52.49	51.54	52.39	281900.0
2012-07-17	ACTV	ETF	14.75	14.82	14.4915	14.76	149578.0
2012-07-17	ACWI	ETF	43.68	43.85	43.22	43.77	568400.0
2012-07-17	ACWV	ETF	55.04	55.38	55.04	55.3	1700.0
2012-07-17	ACWX	ETF	36.8	36.93	36.38	36.9	379576.0
2012-07-17	ADRE	ETF	37.2	37.2948	36.7925	37.26	44991.0
2012-07-17	AFK	ETF	27.99	28.16	27.82	28.09	23772.0
2012-07-17	AGEM	ETF	20.9301	21.04	20.93	20.93	1710.0
2012-07-17	AGG	ETF	112.21	112.24	112.12	112.13	600200.0
2012-07-17	AGQ	ETF	149.76	151.08	144.0	149.08	358800.0
2012-07-17	AGZ	ETF	113.94	113.94	113.7959	113.84	5541.0
2012-07-17	AIA	ETF	40.54	41.0375	40.4465	40.97	7918.0
2012-07-17	AIQ	ETF	4.5565	4.65	4.45	4.45	2880.0
2012-07-17	AIVI	ETF	37.71	37.77	37.1	37.72	76100.0
2012-07-17	AMJ	ETF	39.69	39.93	39.64	39.85	854602.0
2012-07-17	AMLP	ETF	82.15	82.65	82.05	82.65	395500.0
2012-07-17	ANGL	ETF	25.7	25.7	25.7	25.7	5000.0
2012-07-17	AOA	ETF	34.77	35.03	34.77	35.03	6200.0
2012-07-17	AOK	ETF	29.92	29.9699	29.8504	29.959	12591.0
2012-07-17	AOM	ETF	30.7242	30.788	30.64	30.788	8054.0
2012-07-17	AOR	ETF	32.55	32.58	32.36	32.58	11299.0
2012-07-17	ARB	ETF	34.61	34.71	34.21	34.59	75715.0
2012-07-17	ARGT	ETF	15.82	15.84	15.68	15.72	1700.0
2012-07-17	ASEA	ETF	15.91	16.14	15.87	16.14	14600.0
2012-07-17	AWAY	ETF	21.43	21.6	21.14	21.55	178411.0
2012-07-17	BAB	ETF	30.29	30.32	30.14	30.22	165532.0
2012-07-17	BAL	ETF	47.45	47.69	46.68	46.92	114664.0
2012-07-17	BALT	ETF	3.53	3.58	3.42	3.54	35450.0
2012-07-17	BBH	ETF	48.69	49.0	48.32	48.94	15900.0
2012-07-17	BCM	ETF	43.6	43.61	43.4424	43.4424	1353.0
2012-07-17	BIB	ETF	13.935	14.05	13.5455	14.0085	83856.0
2012-07-17	BICK	ETF	22.08	22.08	21.7262	22.013	8720.0
2012-07-17	BIL	ETF	91.62	91.64	91.62	91.62	46550.0
2012-07-17	BIS	ETF	2977.6	3007.984	2937.44	2948.16	27.95
2012-07-17	BIV	ETF	89.8	89.88	89.69	89.77	275200.0
2012-07-17	BJK	ETF	31.04	31.19	30.65	31.11	10000.0
2012-07-17	BKF	ETF	35.36	35.62	35.01	35.58	116278.0
2012-07-17	BKLN	ETF	24.53	24.6	24.47	24.49	421700.0
2012-07-17	BLV	ETF	97.74	97.92	97.31	97.51	26000.0
2012-07-17	BMVP	ETF	15.4167	15.5167	15.3567	15.4967	16500.0
2012-07-17	BND	ETF	84.93	84.95	84.86	84.88	1046800.0
2012-07-17	BNO	ETF	37.115	37.13	36.55	36.845	116800.0
2012-07-17	BOIL	ETF	874000.0	901800.0	870400.0	875800.0	5.6

> showing 50 of 923 rows — these rows as CSV

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