PREVIEW / etf_daily / 2011-05-10

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-10.parquet
  size:    36 KB
  rows:    856

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-10	SPY	ETF	135.17	136.11	135.0	135.87	114806900.0
2011-05-10	QQQ	ETF	58.87	59.28	58.775	59.19	38053599.0
2011-05-10	IWM	ETF	84.67	85.54	84.56	85.53	44373700.0
2011-05-10	DIA	ETF	126.96	127.67	126.81	127.45	4179600.0
2011-05-10	GLD	ETF	147.19	148.19	146.93	147.9	11285200.0
2011-05-10	TLT	ETF	94.7	94.89	94.29	94.29	5458300.0
2011-05-10	AAXJ	ETF	63.75	64.3	63.63	64.23	858700.0
2011-05-10	ACWI	ETF	49.71	49.97	49.62	49.96	423600.0
2011-05-10	ACWX	ETF	46.38	46.7	46.27	46.57	88515.0
2011-05-10	ADRE	ETF	46.94	47.25	46.8	47.17	44389.0
2011-05-10	AFK	ETF	33.19	33.48	33.0501	33.48	5871.0
2011-05-10	AGG	ETF	106.65	106.73	106.54	106.59	536100.0
2011-05-10	AGQ	ETF	434.28	448.88	429.4	440.8	2031500.0
2011-05-10	AGZ	ETF	110.133	110.133	109.97	110.02	3869.0
2011-05-10	AIA	ETF	48.36	48.72	48.34	48.68	33301.0
2011-05-10	AIQ	ETF	21.4	22.05	21.15	22.0	31209.0
2011-05-10	AIS	ETF	1.73	1.85	1.73	1.85	590730.0
2011-05-10	AIVI	ETF	48.67	49.15	48.63	49.15	21500.0
2011-05-10	AMJ	ETF	37.85	37.9	37.57	37.61	720898.0
2011-05-10	AMLP	ETF	80.6	80.85	80.15	80.35	128640.0
2011-05-10	AOA	ETF	36.8	36.93	36.76	36.93	10500.0
2011-05-10	AOK	ETF	29.48	29.56	29.48	29.55	25314.0
2011-05-10	AOM	ETF	30.98	31.1	30.98	31.0899	44926.0
2011-05-10	AOR	ETF	33.1301	33.3	33.1301	33.26	9314.0
2011-05-10	ARB	ETF	41.72	42.79	41.72	42.34	165330.0
2011-05-10	ARGT	ETF	30.0	30.3	30.0	30.3	7950.0
2011-05-10	ASEA	ETF	16.49	16.49	16.4	16.43	2400.0
2011-05-10	BAB	ETF	26.29	26.3	26.18	26.18	103064.0
2011-05-10	BAL	ETF	81.11	85.31	80.27	84.21	137014.0
2011-05-10	BALT	ETF	7.25	7.42	7.11	7.2	265724.0
2011-05-10	BBH	ETF	35.1167	35.1167	34.85	35.03	55200.0
2011-05-10	BCM	ETF	47.9	47.9	47.9	47.9	300.0
2011-05-10	BIB	ETF	10.1212	10.195	9.8362	10.0288	166936.0
2011-05-10	BICK	ETF	33.25	33.56	33.25	33.56	13352.0
2011-05-10	BIL	ETF	91.74	91.74	91.72	91.74	182200.0
2011-05-10	BIS	ETF	5908.912	5908.912	5848.0	5848.0	9.4
2011-05-10	BITS	ETF	22.72	22.868	22.44	22.568	446.0
2011-05-10	BIV	ETF	83.8	83.81	83.55	83.58	129500.0
2011-05-10	BJK	ETF	34.5	34.88	34.46	34.83	19000.0
2011-05-10	BKF	ETF	48.41	48.814	48.4	48.77	154107.0
2011-05-10	BKLN	ETF	25.29	25.29	25.25	25.28	265300.0
2011-05-10	BLV	ETF	80.46	80.75	80.34	80.46	43800.0
2011-05-10	BMVP	ETF	16.01	16.11	16.0	16.09	54162.0
2011-05-10	BND	ETF	81.19	81.21	81.03	81.05	643600.0
2011-05-10	BNO	ETF	38.23	39.055	38.015	38.965	119200.0
2011-05-10	BRF	ETF	57.54	58.08	57.26	58.01	149605.0
2011-05-10	BSCE	ETF	21.1326	21.1326	21.1	21.12	27378.0
2011-05-10	BSV	ETF	80.81	80.81	80.72	80.73	298000.0
2011-05-10	BTF	ETF	83.05	83.8	83.05	83.75	2428.4
2011-05-10	BWX	ETF	30.88	30.94	30.8	30.91	349608.0

> showing 50 of 856 rows — these rows as CSV

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