PREVIEW / etf_daily / 2011-02-11

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-11.parquet
  size:    35 KB
  rows:    822

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-11	SPY	ETF	131.8	133.28	131.77	133.11	137710300.0
2011-02-11	QQQ	ETF	57.87	58.48	57.77	58.44	47853473.0
2011-02-11	IWM	ETF	80.89	82.1	80.79	82.07	38579100.0
2011-02-11	DIA	ETF	121.82	122.76	121.71	122.65	6887200.0
2011-02-11	GLD	ETF	133.01	133.44	132.09	132.32	9888600.0
2011-02-11	TLT	ETF	89.03	89.53	88.74	89.46	11333400.0
2011-02-11	AADR	ETF	30.27	30.27	30.27	30.27	100.0
2011-02-11	AAXJ	ETF	59.73	60.56	59.53	60.44	3228800.0
2011-02-11	ACWI	ETF	48.1	48.53	47.9	48.44	110100.0
2011-02-11	ACWX	ETF	44.6	45.1104	44.6	45.03	40756.0
2011-02-11	ADRE	ETF	45.56	46.35	45.56	46.29	66529.0
2011-02-11	AFK	ETF	33.37	33.69	33.2518	33.69	135043.0
2011-02-11	AGG	ETF	104.31	104.36	104.07	104.3	797200.0
2011-02-11	AGQ	ETF	296.1	298.56	288.04	292.22	453450.0
2011-02-11	AGZ	ETF	108.62	108.85	108.62	108.7	28837.0
2011-02-11	AIA	ETF	45.67	46.18	45.54	46.04	28572.0
2011-02-11	AIQ	ETF	20.6	21.3	20.455	21.3	12864.0
2011-02-11	AIS	ETF	1.77	1.8	1.72	1.8	935661.0
2011-02-11	AIVI	ETF	45.69	46.15	45.69	46.15	29900.0
2011-02-11	AMJ	ETF	37.49	37.49	37.31	37.41	512234.0
2011-02-11	AMLP	ETF	80.0	80.4	79.9	80.4	67620.0
2011-02-11	AOA	ETF	35.43	35.8	35.43	35.77	10400.0
2011-02-11	AOK	ETF	28.91	28.95	28.9	28.9499	4191.0
2011-02-11	AOM	ETF	30.19	30.36	30.19	30.359	15607.0
2011-02-11	AOR	ETF	32.11	32.36	32.11	32.359	18480.0
2011-02-11	ARB	ETF	44.0	44.16	43.6	44.16	154685.0
2011-02-11	BAB	ETF	24.72	24.8	24.69	24.74	652037.0
2011-02-11	BAL	ETF	97.44	98.16	95.4	96.21	221583.0
2011-02-11	BALT	ETF	8.76	8.94	8.76	8.88	137562.0
2011-02-11	BBH	ETF	33.56	33.6067	33.4733	33.58	13800.0
2011-02-11	BIB	ETF	7.5237	7.5745	7.5237	7.5745	4080.0
2011-02-11	BICK	ETF	30.49	30.97	30.3	30.9258	39369.0
2011-02-11	BIL	ETF	91.72	91.72	91.7	91.7	138150.0
2011-02-11	BITS	ETF	27.4	27.6	27.0	27.28	1825.0
2011-02-11	BIV	ETF	81.37	81.63	81.24	81.36	271500.0
2011-02-11	BJK	ETF	32.08	32.42	31.98	32.3	215200.0
2011-02-11	BKF	ETF	46.0	47.33	46.0	47.0	181504.0
2011-02-11	BLV	ETF	76.45	76.8	76.35	76.8	41800.0
2011-02-11	BMVP	ETF	15.34	15.5	15.34	15.47	7544.0
2011-02-11	BND	ETF	79.3	79.41	79.2	79.3	769000.0
2011-02-11	BNO	ETF	33.985	34.005	33.485	33.595	40200.0
2011-02-11	BRF	ETF	50.36	51.78	50.36	51.53	340216.0
2011-02-11	BSCE	ETF	20.74	20.75	20.6851	20.74	19941.0
2011-02-11	BSV	ETF	80.01	80.05	79.92	79.95	899700.0
2011-02-11	BTF	ETF	83.8	84.94999999999999	83.8	84.94999999999999	12455.6
2011-02-11	BWX	ETF	28.73	28.9249	28.73	28.865	1003284.0
2011-02-11	BWZ	ETF	37.39	37.4299	37.06	37.393	7910.0
2011-02-11	BZQ	ETF	2854.4	2884.8	2723.2	2739.2	804.0
2011-02-11	CEF	ETF	19.93	20.0	19.75	19.75	891600.0
2011-02-11	CEW	ETF	22.3	22.36	22.28	22.34	194040.0

> showing 50 of 822 rows — these rows as CSV

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