PREVIEW / etf_daily / 2011-05-13

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-13.parquet
  size:    36 KB
  rows:    846

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
2011-05-13	SPY	ETF	135.15	135.34	133.56	134.04	157444900.0
2011-05-13	QQQ	ETF	58.98	59.07	58.39	58.41	63506567.0
2011-05-13	IWM	ETF	84.76	84.99	83.27	83.51	74669000.0
2011-05-13	DIA	ETF	126.98	127.12	125.41	125.96	6677500.0
2011-05-13	GLD	ETF	146.72	147.28	144.49	145.63	17268700.0
2011-05-13	TLT	ETF	94.65	95.49	94.53	95.08	8380000.0
2011-05-13	AADR	ETF	31.52	31.52	30.85	30.85	500.0
2011-05-13	AAXJ	ETF	63.46	63.46	62.36	62.57	318400.0
2011-05-13	ACWI	ETF	49.36	49.43	48.47	48.64	559000.0
2011-05-13	ACWX	ETF	45.75	45.75	44.88	45.14	84169.0
2011-05-13	ADRE	ETF	46.13	46.26	45.2529	45.51	57693.0
2011-05-13	AFK	ETF	32.5	32.6	32.11	32.16	9521.0
2011-05-13	AGG	ETF	106.74	106.99	106.7	106.79	312700.0
2011-05-13	AGQ	ETF	350.9	361.4	323.1	349.48	2084400.0
2011-05-13	AGZ	ETF	110.14	110.19	110.06	110.06	13157.0
2011-05-13	AIA	ETF	48.18	48.18	47.28	47.4	9726.0
2011-05-13	AIQ	ETF	21.55	21.55	21.0	21.05	8609.0
2011-05-13	AIS	ETF	1.67	1.75	1.65	1.71	1780656.0
2011-05-13	AIVI	ETF	48.53	48.53	47.65	47.79	21600.0
2011-05-13	AMJ	ETF	36.8	37.07	36.4	36.54	618708.0
2011-05-13	AMLP	ETF	79.05	79.6	78.5	78.5	164380.0
2011-05-13	AOA	ETF	36.59	36.61	36.21	36.27	6400.0
2011-05-13	AOK	ETF	29.47	29.47	29.408	29.43	7195.0
2011-05-13	AOM	ETF	30.98	30.98	30.78	30.86	7429.0
2011-05-13	AOR	ETF	33.13	33.13	32.8478	32.9	16180.0
2011-05-13	ARB	ETF	42.19	42.35	41.45	41.83	101821.0
2011-05-13	ASEA	ETF	16.4	16.4	16.11	16.11	2600.0
2011-05-13	BAB	ETF	26.22	26.34	26.2	26.28	236692.0
2011-05-13	BAL	ETF	81.35	82.04	79.91	80.52	58373.0
2011-05-13	BALT	ETF	6.95	6.96	6.71	6.74	150770.0
2011-05-13	BBH	ETF	35.59	35.86	35.4367	35.5333	97800.0
2011-05-13	BIB	ETF	10.2925	10.2925	9.9887	10.0563	119392.0
2011-05-13	BICK	ETF	32.97	32.97	32.221	32.42	21610.0
2011-05-13	BIL	ETF	91.74	91.74	91.72	91.72	42950.0
2011-05-13	BITS	ETF	22.92	23.0004	21.62	22.6	7148.0
2011-05-13	BIV	ETF	83.78	83.99	83.67	83.81	94600.0
2011-05-13	BJK	ETF	34.6	34.73	34.2	34.31	4200.0
2011-05-13	BKF	ETF	47.76	47.76	46.75	47.04	160798.0
2011-05-13	BKLN	ETF	25.22	25.22	25.17	25.21	340400.0
2011-05-13	BLNG	ETF	47.94	48.1	47.08	47.33	4700.0
2011-05-13	BLV	ETF	80.63	81.2	80.63	80.91	19500.0
2011-05-13	BMVP	ETF	15.97	15.97	15.82	15.86	2674.0
2011-05-13	BND	ETF	81.18	81.36	81.16	81.19	696200.0
2011-05-13	BNO	ETF	37.585	37.83	37.025	37.78	211200.0
2011-05-13	BRF	ETF	57.19	57.2	55.58	55.9	175813.0
2011-05-13	BSCE	ETF	21.12	21.178	21.114	21.15	11448.0
2011-05-13	BSV	ETF	80.82	80.9	80.79	80.84	354700.0
2011-05-13	BTF	ETF	83.25049999999999	83.85	83.25049999999999	83.6505	1512.6000000000001
2011-05-13	BWX	ETF	30.665	30.67	30.405	30.435	372320.0
2011-05-13	BWZ	ETF	39.07	39.09	38.68	38.83	24053.0

> showing 50 of 846 rows — these rows as CSV

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