PREVIEW / etf_daily / 2007-02-20

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-20.parquet
  size:    21 KB
  rows:    437

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
2007-02-20	SPY	ETF	145.56	146.2	145.0	146.04	56911800.0
2007-02-20	QQQ	ETF	44.65	45.12	44.43	44.68	93683246.0
2007-02-20	IWM	ETF	81.0	82.16	80.1	81.95	71903200.0
2007-02-20	DIA	ETF	127.45	127.85	126.92	127.66	5611900.0
2007-02-20	GLD	ETF	66.1	66.1	65.0	65.31	4810700.0
2007-02-20	TLT	ETF	88.5	88.85	88.5	88.84	847400.0
2007-02-20	AAA	ETF	60.86	61.13	60.86	60.92	3600.0
2007-02-20	ADRE	ETF	40.5	40.6	40.17	40.59	200019.0
2007-02-20	AGG	ETF	100.16	100.29	100.05	100.26	252400.0
2007-02-20	AIQ	ETF	37.05	38.8	36.85	38.55	25400.0
2007-02-20	AIS	ETF	1.17	1.24	1.17	1.21	60700.0
2007-02-20	ARB	ETF	45.66	46.39	45.5	46.1	164800.0
2007-02-20	BAB	ETF	112.13	112.79	111.88	112.6	51600.0
2007-02-20	BBC	ETF	4.35	4.42	4.3	4.3	97900.0
2007-02-20	BBH	ETF	62.74	63.3333	62.3667	62.7733	416700.0
2007-02-20	BITS	ETF	44.12	46.08	44.0	45.08	27298.0
2007-02-20	BNE	ETF	15.72	15.97	15.69	15.85	135300.0
2007-02-20	BRF	ETF	14.42	14.45	14.42	14.45	2900.0
2007-02-20	BTF	ETF	113.45	113.6	113.1	113.55	2600.0
2007-02-20	CBON	ETF	33.02	33.7	32.82	33.63	40569.0
2007-02-20	CDL	ETF	10.39	10.44	10.3	10.44	228200.0
2007-02-20	CEF	ETF	9.63	9.66	9.43	9.57	364100.0
2007-02-20	CGO	ETF	16.9	16.99	16.85	16.9	22800.0
2007-02-20	CHB	ETF	7.5	7.68	7.41	7.51	2079100.0
2007-02-20	CHI	ETF	20.28	20.28	20.16	20.24	94200.0
2007-02-20	CHIC	ETF	29.56	30.65	29.34	30.37	612401.0
2007-02-20	CHY	ETF	17.08	17.1	17.01	17.04	154200.0
2007-02-20	CIL	ETF	25.41	25.55	25.41	25.54	2900.0
2007-02-20	CN	ETF	52.0	52.7	51.63	52.5	63100.0
2007-02-20	CNXT	ETF	2.04	2.09	2.0	2.08	9094442.0
2007-02-20	CPI	ETF	23.8	23.8	23.8	23.8	200.0
2007-02-20	CPST	ETF	0.89	0.89	0.87	0.8766	8626629.0
2007-02-20	CSA	ETF	22.2	22.85	22.2	22.45	13500.0
2007-02-20	CSB	ETF	33.42	33.56	33.29	33.56	12500.0
2007-02-20	CSD	ETF	26.57	26.73	26.55	26.73	11600.0
2007-02-20	CSM	ETF	1.35	1.3575	1.35	1.3575	2000.0
2007-02-20	CSQ	ETF	15.25	15.34	15.2	15.3	443900.0
2007-02-20	CTEC	ETF	89.0	89.25	87.6	87.69999999999999	12052.2
2007-02-20	CVY	ETF	27.28	27.39	27.17	27.38	37900.0
2007-02-20	CWI	ETF	25.4067	25.5467	25.3667	25.54	37200.0
2007-02-20	DBA	ETF	26.74	26.75	26.5	26.66	299800.0
2007-02-20	DBB	ETF	23.65	23.65	23.26	23.5	35500.0
2007-02-20	DBC	ETF	24.13	24.23	23.88	24.22	201100.0
2007-02-20	DBE	ETF	24.66	24.82	24.5	24.78	9000.0
2007-02-20	DBO	ETF	24.3	24.55	24.1	24.55	8100.0
2007-02-20	DBP	ETF	26.47	26.51	26.0	26.24	32600.0
2007-02-20	DBS	ETF	27.37	27.44	27.0	27.2	18600.0
2007-02-20	DBV	ETF	26.47	26.57	26.47	26.54	142900.0
2007-02-20	DDM	ETF	7.1825	7.2267	7.1267	7.215	710400.0
2007-02-20	DEF	ETF	26.44	26.59	26.41	26.59	12200.0

> showing 50 of 437 rows — these rows as CSV

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