PREVIEW / etf_daily / 2011-03-08

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-08.parquet
  size:    35 KB
  rows:    831

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-03-08	SPY	ETF	131.64	133.0	131.07	132.58	174615000.0
2011-03-08	QQQ	ETF	57.1	57.68	56.77	57.42	62399099.0
2011-03-08	IWM	ETF	81.16	82.81	80.55	82.41	67755300.0
2011-03-08	DIA	ETF	120.87	122.39	120.58	121.99	8009200.0
2011-03-08	GLD	ETF	139.65	139.66	138.83	139.36	10730500.0
2011-03-08	TLT	ETF	90.11	90.34	89.65	89.68	8498700.0
2011-03-08	AADR	ETF	30.37	30.65	30.35	30.63	11900.0
2011-03-08	AAXJ	ETF	61.51	62.38	61.37	62.14	384100.0
2011-03-08	ACWI	ETF	48.18	48.68	48.02	48.6	281700.0
2011-03-08	ACWX	ETF	45.3	45.64	45.08	45.52	86011.0
2011-03-08	ADRE	ETF	47.24	47.57	46.9	47.3	66444.0
2011-03-08	AFK	ETF	32.71	33.31	32.5	32.55	189332.0
2011-03-08	AGG	ETF	104.95	105.07	104.9	104.99	527200.0
2011-03-08	AGQ	ETF	421.52	421.6	409.0	418.7	550750.0
2011-03-08	AGZ	ETF	109.35	109.35	108.94	108.95	17114.0
2011-03-08	AIA	ETF	46.47	46.96	46.29	46.86	28756.0
2011-03-08	AIQ	ETF	20.3	20.9	20.1	20.75	35486.0
2011-03-08	AIS	ETF	1.57	1.69	1.54	1.67	563310.0
2011-03-08	AIVI	ETF	46.02	46.49	46.02	46.32	7500.0
2011-03-08	AMJ	ETF	37.79	38.04	37.5201	37.67	743447.0
2011-03-08	AMLP	ETF	82.25	82.25	81.5	81.8	294800.0
2011-03-08	AOA	ETF	35.55	35.89	35.49	35.88	15600.0
2011-03-08	AOK	ETF	29.0	29.16	29.0	29.16	23555.0
2011-03-08	AOM	ETF	30.41	30.57	30.3925	30.5201	75292.0
2011-03-08	AOR	ETF	32.36	32.5699	32.31	32.48	23796.0
2011-03-08	ARB	ETF	40.12	40.3	39.22	39.89	166280.0
2011-03-08	ARGT	ETF	30.34	30.54	30.34	30.48	4650.0
2011-03-08	ASEA	ETF	15.48	15.6	15.48	15.56	1000.0
2011-03-08	BAB	ETF	25.05	25.098	25.01	25.04	151955.0
2011-03-08	BAL	ETF	109.31	110.2488	104.84	106.23	120086.0
2011-03-08	BALT	ETF	9.06	9.22	8.96	9.0	169298.0
2011-03-08	BBH	ETF	34.4133	34.7567	34.4133	34.69	59100.0
2011-03-08	BIB	ETF	7.7075	7.735	7.7075	7.735	1600.0
2011-03-08	BICK	ETF	31.67	32.09	31.67	31.922	61957.0
2011-03-08	BIL	ETF	91.72	91.72	91.7	91.7	1178800.0
2011-03-08	BIS	ETF	7612.8	7612.8	7521.6	7521.6	5.0
2011-03-08	BITS	ETF	26.2	26.2	25.68	26.12	2650.0
2011-03-08	BIV	ETF	82.03	82.18	81.89	82.0	125400.0
2011-03-08	BJK	ETF	31.3	31.67	31.3	31.63	21600.0
2011-03-08	BKF	ETF	48.5	49.15	48.331	49.06	566100.0
2011-03-08	BKLN	ETF	25.05	25.07	25.01	25.01	178600.0
2011-03-08	BLV	ETF	77.31	77.52	77.16	77.24	15400.0
2011-03-08	BMVP	ETF	15.4	15.53	15.32	15.5	6652.0
2011-03-08	BND	ETF	79.85	79.89	79.76	79.81	499600.0
2011-03-08	BNO	ETF	37.8	37.805	37.35	37.505	215800.0
2011-03-08	BRF	ETF	52.36	52.76	51.7024	52.52	273997.0
2011-03-08	BSCE	ETF	20.83	20.91	20.83	20.91	18647.0
2011-03-08	BSV	ETF	80.26	80.28	80.19	80.25	382000.0
2011-03-08	BTF	ETF	84.60000000000001	85.0	83.6495	84.3875	14801.800000000001
2011-03-08	BWX	ETF	29.615	29.643	29.4788	29.52	238026.0

> showing 50 of 831 rows — these rows as CSV

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