PREVIEW / etf_daily / 2011-02-28

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-28.parquet
  size:    35 KB
  rows:    830

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-28	SPY	ETF	132.82	133.32	132.38	133.15	141585500.0
2011-02-28	QQQ	ETF	57.87	58.05	57.43	57.7689	51402735.0
2011-02-28	IWM	ETF	82.65	82.84	81.59	82.27	49869300.0
2011-02-28	DIA	ETF	121.5	122.18	121.44	122.15	5759600.0
2011-02-28	GLD	ETF	137.65	138.14	137.03	137.66	8847000.0
2011-02-28	TLT	ETF	92.3	92.52	92.08	92.4	9682500.0
2011-02-28	AADR	ETF	30.53	30.53	30.48	30.5	2100.0
2011-02-28	AAXJ	ETF	60.08	60.27	59.83	60.13	356700.0
2011-02-28	ACWI	ETF	48.61	48.93	48.6	48.78	731100.0
2011-02-28	ACWX	ETF	45.61	45.849	45.455	45.72	245540.0
2011-02-28	ADRE	ETF	46.63	46.8501	46.57	46.83	30455.0
2011-02-28	AFK	ETF	33.04	33.21	32.91	32.92	16068.0
2011-02-28	AGG	ETF	105.53	105.65	105.46	105.65	558200.0
2011-02-28	AGQ	ETF	363.66	374.64	360.36	372.52	964700.0
2011-02-28	AGZ	ETF	109.35	109.45	109.1401	109.44	25064.0
2011-02-28	AIA	ETF	45.83	45.84	45.521	45.74	61774.0
2011-02-28	AIQ	ETF	20.85	21.15	20.6	20.7	10987.0
2011-02-28	AIS	ETF	1.61	1.61	1.53	1.56	422998.0
2011-02-28	AIVI	ETF	46.64	46.86	46.48	46.71	16700.0
2011-02-28	AMJ	ETF	38.21	38.27	38.03	38.27	877281.0
2011-02-28	AMLP	ETF	82.6	82.65	82.3	82.65	135200.0
2011-02-28	AOA	ETF	35.92	35.95	35.77	35.86	10800.0
2011-02-28	AOK	ETF	29.2	29.2099	29.13	29.1544	12333.0
2011-02-28	AOM	ETF	30.58	30.61	30.48	30.52	16495.0
2011-02-28	AOR	ETF	32.547	32.5756	32.4578	32.5	6234.0
2011-02-28	ARB	ETF	40.28	40.29	39.58	39.81	157404.0
2011-02-28	ASEA	ETF	15.28	15.28	15.04	15.04	14800.0
2011-02-28	BAB	ETF	25.23	25.2799	25.2	25.276	134961.0
2011-02-28	BAL	ETF	101.96	103.34	100.27	102.9899	150213.0
2011-02-28	BALT	ETF	9.43	9.52	9.35	9.47	163752.0
2011-02-28	BBH	ETF	33.8133	33.9567	33.67	33.67	9000.0
2011-02-28	BICK	ETF	30.79	31.0	30.68	30.8344	123930.0
2011-02-28	BIL	ETF	91.72	91.72	91.7	91.7	145850.0
2011-02-28	BIS	ETF	7907.2	7907.2	7865.6	7865.6	1.56
2011-02-28	BITS	ETF	27.2	27.28	25.92	26.68	32615.0
2011-02-28	BIV	ETF	82.77	82.79	82.66	82.78	87500.0
2011-02-28	BJK	ETF	31.77	31.95	31.69	31.83	14500.0
2011-02-28	BKF	ETF	47.65	48.21	47.58	48.2	380777.0
2011-02-28	BLV	ETF	78.75	78.91	78.63	78.82	9900.0
2011-02-28	BMVP	ETF	15.63	15.65	15.55	15.58	9297.0
2011-02-28	BND	ETF	80.24	80.35	80.2	80.35	1833400.0
2011-02-28	BNO	ETF	37.315	37.525	36.165	37.16	213000.0
2011-02-28	BRF	ETF	52.54	52.89	51.79	52.28	247006.0
2011-02-28	BSCE	ETF	20.89	20.96	20.89	20.96	39801.0
2011-02-28	BSV	ETF	80.42	80.48	80.4	80.43	462200.0
2011-02-28	BTF	ETF	86.19999999999999	87.05	85.55	86.65050000000001	8247.2
2011-02-28	BWX	ETF	29.705	29.705	29.58	29.665	329276.0
2011-02-28	BWZ	ETF	38.05	38.05	37.6	37.944	45479.0
2011-02-28	BZQ	ETF	2563.2	2598.4	2524.8	2556.8	351.0
2011-02-28	CEF	ETF	21.4	21.63	21.27	21.44	1289300.0

> showing 50 of 830 rows — these rows as CSV

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