PREVIEW / etf_daily / 2011-03-29

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-29.parquet
  size:    35 KB
  rows:    831

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-03-29	SPY	ETF	130.87	131.9	130.44	131.86	129798800.0
2011-03-29	QQQ	ETF	56.4	57.08	56.23	57.08	47994651.0
2011-03-29	IWM	ETF	82.09	82.89	81.58	82.81	40967200.0
2011-03-29	DIA	ETF	121.74	122.6	121.49	122.51	6025800.0
2011-03-29	GLD	ETF	138.21	138.82	137.94	138.21	6345200.0
2011-03-29	TLT	ETF	91.98	92.5	91.57	91.59	6487200.0
2011-03-29	AADR	ETF	30.08	30.08	30.08	30.08	400.0
2011-03-29	AAXJ	ETF	61.44	61.91	61.38	61.81	357700.0
2011-03-29	ACWI	ETF	47.61	48.02	47.45	48.02	91600.0
2011-03-29	ACWX	ETF	44.52	44.94	44.44	44.94	42611.0
2011-03-29	ADRE	ETF	46.92	47.46	46.92	47.4	41670.0
2011-03-29	AFK	ETF	32.6	32.97	32.52	32.9	36957.0
2011-03-29	AGG	ETF	105.12	105.31	105.03	105.07	538100.0
2011-03-29	AGQ	ETF	431.2	438.88	427.5	435.5	365200.0
2011-03-29	AGZ	ETF	109.47	109.47	109.06	109.17	17853.0
2011-03-29	AIA	ETF	46.6	46.86	46.56	46.8001	27592.0
2011-03-29	AIQ	ETF	22.05	22.05	21.3	21.8	34296.0
2011-03-29	AIS	ETF	1.66	1.69	1.63	1.68	224179.0
2011-03-29	AIVI	ETF	45.97	46.52	45.96	46.5	19200.0
2011-03-29	AMJ	ETF	37.77	37.77	37.4	37.48	422323.0
2011-03-29	AMLP	ETF	81.45	81.45	81.0	81.1	99160.0
2011-03-29	AOA	ETF	35.38	35.68	35.34	35.67	14200.0
2011-03-29	AOK	ETF	29.08	29.15	29.08	29.11	15263.0
2011-03-29	AOM	ETF	30.36	30.41	30.34	30.41	11389.0
2011-03-29	AOR	ETF	32.14	32.36	32.14	32.33	20813.0
2011-03-29	ARB	ETF	38.4	39.02	38.35	39.02	110247.0
2011-03-29	ARGT	ETF	29.66	29.76	29.64	29.76	4000.0
2011-03-29	ASEA	ETF	15.56	15.66	15.56	15.66	1300.0
2011-03-29	BAB	ETF	25.24	25.33	25.13	25.2	221136.0
2011-03-29	BAL	ETF	101.3	102.0	100.315	100.57	112599.0
2011-03-29	BALT	ETF	9.0	9.0	8.85	8.94	76414.0
2011-03-29	BBH	ETF	34.73	35.0033	34.73	34.9867	15600.0
2011-03-29	BIB	ETF	8.0538	8.0538	8.0538	8.0538	2400.0
2011-03-29	BICK	ETF	32.3	32.75	32.3	32.73	15782.0
2011-03-29	BIL	ETF	91.72	91.72	91.7	91.7	240950.0
2011-03-29	BIS	ETF	7539.2	7539.2	7334.4	7334.416	21.9
2011-03-29	BITS	ETF	25.72	25.72	25.04	25.4432	550.0
2011-03-29	BIV	ETF	82.07	82.15	81.8	81.87	70200.0
2011-03-29	BJK	ETF	31.79	32.08	31.76	32.07	7500.0
2011-03-29	BKF	ETF	48.71	49.14	48.55	49.1	38246.0
2011-03-29	BKLN	ETF	25.04	25.06	25.0	25.06	43900.0
2011-03-29	BLV	ETF	78.25	78.52	78.0	78.08	63300.0
2011-03-29	BMVP	ETF	15.46	15.53	15.36	15.52	8287.0
2011-03-29	BND	ETF	80.08	80.19	79.93	79.97	649500.0
2011-03-29	BNO	ETF	37.985	38.375	37.955	38.24	85200.0
2011-03-29	BRF	ETF	53.26	54.03	53.112	54.02	412191.0
2011-03-29	BSCE	ETF	20.91	20.91	20.854	20.884	12658.0
2011-03-29	BSV	ETF	80.25	80.26	80.16	80.21	815700.0
2011-03-29	BTF	ETF	83.94999999999999	84.7	83.8	84.49999999999999	2219.8
2011-03-29	BWX	ETF	29.93	29.97	29.85	29.93	222032.0

> showing 50 of 831 rows — these rows as CSV

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