PREVIEW / etf_daily / 2010-11-17

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-17.parquet
  size:    35 KB
  rows:    809

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-17	SPY	ETF	118.21	118.71	117.86	118.22	172308900.0
2010-11-17	QQQ	ETF	51.49	51.87	51.35	51.6	77836150.0
2010-11-17	IWM	ETF	70.8	71.02	70.4	70.83	39512500.0
2010-11-17	DIA	ETF	110.64	110.79	110.26	110.44	5558800.0
2010-11-17	GLD	ETF	130.77	131.37	130.13	130.38	16432100.0
2010-11-17	TLT	ETF	95.8	96.76	95.34	95.61	9915600.0
2010-11-17	AADR	ETF	28.25	28.38	28.18	28.32	3300.0
2010-11-17	AAXJ	ETF	61.41	61.72	61.37	61.38	376000.0
2010-11-17	ACWI	ETF	44.55	44.71	44.39	44.48	285800.0
2010-11-17	ACWX	ETF	42.41	42.5945	42.35	42.49	48421.0
2010-11-17	ADRE	ETF	45.28	45.68	45.264	45.4	40932.0
2010-11-17	AFK	ETF	33.48	33.57	33.19	33.3899	21146.0
2010-11-17	AGG	ETF	107.33	107.47	107.15	107.21	822500.0
2010-11-17	AGQ	ETF	222.58	229.16	220.74	222.86	642900.0
2010-11-17	AGZ	ETF	110.95	111.02	110.795	110.795	13682.0
2010-11-17	AIA	ETF	44.23	44.53	44.19	44.41	35675.0
2010-11-17	AIQ	ETF	19.8	20.175	19.6	19.95	11458.0
2010-11-17	AIS	ETF	1.46	1.47	1.41	1.42	245018.0
2010-11-17	AIVI	ETF	43.83	44.04	43.69	43.73	33800.0
2010-11-17	AMJ	ETF	35.96	36.07	35.7	36.0	438311.0
2010-11-17	AMLP	ETF	78.9	79.2	78.75	79.0	74860.0
2010-11-17	AOA	ETF	32.43	32.59	32.43	32.5	10600.0
2010-11-17	AOK	ETF	28.4544	28.52	28.4544	28.4756	10105.0
2010-11-17	AOM	ETF	29.34	29.43	29.34	29.3704	4827.0
2010-11-17	AOR	ETF	30.5	30.57	30.44	30.48	9191.0
2010-11-17	ARB	ETF	25.96	26.18	25.59	25.9	186085.0
2010-11-17	BAB	ETF	25.32	25.54	25.15	25.41	781754.0
2010-11-17	BAL	ETF	63.48	64.0	61.99	62.76	106073.0
2010-11-17	BALT	ETF	11.99	12.02	11.73	11.87	82720.0
2010-11-17	BBH	ETF	32.7467	32.83	32.67	32.81	88200.0
2010-11-17	BIB	ETF	6.5038	6.5038	6.5038	6.5038	3832.0
2010-11-17	BICK	ETF	31.78	32.05	31.78	31.99	28447.0
2010-11-17	BIL	ETF	91.7	91.72	91.7	91.72	55300.0
2010-11-17	BITS	ETF	28.0	28.4	27.8	28.4	500.0
2010-11-17	BIV	ETF	85.59	85.71	85.25	85.39	139100.0
2010-11-17	BJK	ETF	30.74	30.77	30.23	30.45	20000.0
2010-11-17	BKF	ETF	47.59	48.289	47.55	48.05	206899.0
2010-11-17	BLV	ETF	80.93	81.34	80.53	80.65	53200.0
2010-11-17	BMVP	ETF	13.843	13.897	13.823	13.841	14717.0
2010-11-17	BND	ETF	81.76	81.9	81.66	81.74	507300.0
2010-11-17	BNE	ETF	11.38	11.4	11.34	11.38	99396.0
2010-11-17	BNO	ETF	28.18	28.34	27.765	27.765	5000.0
2010-11-17	BRF	ETF	58.14	58.74	57.92	58.42	376678.0
2010-11-17	BSCE	ETF	20.9	20.9	20.859	20.86	6869.0
2010-11-17	BSV	ETF	81.41	81.49	81.38	81.38	490200.0
2010-11-17	BTF	ETF	77.45	77.75	77.05	77.19999999999999	2936.0
2010-11-17	BWX	ETF	29.415	29.585	29.25	29.48	160070.0
2010-11-17	BWZ	ETF	36.66	36.87	36.66	36.7999	9998.0
2010-11-17	BZQ	ETF	2788.8	2817.6	2737.6	2803.2	1072.5
2010-11-17	CEF	ETF	17.87	18.07	17.81	17.92	866400.0

> showing 50 of 809 rows — these rows as CSV

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