PREVIEW / etf_daily / 2010-11-18

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-18.parquet
  size:    35 KB
  rows:    808

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-18	SPY	ETF	119.36	120.39	119.35	119.96	197723700.0
2010-11-18	QQQ	ETF	52.15	52.79	52.13	52.43	71488268.0
2010-11-18	IWM	ETF	71.67	72.58	71.66	72.21	52638700.0
2010-11-18	DIA	ETF	111.36	112.37	111.35	112.15	7154500.0
2010-11-18	GLD	ETF	131.82	132.78	131.55	132.09	16009400.0
2010-11-18	TLT	ETF	95.68	96.0	94.8	96.0	12424800.0
2010-11-18	AADR	ETF	28.53	28.53	28.53	28.53	100.0
2010-11-18	AAXJ	ETF	62.52	62.93	62.45	62.68	225200.0
2010-11-18	ACWI	ETF	45.27	45.52	45.21	45.46	89000.0
2010-11-18	ACWX	ETF	43.29	43.48	43.26	43.43	52978.0
2010-11-18	ADRE	ETF	46.15	46.5	46.09	46.37	49182.0
2010-11-18	AFK	ETF	33.87	34.03	33.63	33.9517	37354.0
2010-11-18	AGG	ETF	107.08	107.2	106.93	107.18	916100.0
2010-11-18	AGQ	ETF	237.92	248.84	236.24	246.72	592550.0
2010-11-18	AGZ	ETF	110.6415	110.782	110.55	110.718	5348.0
2010-11-18	AIA	ETF	45.28	45.4	45.1666	45.2495	20003.0
2010-11-18	AIQ	ETF	20.2	20.65	20.15	20.55	17127.0
2010-11-18	AIS	ETF	1.43	1.4301	1.39	1.41	251588.0
2010-11-18	AIVI	ETF	44.58	44.79	44.52	44.77	32800.0
2010-11-18	AMJ	ETF	36.31	36.31	36.064	36.15	593454.0
2010-11-18	AMLP	ETF	79.6	79.6	79.15	79.25	72680.0
2010-11-18	AOA	ETF	32.94	33.12	32.94	33.02	16900.0
2010-11-18	AOK	ETF	28.61	28.61	28.56	28.5701	9078.0
2010-11-18	AOM	ETF	29.53	29.64	29.53	29.6099	5026.0
2010-11-18	AOR	ETF	30.8201	30.849	30.8201	30.84	2061.0
2010-11-18	ARB	ETF	26.21	26.6	26.18	26.31	186188.0
2010-11-18	BAB	ETF	25.5	25.5	25.28	25.43	403978.0
2010-11-18	BAL	ETF	64.65	66.85	64.49	66.73	62286.0
2010-11-18	BALT	ETF	12.0	12.25	11.79	11.81	216269.0
2010-11-18	BBH	ETF	32.9467	33.3667	32.89	33.2033	36900.0
2010-11-18	BIB	ETF	6.7337	6.7337	6.7337	6.7337	2800.0
2010-11-18	BICK	ETF	32.51	32.9	32.51	32.82	56170.0
2010-11-18	BIL	ETF	91.7	91.72	91.7	91.7	96500.0
2010-11-18	BIS	ETF	9240.0	9240.0	9110.416	9168.0	1.875
2010-11-18	BITS	ETF	28.36	28.72	27.48	28.04	1338.0
2010-11-18	BIV	ETF	85.28	85.3	84.9	85.18	168100.0
2010-11-18	BJK	ETF	31.02	31.35	31.02	31.18	19700.0
2010-11-18	BKF	ETF	48.98	49.34	48.63	49.27	198426.0
2010-11-18	BLV	ETF	80.65	80.72	80.1	80.72	19300.0
2010-11-18	BMVP	ETF	13.9967	14.1866	13.9967	14.1633	11013.0
2010-11-18	BND	ETF	81.68	81.74	81.53	81.74	558600.0
2010-11-18	BNE	ETF	11.39	11.41	11.3	11.38	256986.0
2010-11-18	BRF	ETF	59.47	60.36	59.47	60.14	398008.0
2010-11-18	BSCE	ETF	20.9	20.9	20.8001	20.87	24909.0
2010-11-18	BSV	ETF	81.3	81.42	81.27	81.41	266200.0
2010-11-18	BTF	ETF	77.94999999999999	78.49999999999999	77.94999999999999	77.94999999999999	3128.4
2010-11-18	BWX	ETF	29.535	29.67	29.511	29.59	140420.0
2010-11-18	BWZ	ETF	36.8	37.049	36.8	36.85	6656.0
2010-11-18	BZQ	ETF	2681.6	2699.2	2627.2	2648.0	789.5
2010-11-18	CEF	ETF	18.37	18.56	18.31	18.44	1339800.0

> showing 50 of 808 rows — these rows as CSV

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