PREVIEW / etf_daily / 2011-05-25

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-25.parquet
  size:    36 KB
  rows:    848

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-05-25	SPY	ETF	131.42	132.94	131.38	132.39	151050100.0
2011-05-25	QQQ	ETF	56.49	57.06	56.47	56.79	41368976.0
2011-05-25	IWM	ETF	80.77	82.29	80.76	82.0	60009900.0
2011-05-25	DIA	ETF	122.84	124.13	122.8	123.65	4110900.0
2011-05-25	GLD	ETF	148.72	149.37	148.52	148.58	10973800.0
2011-05-25	TLT	ETF	96.15	96.28	95.54	95.69	5664500.0
2011-05-25	AADR	ETF	30.76	30.98	30.76	30.98	900.0
2011-05-25	AAXJ	ETF	61.41	61.72	61.24	61.5	435400.0
2011-05-25	ACTV	ETF	15.0	17.11	14.75	15.9	7605400.0
2011-05-25	ACWI	ETF	47.84	48.27	47.76	48.09	238000.0
2011-05-25	ACWX	ETF	44.28	44.826	44.28	44.66	69013.0
2011-05-25	ADRE	ETF	45.33	45.6	45.241	45.41	40415.0
2011-05-25	AFK	ETF	32.23	32.3801	32.23	32.37	2605.0
2011-05-25	AGG	ETF	107.1	107.24	107.06	107.1	543400.0
2011-05-25	AGQ	ETF	388.92	403.28	386.1	400.36	1621700.0
2011-05-25	AGZ	ETF	110.41	110.5	110.35	110.39	7332.0
2011-05-25	AIA	ETF	46.67	46.94	46.57	46.91	24382.0
2011-05-25	AIQ	ETF	20.5	21.05	20.5	20.85	12496.0
2011-05-25	AIS	ETF	1.82	1.83	1.75	1.77	1012487.0
2011-05-25	AIVI	ETF	46.79	47.33	46.79	47.3	80000.0
2011-05-25	AMJ	ETF	36.2	36.58	36.12	36.53	333065.0
2011-05-25	AMLP	ETF	79.25	79.5	79.05	79.35	174620.0
2011-05-25	AOA	ETF	35.57	35.92	35.57	35.83	11800.0
2011-05-25	AOK	ETF	29.3456	29.4	29.3401	29.4	2714.0
2011-05-25	AOM	ETF	30.63	30.72	30.63	30.72	8368.0
2011-05-25	AOR	ETF	32.43	32.6896	32.43	32.63	10911.0
2011-05-25	ARB	ETF	40.51	42.11	40.29	41.98	114279.0
2011-05-25	ARGT	ETF	28.9	29.24	28.9	29.2	11150.0
2011-05-25	ASEA	ETF	16.17	16.18	16.1	16.15	4800.0
2011-05-25	BAB	ETF	26.5	26.5	26.38	26.41	150890.0
2011-05-25	BAL	ETF	85.8	88.41	85.62	86.11	74977.0
2011-05-25	BALT	ETF	6.27	6.49	6.1801	6.29	373924.0
2011-05-25	BBH	ETF	34.7833	34.8633	34.6867	34.7533	55500.0
2011-05-25	BCM	ETF	47.2	47.2	47.2	47.2	356.0
2011-05-25	BIB	ETF	9.57	9.7325	9.4375	9.6888	55944.0
2011-05-25	BICK	ETF	31.6	31.73	31.6	31.73	2105.0
2011-05-25	BIL	ETF	91.72	91.72	91.7	91.72	159800.0
2011-05-25	BITS	ETF	22.36	27.4	21.8804	23.92	23949.0
2011-05-25	BIV	ETF	84.33	84.33	84.08	84.21	153800.0
2011-05-25	BJK	ETF	33.4	33.89	33.4	33.85	3600.0
2011-05-25	BKF	ETF	46.71	47.1971	46.68	46.9399	69716.0
2011-05-25	BKLN	ETF	25.11	25.12	25.06	25.09	210200.0
2011-05-25	BLV	ETF	81.72	81.83	81.31	81.43	32100.0
2011-05-25	BMVP	ETF	15.5	15.71	15.5	15.66	3559.0
2011-05-25	BND	ETF	81.49	81.52	81.38	81.45	486300.0
2011-05-25	BNO	ETF	37.435	38.265	37.425	38.225	83200.0
2011-05-25	BRF	ETF	54.73	54.94	54.5799	54.88	120905.0
2011-05-25	BSCE	ETF	21.12	21.15	21.12	21.15	13707.0
2011-05-25	BSV	ETF	80.96	80.99	80.92	80.98	455000.0
2011-05-25	BTF	ETF	83.39999999999999	83.69999999999999	83.3	83.49999999999999	1945.2

> showing 50 of 848 rows — these rows as CSV

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