PREVIEW / etf_daily / 2011-02-22

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-22.parquet
  size:    35 KB
  rows:    832

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-22	SPY	ETF	133.12	134.56	131.47	131.83	233116400.0
2011-02-22	QQQ	ETF	58.0	58.13	56.94	57.03	92596867.0
2011-02-22	IWM	ETF	82.73	83.02	81.09	81.21	68370300.0
2011-02-22	DIA	ETF	122.87	123.28	121.49	121.89	9844300.0
2011-02-22	GLD	ETF	136.92	137.22	136.19	136.29	16676100.0
2011-02-22	TLT	ETF	89.91	90.94	89.71	90.83	11905700.0
2011-02-22	AADR	ETF	30.69	30.69	30.1	30.1	14200.0
2011-02-22	AAXJ	ETF	60.27	60.5	59.23	59.57	1762200.0
2011-02-22	ACWI	ETF	48.36	48.7	47.82	47.92	912600.0
2011-02-22	ACWX	ETF	45.1	45.36	44.51	44.56	205465.0
2011-02-22	ADRE	ETF	46.51	46.94	46.05	46.06	100347.0
2011-02-22	AFK	ETF	33.8	33.8	32.13	32.17	182286.0
2011-02-22	AGG	ETF	104.81	105.14	104.8	105.07	1033400.0
2011-02-22	AGQ	ETF	360.44	363.42	346.52	354.52	766000.0
2011-02-22	AGZ	ETF	108.64	109.0284	108.64	108.88	17324.0
2011-02-22	AIA	ETF	45.84	45.95	45.01	45.37	104579.0
2011-02-22	AIQ	ETF	21.5	21.5	20.7	20.7	17044.0
2011-02-22	AIS	ETF	1.64	1.64	1.6	1.6	499564.0
2011-02-22	AIVI	ETF	46.04	46.1	45.36	45.59	11400.0
2011-02-22	AMJ	ETF	38.42	38.44	37.938	38.09	1372925.0
2011-02-22	AMLP	ETF	81.95	82.15	81.4	81.55	149200.0
2011-02-22	AOA	ETF	35.78	35.95	35.41	35.44	18300.0
2011-02-22	AOK	ETF	29.06	29.11	29.0	29.025	24265.0
2011-02-22	AOM	ETF	30.4	30.51	30.33	30.35	11678.0
2011-02-22	AOR	ETF	32.49	32.54	32.2023	32.2356	24440.0
2011-02-22	ARB	ETF	43.02	43.16	41.45	41.56	141049.0
2011-02-22	ASEA	ETF	15.13	15.15	14.89	14.92	12300.0
2011-02-22	BAB	ETF	24.9	24.98	24.83	24.958	197720.0
2011-02-22	BAL	ETF	95.51	95.99	93.73	94.5	145891.0
2011-02-22	BALT	ETF	9.41	9.41	8.83	9.04	285892.0
2011-02-22	BBH	ETF	33.6367	33.74	33.3933	33.4467	28800.0
2011-02-22	BIB	ETF	7.9363	7.9363	6.9463	7.4863	14752.0
2011-02-22	BICK	ETF	30.93	31.1699	30.64	30.66	54902.0
2011-02-22	BIL	ETF	91.72	91.72	91.7	91.7	144050.0
2011-02-22	BIS	ETF	7998.4	8011.2	7998.4	8011.2	31.25
2011-02-22	BITS	ETF	27.24	27.64	27.16	27.56	2978.0
2011-02-22	BIV	ETF	82.0	82.51	81.99	82.51	152100.0
2011-02-22	BJK	ETF	32.1	32.2	31.52	31.55	16700.0
2011-02-22	BKF	ETF	47.13	47.519	46.55	46.68	248197.0
2011-02-22	BLV	ETF	77.23	77.81	77.15	77.78	34900.0
2011-02-22	BMVP	ETF	15.7	15.7533	15.5085	15.5236	12754.0
2011-02-22	BND	ETF	79.73	79.98	79.72	79.95	1618800.0
2011-02-22	BNO	ETF	35.675	35.675	35.135	35.315	195000.0
2011-02-22	BRF	ETF	52.79	52.83	51.64	51.86	267204.0
2011-02-22	BSCE	ETF	20.8	20.91	20.8	20.84	47185.0
2011-02-22	BSV	ETF	80.21	80.37	80.2	80.35	880600.0
2011-02-22	BTF	ETF	86.8	87.05	84.6125	86.69999999999999	29246.800000000003
2011-02-22	BWX	ETF	29.355	29.48	29.27	29.48	438742.0
2011-02-22	BWZ	ETF	37.6	37.63	37.15	37.2904	499647.0
2011-02-22	BZQ	ETF	2632.0	2686.4	2568.0	2683.2	1622.5

> showing 50 of 832 rows — these rows as CSV

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