PREVIEW / etf_daily / 2006-02-22

all etf daily files

  file:    by_date/etf_daily/2006/2006-02-22.parquet
  size:    16 KB
  rows:    300

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-22	SPY	ETF	128.77	129.65	128.65	129.27	42326700.0
2006-02-22	QQQ	ETF	40.8	41.54	40.68	41.26	90997709.0
2006-02-22	IWM	ETF	72.47	73.01	71.98	72.82	28699200.0
2006-02-22	DIA	ETF	110.79	111.52	110.73	111.1	5032100.0
2006-02-22	GLD	ETF	54.97	55.35	54.86	55.34	3835700.0
2006-02-22	TLT	ETF	91.12	91.45	91.09	91.42	559000.0
2006-02-22	AAA	ETF	53.45	53.699	53.331	53.45	2000.0
2006-02-22	ADRE	ETF	129.9	129.9	128.316	129.13	30288.0
2006-02-22	AFK	ETF	25.42	25.46	25.41	25.46	5900.0
2006-02-22	AGG	ETF	100.14	100.41	100.14	100.3	79400.0
2006-02-22	AIQ	ETF	24.5	25.75	23.95	25.5	21140.0
2006-02-22	AIS	ETF	1.45	1.52	1.4	1.49	631100.0
2006-02-22	AOM	ETF	6.25	6.29	6.1	6.16	39300.0
2006-02-22	ARB	ETF	38.63	39.19	38.51	38.97	69800.0
2006-02-22	BAB	ETF	57.81	58.74	57.81	58.55	24000.0
2006-02-22	BBC	ETF	15.21	15.9	15.21	15.55	554300.0
2006-02-22	BBH	ETF	64.6667	65.4133	64.6333	65.2733	1631100.0
2006-02-22	BCM	ETF	68.45	68.62	68.24	68.45	14300.0
2006-02-22	BITS	ETF	25.64	26.2	25.24	25.32	8194.0
2006-02-22	BKF	ETF	13.33	13.42	13.27	13.39	26600.0
2006-02-22	BNE	ETF	14.98	15.1	14.81	15.1	115500.0
2006-02-22	BRF	ETF	15.45	15.45	15.45	15.45	1000.0
2006-02-22	BTF	ETF	86.89999999999999	87.44999999999999	86.75	87.44999999999999	4420.0
2006-02-22	CBON	ETF	30.0	30.05	29.838	30.0	22630.0
2006-02-22	CDL	ETF	11.56	11.6	11.41	11.53	544200.0
2006-02-22	CEF	ETF	7.62	7.62	7.53	7.57	449500.0
2006-02-22	CFO	ETF	9.85	9.9	9.85	9.9	2600.0
2006-02-22	CGO	ETF	14.48	14.5	14.25	14.4	61200.0
2006-02-22	CHB	ETF	15.46	15.6	15.12	15.54	687900.0
2006-02-22	CHI	ETF	20.7	20.8	20.63	20.75	78800.0
2006-02-22	CHIC	ETF	17.99	18.2	17.8	18.11	183935.0
2006-02-22	CHIR	ETF	45.1299	45.78	45.1299	45.5001	1117440.0
2006-02-22	CHY	ETF	16.14	16.31	16.1284	16.31	114800.0
2006-02-22	CIZ	ETF	23.35	23.95	23.35	23.9	1400.0
2006-02-22	CN	ETF	35.42	35.75	35.31	35.65	39700.0
2006-02-22	CNXT	ETF	2.94	2.95	2.9	2.9	5761924.0
2006-02-22	CPST	ETF	3.18	3.18	3.07	3.08	1318809.0
2006-02-22	CSA	ETF	19.0	19.09	18.93	19.0	8400.0
2006-02-22	CSB	ETF	31.08	31.34	31.05	31.3	11100.0
2006-02-22	CSQ	ETF	14.14	14.22	14.09	14.22	442700.0
2006-02-22	CTEC	ETF	58.099999999999994	58.099999999999994	56.25	56.699999999999996	11810.800000000001
2006-02-22	CYB	ETF	6.0	6.0	5.62	5.91	178000.0
2006-02-22	DBC	ETF	23.15	23.3	22.85	22.9	543900.0
2006-02-22	DGT	ETF	66.55	66.8	66.55	66.71	3900.0
2006-02-22	DIG	ETF	17.0625	17.1875	17.05	17.1875	2800.0
2006-02-22	DIV	ETF	12.52	12.75	12.5	12.73	43100.0
2006-02-22	DRIV	ETF	36.2	37.76	36.2	37.11	673377.0
2006-02-22	DSI	ETF	6.07	6.07	6.065	6.065	600.0
2006-02-22	DUSA	ETF	6.8	6.93	6.57	6.83	201708.0
2006-02-22	DVY	ETF	63.19	63.9	63.11	63.85	327900.0

> showing 50 of 300 rows — these rows as CSV

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