PREVIEW / etf_daily / 2011-02-23

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-23.parquet
  size:    35 KB
  rows:    828

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-23	SPY	ETF	131.75	132.07	130.21	131.02	227584000.0
2011-02-23	QQQ	ETF	57.0	57.23	56.13	56.56	97842850.0
2011-02-23	IWM	ETF	81.37	81.44	79.29	79.81	91258600.0
2011-02-23	DIA	ETF	121.67	121.77	120.36	120.85	14461100.0
2011-02-23	GLD	ETF	136.97	138.2	136.92	137.51	15685700.0
2011-02-23	TLT	ETF	91.1	91.55	90.74	91.16	14522600.0
2011-02-23	AADR	ETF	30.25	30.25	29.95	30.01	3400.0
2011-02-23	AAXJ	ETF	59.75	59.78	58.96	59.46	555300.0
2011-02-23	ACWI	ETF	48.05	48.14	47.47	47.76	189900.0
2011-02-23	ACWX	ETF	44.79	44.908	44.35	44.64	147270.0
2011-02-23	ADRE	ETF	46.26	46.55	45.85	46.3	88103.0
2011-02-23	AFK	ETF	32.6	32.99	32.37	32.55	47605.0
2011-02-23	AGG	ETF	105.2	105.29	105.04	105.15	707000.0
2011-02-23	AGQ	ETF	357.1	370.7	356.46	365.08	760300.0
2011-02-23	AGZ	ETF	108.95	109.0999	108.8	108.81	23937.0
2011-02-23	AIA	ETF	45.17	45.38	44.83	45.05	106028.0
2011-02-23	AIQ	ETF	20.75	21.125	20.3	20.7	14175.0
2011-02-23	AIS	ETF	1.6	1.63	1.55	1.55	419474.0
2011-02-23	AIVI	ETF	45.73	45.87	45.33	45.76	35000.0
2011-02-23	AMJ	ETF	38.19	38.38	37.72	37.91	1116208.0
2011-02-23	AMLP	ETF	81.65	82.15	81.25	81.55	103440.0
2011-02-23	AOA	ETF	35.51	35.52	35.0	35.24	17300.0
2011-02-23	AOK	ETF	29.0	29.02	28.95	28.98	19258.0
2011-02-23	AOM	ETF	30.33	30.3699	30.2	30.2601	13984.0
2011-02-23	AOR	ETF	32.29	32.31	32.05	32.14	48657.0
2011-02-23	ARB	ETF	41.64	41.66	39.86	39.91	157719.0
2011-02-23	ASEA	ETF	14.97	14.97	14.78	14.86	15100.0
2011-02-23	BAB	ETF	25.03	25.12	24.95	25.028	167356.0
2011-02-23	BAL	ETF	94.05	96.4	92.8324	96.05	123182.0
2011-02-23	BALT	ETF	9.0	9.24	8.67	9.14	273325.0
2011-02-23	BBH	ETF	33.4067	33.4967	33.0833	33.0833	79800.0
2011-02-23	BIB	ETF	7.5038	7.5038	7.3925	7.3925	1600.0
2011-02-23	BICK	ETF	30.99	30.99	30.21	30.51	87703.0
2011-02-23	BIL	ETF	91.72	91.72	91.7	91.72	493500.0
2011-02-23	BIS	ETF	8012.8	8160.0	8011.2	8160.0	69.0
2011-02-23	BITS	ETF	27.6	27.6	26.88	27.0	2760.0
2011-02-23	BIV	ETF	82.55	82.62	82.28	82.3	90300.0
2011-02-23	BJK	ETF	31.43	31.59	30.81	31.26	54400.0
2011-02-23	BKF	ETF	46.75	47.085	46.31	46.8	175779.0
2011-02-23	BLV	ETF	77.92	78.07	77.58	77.77	52200.0
2011-02-23	BMVP	ETF	15.52	15.5267	15.33	15.4133	14476.0
2011-02-23	BND	ETF	80.02	80.11	79.91	79.94	638700.0
2011-02-23	BNO	ETF	36.165	37.245	36.13	37.175	398800.0
2011-02-23	BRF	ETF	51.89	52.16	51.121	51.52	299872.0
2011-02-23	BSCE	ETF	20.92	20.92	20.8201	20.87	8658.0
2011-02-23	BSV	ETF	80.38	80.4	80.31	80.33	339100.0
2011-02-23	BTF	ETF	86.3	87.24999999999999	85.0	85.0	11957.0
2011-02-23	BWX	ETF	29.37	29.525	29.37	29.48	191530.0
2011-02-23	BWZ	ETF	37.71	37.75	37.6	37.6	6378.0
2011-02-23	BZQ	ETF	2689.6	2708.8	2601.6	2633.6	1636.0

> showing 50 of 828 rows — these rows as CSV

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