PREVIEW / etf_daily / 2010-11-16

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-16.parquet
  size:    35 KB
  rows:    807

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
2010-11-16	SPY	ETF	119.29	119.49	117.59	118.16	299566200.0
2010-11-16	QQQ	ETF	51.93	52.2462	50.85	51.45	101096620.0
2010-11-16	IWM	ETF	71.5	71.68	70.15	70.64	69965600.0
2010-11-16	DIA	ETF	111.59	111.74	110.07	110.5	9492400.0
2010-11-16	GLD	ETF	132.24	132.38	129.83	130.97	32478100.0
2010-11-16	TLT	ETF	94.91	96.25	93.99	96.14	19901300.0
2010-11-16	AAXJ	ETF	62.64	62.64	61.4	61.58	742600.0
2010-11-16	ACWI	ETF	44.96	44.98	44.21	44.38	449000.0
2010-11-16	ACWX	ETF	42.86	42.86	42.1	42.28	387059.0
2010-11-16	ADRE	ETF	46.06	46.06	45.0	45.19	113007.0
2010-11-16	AFK	ETF	33.71	33.71	33.03	33.2	20523.0
2010-11-16	AGG	ETF	107.01	107.21	106.68	107.18	1459500.0
2010-11-16	AGQ	ETF	221.26	223.9	213.22	221.62	1307650.0
2010-11-16	AGZ	ETF	110.63	110.88	109.95	110.73	29651.0
2010-11-16	AIA	ETF	45.0	45.0	44.08	44.23	32804.0
2010-11-16	AIQ	ETF	20.2	20.45	19.65	19.8	58343.0
2010-11-16	AIS	ETF	1.5	1.5	1.445	1.45	293276.0
2010-11-16	AIVI	ETF	44.31	44.34	43.37	43.67	26900.0
2010-11-16	AMJ	ETF	36.55	36.72	35.4704	35.88	1223529.0
2010-11-16	AMLP	ETF	80.2	80.2	78.5	78.95	129720.0
2010-11-16	AOA	ETF	32.76	32.81	32.26	32.33	15500.0
2010-11-16	AOK	ETF	28.51	28.51	28.38	28.406	5458.0
2010-11-16	AOM	ETF	29.5	29.5	29.26	29.324	7433.0
2010-11-16	AOR	ETF	30.63	30.6301	30.33	30.42	12751.0
2010-11-16	ARB	ETF	25.73	26.05	25.68	25.89	292003.0
2010-11-16	BAB	ETF	25.31	25.39	24.88	25.1805	476530.0
2010-11-16	BAL	ETF	66.89	66.9	64.5	65.38	79786.0
2010-11-16	BALT	ETF	12.2	12.23	11.74	11.95	234736.0
2010-11-16	BBH	ETF	32.9167	33.0167	32.3333	32.74	117300.0
2010-11-16	BICK	ETF	32.45	32.45	31.71	31.7401	26839.0
2010-11-16	BIL	ETF	91.7	91.72	91.7	91.72	103450.0
2010-11-16	BIS	ETF	9552.0	9552.0	9552.0	9552.0	1.56
2010-11-16	BITS	ETF	28.08	28.6	27.8	28.0	2763.0
2010-11-16	BIV	ETF	85.32	85.39	84.8	85.36	274900.0
2010-11-16	BJK	ETF	31.42	31.42	30.46	30.64	26400.0
2010-11-16	BKF	ETF	48.85	48.92	47.64	47.73	583097.0
2010-11-16	BLV	ETF	80.14	80.94	79.51	80.87	58500.0
2010-11-16	BMVP	ETF	13.95	13.96	13.77	13.81	12436.0
2010-11-16	BND	ETF	81.53	81.72	81.26	81.72	1044200.0
2010-11-16	BNE	ETF	11.4	11.43	11.37	11.37	147053.0
2010-11-16	BRF	ETF	58.98	59.0	57.1	57.61	778204.0
2010-11-16	BSCE	ETF	20.85	20.9	20.8284	20.852	15042.0
2010-11-16	BSV	ETF	81.34	81.41	81.24	81.41	575200.0
2010-11-16	BTF	ETF	77.6	78.1585	77.1	77.5	4095.4
2010-11-16	BWX	ETF	29.7	29.71	29.27	29.395	380548.0
2010-11-16	BWZ	ETF	37.15	37.15	36.611	36.7	10800.0
2010-11-16	BZQ	ETF	2753.6	2876.8	2740.8	2816.0	1867.0
2010-11-16	CEF	ETF	18.06	18.06	17.56	17.81	2294000.0
2010-11-16	CEW	ETF	22.94	22.982	22.8	22.83	118082.0
2010-11-16	CGO	ETF	14.68	14.69	14.1	14.19	31046.0

> showing 50 of 807 rows — these rows as CSV

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