PREVIEW / etf_daily / 2007-02-22

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-22.parquet
  size:    21 KB
  rows:    432

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-22	SPY	ETF	146.05	146.42	145.17	145.87	79067400.0
2007-02-22	QQQ	ETF	45.36	45.55	45.07	45.42	116386138.0
2007-02-22	IWM	ETF	82.25	82.45	81.63	82.39	58815900.0
2007-02-22	DIA	ETF	127.4	127.59	126.44	126.79	7221000.0
2007-02-22	GLD	ETF	67.44	67.56	66.97	67.15	6562800.0
2007-02-22	TLT	ETF	88.41	88.45	88.09	88.21	485200.0
2007-02-22	AAA	ETF	60.85	60.99	60.79	60.94	4300.0
2007-02-22	ADRE	ETF	41.06	41.25	40.67	40.82	202872.0
2007-02-22	AGG	ETF	100.18	100.18	100.01	100.05	188000.0
2007-02-22	AIQ	ETF	39.5	39.55	38.5	39.5	81040.0
2007-02-22	AIS	ETF	1.23	1.25	1.2	1.24	133800.0
2007-02-22	ARB	ETF	46.21	46.21	45.4	45.75	208300.0
2007-02-22	BAB	ETF	111.63	112.15	111.45	112.14	39200.0
2007-02-22	BBC	ETF	4.33	4.51	4.3	4.3585	96900.0
2007-02-22	BBH	ETF	63.1	63.1633	62.1367	62.5	1281900.0
2007-02-22	BITS	ETF	44.92	45.88	44.0	45.8	13314.0
2007-02-22	BNE	ETF	15.76	15.83	15.65	15.76	54200.0
2007-02-22	BRF	ETF	14.46	14.49	14.46	14.47	4300.0
2007-02-22	BTF	ETF	113.24999999999999	113.45	113.24999999999999	113.3	740.0
2007-02-22	CBON	ETF	33.58	33.61	32.97	33.49	17832.0
2007-02-22	CDL	ETF	10.43	10.45	10.31	10.43	304300.0
2007-02-22	CEF	ETF	9.75	9.78	9.56	9.73	357400.0
2007-02-22	CGO	ETF	16.82	16.91	16.72	16.9	38300.0
2007-02-22	CHB	ETF	7.55	7.71	7.46	7.55	1767100.0
2007-02-22	CHI	ETF	20.2	20.2	20.07	20.14	113500.0
2007-02-22	CHIC	ETF	30.41	30.75	30.02	30.74	534711.0
2007-02-22	CHY	ETF	16.97	17.02	16.9	16.91	200200.0
2007-02-22	CN	ETF	52.05	52.05	50.78	50.89	92800.0
2007-02-22	CNXT	ETF	2.04	2.09	2.04	2.08	7186517.0
2007-02-22	CPI	ETF	23.29	23.36	23.1	23.1	1100.0
2007-02-22	CPST	ETF	1.03	1.08	1.0	1.05	13427023.0
2007-02-22	CSA	ETF	22.72	22.72	22.3765	22.5	100800.0
2007-02-22	CSB	ETF	32.95	33.3	32.95	33.3	10300.0
2007-02-22	CSD	ETF	26.9	26.92	26.7	26.81	39600.0
2007-02-22	CSM	ETF	1.3625	1.3625	1.3625	1.3625	12400.0
2007-02-22	CSQ	ETF	15.16	15.24	15.06	15.13	481000.0
2007-02-22	CTEC	ETF	87.3	87.79999999999998	79.14999999999999	80.19999999999999	82881.8
2007-02-22	CVY	ETF	27.34	27.38	27.23	27.31	26400.0
2007-02-22	CWI	ETF	25.5333	25.54	25.4267	25.5267	82950.0
2007-02-22	DBA	ETF	27.2	27.66	27.13	27.5	788100.0
2007-02-22	DBB	ETF	24.59	24.59	24.36	24.5	16100.0
2007-02-22	DBC	ETF	24.85	25.15	24.77	25.08	260500.0
2007-02-22	DBE	ETF	25.64	26.06	25.62	26.06	8200.0
2007-02-22	DBO	ETF	25.21	25.49	25.07	25.47	9000.0
2007-02-22	DBP	ETF	27.11	27.19	27.0	27.05	23700.0
2007-02-22	DBS	ETF	28.02	28.1	27.84	27.97	12000.0
2007-02-22	DBV	ETF	26.86	26.87	26.7	26.8	120900.0
2007-02-22	DDM	ETF	7.2	7.2	7.0767	7.1258	1956000.0
2007-02-22	DEF	ETF	26.57	26.57	26.4	26.45	12400.0
2007-02-22	DES	ETF	19.8533	19.8733	19.7633	19.85	57000.0

> showing 50 of 432 rows — these rows as CSV

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