PREVIEW / etf_daily / 2006-02-21

all etf daily files

  file:    by_date/etf_daily/2006/2006-02-21.parquet
  size:    16 KB
  rows:    302

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
2006-02-21	SPY	ETF	129.11	129.4	128.29	128.49	46456300.0
2006-02-21	QQQ	ETF	41.21	41.27	40.61	40.75	85106042.0
2006-02-21	IWM	ETF	72.75	72.93	71.85	72.33	21177400.0
2006-02-21	DIA	ETF	111.2	111.32	110.4	110.57	9063600.0
2006-02-21	GLD	ETF	55.14	55.34	55.0	55.12	3352600.0
2006-02-21	TLT	ETF	90.9	91.0	90.78	90.8	433300.0
2006-02-21	AAA	ETF	54.0	54.0	53.55	53.56	5200.0
2006-02-21	ADRE	ETF	130.93	130.93	128.79	128.79	34976.0
2006-02-21	AFK	ETF	25.42	25.49	25.42	25.42	2500.0
2006-02-21	AGG	ETF	100.27	100.29	99.88	99.9	276700.0
2006-02-21	AIQ	ETF	25.8	26.2	23.65	24.7	19560.0
2006-02-21	AIS	ETF	1.41	1.42	1.36	1.38	110400.0
2006-02-21	AOM	ETF	5.97	6.22	5.94	6.16	218200.0
2006-02-21	ARB	ETF	38.56	38.7	38.13	38.64	256200.0
2006-02-21	BAB	ETF	58.23	58.51	58.0901	58.21	42800.0
2006-02-21	BBC	ETF	14.8	15.47	14.8	15.2	102000.0
2006-02-21	BBH	ETF	65.3333	65.3767	64.56	64.6267	1623900.0
2006-02-21	BCM	ETF	67.9	68.7	67.9	68.7	19000.0
2006-02-21	BITS	ETF	25.92	26.4	24.04	25.44	38767.0
2006-02-21	BKF	ETF	13.66	13.9	13.3	13.32	72100.0
2006-02-21	BNE	ETF	15.0	15.04	14.75	14.92	148600.0
2006-02-21	BRF	ETF	15.37	15.42	15.37	15.42	8100.0
2006-02-21	BTF	ETF	86.99999999999999	87.5	86.99999999999999	87.14999999999999	3380.0
2006-02-21	CBON	ETF	30.05	30.06	29.74	29.94	12401.0
2006-02-21	CDL	ETF	11.79	11.79	11.52	11.58	463800.0
2006-02-21	CEF	ETF	7.62	7.63	7.51	7.58	656500.0
2006-02-21	CFO	ETF	9.81	9.81	9.81	9.81	15000.0
2006-02-21	CGO	ETF	14.23	14.46	14.2	14.45	28300.0
2006-02-21	CHB	ETF	15.69	15.75	15.33	15.47	1323700.0
2006-02-21	CHI	ETF	20.5	20.74	20.48	20.73	120700.0
2006-02-21	CHIC	ETF	17.87	18.09	17.84	17.99	179627.0
2006-02-21	CHIR	ETF	45.3699	45.3999	45.0	45.2001	816910.0
2006-02-21	CHY	ETF	16.1	16.23	16.06	16.19	147300.0
2006-02-21	CIL	ETF	25.65	25.65	25.59	25.59	300.0
2006-02-21	CIZ	ETF	23.15	23.5	23.15	23.5	1000.0
2006-02-21	CN	ETF	35.0	35.2	35.0	35.1	29800.0
2006-02-21	CNXT	ETF	3.0	3.01	2.93	2.96	12261215.0
2006-02-21	COMB	ETF	8.49	8.5	8.35	8.49	1850.0
2006-02-21	CPI	ETF	30.1	30.1	30.1	30.1	100.0
2006-02-21	CPST	ETF	3.11	3.2	3.07	3.16	1999667.0
2006-02-21	CSA	ETF	18.75	18.84	18.65	18.84	13000.0
2006-02-21	CSB	ETF	31.65	31.7	31.4485	31.54	5200.0
2006-02-21	CSM	ETF	2.4775	2.4775	2.4775	2.4775	5200.0
2006-02-21	CSQ	ETF	14.07	14.18	14.05	14.12	432900.0
2006-02-21	CTEC	ETF	58.699999999999996	59.199999999999996	57.699999999999996	57.75	4586.0
2006-02-21	CYB	ETF	5.78	6.21	5.78	5.92	203100.0
2006-02-21	DBC	ETF	23.35	23.4	23.1	23.28	714100.0
2006-02-21	DGT	ETF	66.68	66.69	66.52	66.52	1400.0
2006-02-21	DIG	ETF	17.05	17.05	17.05	17.05	2000.0
2006-02-21	DIV	ETF	12.47	12.59	12.46	12.53	30700.0

> showing 50 of 302 rows — these rows as CSV

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