PREVIEW / etf_daily / 2010-02-08

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-08.parquet
  size:    31 KB
  rows:    714

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-02-08	SPY	ETF	106.74	107.33	105.81	105.89	224166900.0
2010-02-08	QQQ	ETF	42.92	43.18	42.64	42.67	94354367.0
2010-02-08	IWM	ETF	59.08	59.6	58.62	58.68	61579200.0
2010-02-08	DIA	ETF	100.0	100.38	99.12	99.22	10929500.0
2010-02-08	GLD	ETF	104.41	105.14	104.0	104.04	17176600.0
2010-02-08	TLT	ETF	91.87	92.15	91.65	92.1	3386000.0
2010-02-08	AAXJ	ETF	50.5	50.65	49.82	49.82	174100.0
2010-02-08	ACWI	ETF	39.48	39.78	39.14	39.19	404700.0
2010-02-08	ACWX	ETF	37.38	37.686	37.09	37.1	72133.0
2010-02-08	ADRE	ETF	38.76	39.0912	38.31	38.33	153228.0
2010-02-08	AFK	ETF	28.24	28.626	28.14	28.5	19308.0
2010-02-08	AGG	ETF	104.51	104.6	104.33	104.6	658400.0
2010-02-08	AGQ	ETF	88.28	90.18	86.8	87.4	252850.0
2010-02-08	AGZ	ETF	108.6	108.6	108.43	108.59	8987.0
2010-02-08	AIA	ETF	36.58	37.01	36.54	36.6099	33193.0
2010-02-08	AIQ	ETF	23.85	25.15	23.85	24.7	54971.0
2010-02-08	AIS	ETF	1.11	1.15	1.1	1.1199	145414.0
2010-02-08	AIVI	ETF	39.41	39.96	39.06	39.06	25100.0
2010-02-08	AMJ	ETF	28.1	28.41	27.97	28.14	342174.0
2010-02-08	AOA	ETF	28.55	28.66	28.33	28.33	9100.0
2010-02-08	AOK	ETF	27.21	27.21	27.1045	27.1045	3434.0
2010-02-08	AOM	ETF	27.62	27.6374	27.4981	27.4981	10911.0
2010-02-08	AOR	ETF	28.05	28.078	27.892	27.892	13615.0
2010-02-08	ARB	ETF	24.38	24.81	23.95	24.15	243598.0
2010-02-08	BAB	ETF	25.01	25.02	24.96	25.0	66242.0
2010-02-08	BAL	ETF	32.75	33.8	32.75	33.6	3773.0
2010-02-08	BBH	ETF	33.5	33.5	33.0767	33.2533	48600.0
2010-02-08	BIL	ETF	91.72	91.74	91.72	91.74	215150.0
2010-02-08	BITS	ETF	31.56	31.96	31.56	31.96	101.0
2010-02-08	BIV	ETF	80.56	80.61	80.38	80.52	145100.0
2010-02-08	BJK	ETF	22.74	23.03	22.71	22.74	17400.0
2010-02-08	BKF	ETF	40.37	40.62	39.56	39.7	502817.0
2010-02-08	BLV	ETF	77.46	77.46	76.62	77.37	24500.0
2010-02-08	BMVP	ETF	12.06	12.14	11.99	11.99	32690.0
2010-02-08	BND	ETF	79.63	79.63	79.46	79.59	411100.0
2010-02-08	BNE	ETF	6.22	6.25	6.09	6.13	166463.0
2010-02-08	BRF	ETF	42.03	42.3455	41.13	41.25	507365.0
2010-02-08	BSV	ETF	80.33	80.33	80.15	80.27	694800.0
2010-02-08	BTF	ETF	63.8	65.25	63.65	64.85	5064.6
2010-02-08	BWX	ETF	27.6	27.75	27.585	27.635	275878.0
2010-02-08	BWZ	ETF	35.4	35.768	35.4	35.464	60721.0
2010-02-08	BZQ	ETF	4960.0	5068.8	4777.6	5046.4	1519.5
2010-02-08	CEF	ETF	12.8	12.9	12.64	12.64	1179200.0
2010-02-08	CEW	ETF	21.42	21.52	21.41	21.48	235035.0
2010-02-08	CGO	ETF	12.94	13.0	12.64	12.9	27181.0
2010-02-08	CGW	ETF	17.07	17.17	16.87	16.87	30132.0
2010-02-08	CHI	ETF	11.68	11.8	11.59	11.76	216808.0
2010-02-08	CHIE	ETF	13.14	13.2699	13.04	13.04	1960.0
2010-02-08	CHII	ETF	13.85	13.95	13.75	13.75	5692.0
2010-02-08	CHIM	ETF	23.68	23.9	23.46	23.46	263545.0

> showing 50 of 714 rows — these rows as CSV

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