PREVIEW / etf_daily / 2011-04-29

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-29.parquet
  size:    35 KB
  rows:    847

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-04-29	SPY	ETF	136.16	136.57	135.98	136.43	115094100.0
2011-04-29	QQQ	ETF	59.04	59.29	58.98	59.08	44831144.0
2011-04-29	IWM	ETF	86.19	86.68	85.93	86.39	41030900.0
2011-04-29	DIA	ETF	127.56	128.12	127.54	128.04	11425900.0
2011-04-29	GLD	ETF	149.9	153.03	149.75	152.37	27600000.0
2011-04-29	TLT	ETF	93.47	93.92	93.35	93.89	5900000.0
2011-04-29	AADR	ETF	31.95	31.99	31.95	31.99	500.0
2011-04-29	AAXJ	ETF	64.59	64.88	64.46	64.84	474000.0
2011-04-29	ACWI	ETF	50.62	50.77	50.49	50.69	217000.0
2011-04-29	ACWX	ETF	47.53	47.72	47.47	47.72	94087.0
2011-04-29	ADRE	ETF	48.22	48.74	48.22	48.74	21877.0
2011-04-29	AFK	ETF	34.25	34.26	34.06	34.2399	6540.0
2011-04-29	AGG	ETF	106.24	106.49	106.24	106.46	499000.0
2011-04-29	AGQ	ETF	740.68	752.76	708.08	717.92	1729500.0
2011-04-29	AGZ	ETF	109.96	110.34	109.82	110.121	7172.0
2011-04-29	AIA	ETF	49.16	49.31	49.05	49.31	206006.0
2011-04-29	AIQ	ETF	23.0	23.4	21.95	22.1	88563.0
2011-04-29	AIS	ETF	1.8	1.92	1.79	1.86	1520940.0
2011-04-29	AIVI	ETF	50.24	50.79	50.17	50.25	7300.0
2011-04-29	AMJ	ETF	39.25	39.41	39.16	39.2	901595.0
2011-04-29	AMLP	ETF	83.45	83.95	83.45	83.55	105800.0
2011-04-29	AOA	ETF	37.1	37.19	37.04	37.12	17000.0
2011-04-29	AOK	ETF	29.59	30.01	29.5708	29.59	16163.0
2011-04-29	AOM	ETF	31.09	31.18	31.09	31.17	8917.0
2011-04-29	AOR	ETF	33.33	33.46	33.3	33.426	118384.0
2011-04-29	ARB	ETF	38.15	38.83	38.15	38.68	171412.0
2011-04-29	ARGT	ETF	30.04	30.72	30.04	30.72	2700.0
2011-04-29	ASEA	ETF	16.68	16.76	16.54	16.73	12000.0
2011-04-29	BAB	ETF	25.81	25.89	25.75	25.8373	75391.0
2011-04-29	BAL	ETF	83.49	89.0	82.89	88.0	356692.0
2011-04-29	BALT	ETF	8.18	8.2	7.96	8.01	147604.0
2011-04-29	BBH	ETF	34.4533	34.51	34.2567	34.2933	99000.0
2011-04-29	BCM	ETF	50.42	50.84	50.42	50.79	3500.0
2011-04-29	BIB	ETF	9.9462	9.9925	9.7825	9.7825	49544.0
2011-04-29	BICK	ETF	34.88	34.95	34.69	34.8895	8567.0
2011-04-29	BIL	ETF	91.7	91.72	91.7	91.7	74500.0
2011-04-29	BIS	ETF	5888.0	5947.2	5888.0	5947.2	5.0
2011-04-29	BITS	ETF	24.96	24.96	24.68	24.816	1038.0
2011-04-29	BIV	ETF	83.21	83.46	83.1	83.46	92000.0
2011-04-29	BJK	ETF	35.0	35.35	35.0	35.31	3900.0
2011-04-29	BKF	ETF	49.86	50.4	49.8	50.37	243154.0
2011-04-29	BKLN	ETF	25.27	25.29	25.26	25.28	101000.0
2011-04-29	BLNG	ETF	52.08	52.76	52.08	52.48	4230.0
2011-04-29	BLV	ETF	79.83	80.06	79.67	80.05	15000.0
2011-04-29	BMVP	ETF	16.02	16.08	16.02	16.08	5257.0
2011-04-29	BND	ETF	80.81	80.99	80.81	80.96	526000.0
2011-04-29	BNO	ETF	41.685	41.89	41.645	41.855	28000.0
2011-04-29	BOSS	ETF	61.6	62.04	61.6	62.04	200.0
2011-04-29	BRF	ETF	58.4	58.75	58.14	58.36	227278.0
2011-04-29	BSCE	ETF	21.06	21.1095	21.06	21.1095	13344.0

> showing 50 of 847 rows — these rows as CSV

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