PREVIEW / etf_daily / 2011-02-04

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-04.parquet
  size:    35 KB
  rows:    826

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-02-04	SPY	ETF	130.83	131.2	130.23	131.15	134634800.0
2011-02-04	QQQ	ETF	57.05	57.42	56.9	57.375	47647712.0
2011-02-04	IWM	ETF	79.6	79.97	79.24	79.87	39532700.0
2011-02-04	DIA	ETF	120.37	120.69	120.02	120.69	5191300.0
2011-02-04	GLD	ETF	131.84	132.7	131.23	131.66	15214300.0
2011-02-04	TLT	ETF	89.5	89.65	88.77	88.81	17172200.0
2011-02-04	AADR	ETF	30.25	30.35	30.19	30.35	700.0
2011-02-04	AAXJ	ETF	62.68	62.77	62.2	62.66	516800.0
2011-02-04	ACWI	ETF	48.29	48.29	47.99	48.21	285100.0
2011-02-04	ACWX	ETF	45.29	45.319	45.0	45.319	28507.0
2011-02-04	ADRE	ETF	47.09	47.11	46.64	46.87	67820.0
2011-02-04	AFK	ETF	33.59	33.76	33.21	33.74	43385.0
2011-02-04	AGG	ETF	104.47	104.63	104.2	104.26	1116600.0
2011-02-04	AGQ	ETF	274.9	280.94	270.58	276.4	478800.0
2011-02-04	AGZ	ETF	109.17	109.17	108.8901	109.07	12224.0
2011-02-04	AIA	ETF	48.13	48.46	48.07	48.46	23957.0
2011-02-04	AIQ	ETF	21.6	21.6	21.05	21.3	7348.0
2011-02-04	AIS	ETF	1.65	1.65	1.6	1.62	243993.0
2011-02-04	AIVI	ETF	46.0	46.22	46.0	46.19	2600.0
2011-02-04	AMJ	ETF	37.83	38.0	37.58	37.68	570590.0
2011-02-04	AMLP	ETF	82.1	82.1	81.7	81.95	118100.0
2011-02-04	AOA	ETF	35.26	35.31	35.12	35.31	5400.0
2011-02-04	AOK	ETF	28.88	28.89	28.836	28.89	5934.0
2011-02-04	AOM	ETF	30.22	30.25	30.16	30.2142	18282.0
2011-02-04	AOR	ETF	32.074	32.12	32.01	32.12	16638.0
2011-02-04	ARB	ETF	44.0	44.33	43.67	43.99	134229.0
2011-02-04	BAB	ETF	24.74	24.78	24.6	24.6	250135.0
2011-02-04	BAL	ETF	85.39	86.64	83.61	84.05	94696.0
2011-02-04	BALT	ETF	8.87	8.98	8.75	8.91	209824.0
2011-02-04	BBH	ETF	33.7833	33.94	33.6633	33.94	101400.0
2011-02-04	BIB	ETF	7.62	7.627	7.5875	7.5875	6400.0
2011-02-04	BICK	ETF	31.98	31.98	31.351	31.611	28559.0
2011-02-04	BIL	ETF	91.7	91.72	91.7	91.72	101000.0
2011-02-04	BITS	ETF	27.96	28.2	27.92	28.08	588.0
2011-02-04	BIV	ETF	81.79	81.84	81.39	81.58	321000.0
2011-02-04	BJK	ETF	33.03	33.03	32.55	32.78	52000.0
2011-02-04	BKF	ETF	47.83	47.846	47.17	47.5	199657.0
2011-02-04	BLV	ETF	76.74	76.81	76.27	76.39	50700.0
2011-02-04	BMVP	ETF	15.27	15.28	15.17	15.22	21318.0
2011-02-04	BND	ETF	79.52	79.58	79.28	79.33	988600.0
2011-02-04	BNO	ETF	34.095	34.105	33.285	33.32	43400.0
2011-02-04	BRF	ETF	51.72	52.0	50.8	51.02	611400.0
2011-02-04	BSCE	ETF	20.8	20.8	20.68	20.75	34142.0
2011-02-04	BSV	ETF	80.18	80.19	80.05	80.06	645400.0
2011-02-04	BTF	ETF	82.55	83.2	82.5	82.94999999999999	19197.4
2011-02-04	BWX	ETF	29.415	29.445	29.275	29.365	2550654.0
2011-02-04	BWZ	ETF	37.53	37.53	37.36	37.47	25224.0
2011-02-04	BZQ	ETF	2697.6	2792.0	2692.8	2742.4	604.0
2011-02-04	CEF	ETF	19.4	19.65	19.34	19.38	879500.0
2011-02-04	CEW	ETF	22.38	22.44	22.32	22.4	62193.0

> showing 50 of 826 rows — these rows as CSV

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