PREVIEW / etf_daily / 2009-02-20

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-20.parquet
  size:    28 KB
  rows:    642

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
2009-02-20	SPY	ETF	76.73	78.34	75.77	77.42	477176600.0
2009-02-20	QQQ	ETF	28.46	29.15	28.39	28.87	210752398.0
2009-02-20	IWM	ETF	40.9	41.64	40.19	41.14	83388200.0
2009-02-20	DIA	ETF	73.32	74.71	72.48	73.73	46343700.0
2009-02-20	GLD	ETF	98.0	98.99	97.14	97.8	43854800.0
2009-02-20	TLT	ETF	104.27	105.16	103.3	103.92	4272000.0
2009-02-20	AAXJ	ETF	29.13	29.22	28.54	29.01	316200.0
2009-02-20	ACWI	ETF	26.5	27.19	26.47	26.85	90900.0
2009-02-20	ACWX	ETF	24.41	24.89	23.74	24.65	1062258.0
2009-02-20	ADRE	ETF	25.0	25.33	24.6	25.09	365892.0
2009-02-20	AFK	ETF	19.06	19.06	18.0504	18.46	665.0
2009-02-20	AGG	ETF	101.68	101.91	100.77	100.98	656300.0
2009-02-20	AGQ	ETF	99.92	101.4	98.24	99.12	82550.0
2009-02-20	AGZ	ETF	107.9	108.2	107.6	107.8	10112.0
2009-02-20	AIA	ETF	22.05	22.3	21.74	22.06	8808.0
2009-02-20	AIQ	ETF	44.85	45.5	44.55	45.35	69960.0
2009-02-20	AIS	ETF	0.3903	0.4	0.3496	0.39	140928.0
2009-02-20	AIVI	ETF	26.5	27.19	26.21	26.75	41700.0
2009-02-20	AOA	ETF	21.0	21.04	20.31	20.84	5100.0
2009-02-20	AOK	ETF	24.57	24.586	24.55	24.55	683.0
2009-02-20	AOM	ETF	23.51	23.61	23.49	23.49	5460.0
2009-02-20	AOR	ETF	22.33	22.63	22.14	22.2401	18842.0
2009-02-20	ARB	ETF	12.62	13.21	12.62	13.08	340292.0
2009-02-20	BAL	ETF	25.1101	25.1101	25.11	25.11	216.0
2009-02-20	BBH	ETF	57.6667	58.3533	57.54	58.1533	148800.0
2009-02-20	BIL	ETF	91.72	91.78	91.72	91.78	227400.0
2009-02-20	BITS	ETF	18.64	18.8	16.76	18.8	1962.0
2009-02-20	BIV	ETF	77.21	77.64	77.08	77.31	94100.0
2009-02-20	BJK	ETF	14.43	14.43	13.25	13.31	2900.0
2009-02-20	BKF	ETF	22.3	22.3365	21.58	21.9	71774.0
2009-02-20	BLV	ETF	74.0	74.07	73.41	73.41	13200.0
2009-02-20	BMVP	ETF	9.62	9.8113	9.5533	9.7233	64369.0
2009-02-20	BND	ETF	77.14	77.18	76.94	76.97	419300.0
2009-02-20	BNE	ETF	2.21	2.21	2.01	2.04	331623.0
2009-02-20	BSV	ETF	78.62	79.15	78.62	79.15	267500.0
2009-02-20	BTF	ETF	38.599999999999994	39.7	38.45	39.449999999999996	17609.0
2009-02-20	BWX	ETF	24.63	25.0999	24.63	25.095	522048.0
2009-02-20	CBON	ETF	1.63	1.63	1.04	1.18	107230.0
2009-02-20	CDL	ETF	0.14	0.15	0.13	0.14	467045.0
2009-02-20	CEF	ETF	12.34	12.73	12.27	12.31	2651800.0
2009-02-20	CGO	ETF	8.94	8.94	8.23	8.6701	74461.0
2009-02-20	CGW	ETF	12.2	12.27	11.83	12.04	75026.0
2009-02-20	CHB	ETF	0.32	0.33	0.3	0.31	530845.0
2009-02-20	CHI	ETF	7.9	7.9	7.51	7.83	349657.0
2009-02-20	CHIC	ETF	4.84	5.0	4.72	4.95	131016.0
2009-02-20	CHW	ETF	5.44	5.44	5.07	5.3	306888.0
2009-02-20	CHY	ETF	7.41	7.51	7.14	7.476	477789.0
2009-02-20	CMF	ETF	51.64	51.956	51.03	51.03	17730.0
2009-02-20	CNXT	ETF	0.55	0.57	0.461	0.5	454779.0
2009-02-20	COW	ETF	30.66	30.79	30.21	30.3	4774.0

> showing 50 of 642 rows — these rows as CSV

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