PREVIEW / etf_daily / 2006-03-09

all etf daily files

  file:    by_date/etf_daily/2006/2006-03-09.parquet
  size:    16 KB
  rows:    306

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-03-09	SPY	ETF	128.28	128.68	127.38	127.38	56313600.0
2006-03-09	QQQ	ETF	41.0	41.1501	40.47	40.52	108641563.0
2006-03-09	IWM	ETF	71.87	72.39	71.22	71.22	31106800.0
2006-03-09	DIA	ETF	110.18	110.55	109.68	109.71	6042400.0
2006-03-09	GLD	ETF	54.6	54.78	54.13	54.24	3799200.0
2006-03-09	TLT	ETF	88.56	88.67	88.27	88.61	282100.0
2006-03-09	AAA	ETF	54.39	54.39	54.21	54.24	2400.0
2006-03-09	ADRE	ETF	122.25	124.212	121.67	121.67	65308.0
2006-03-09	AFK	ETF	25.45	25.5	25.45	25.45	2100.0
2006-03-09	AGG	ETF	99.31	99.39	99.08	99.12	105700.0
2006-03-09	AIQ	ETF	29.3	29.8	29.05	29.25	15200.0
2006-03-09	AIS	ETF	1.4	1.43	1.36	1.4	359400.0
2006-03-09	AOM	ETF	6.42	6.52	6.42	6.5	23100.0
2006-03-09	ARB	ETF	34.62	34.63	34.31	34.6	471500.0
2006-03-09	BAB	ETF	56.68	57.39	56.68	56.77	31600.0
2006-03-09	BBC	ETF	14.61	14.94	14.3	14.6	100400.0
2006-03-09	BBH	ETF	64.9333	65.08	64.0567	64.13	835200.0
2006-03-09	BCM	ETF	72.8	73.3	72.65	72.82	14000.0
2006-03-09	BITS	ETF	29.04	30.6	28.48	28.8	31822.0
2006-03-09	BKF	ETF	13.07	13.6	12.75	12.81	53000.0
2006-03-09	BNE	ETF	14.82	14.95	14.46	14.55	87800.0
2006-03-09	BRF	ETF	14.49	14.49	14.4	14.42	18400.0
2006-03-09	BTF	ETF	86.99999999999999	87.35	86.85	87.2	2960.0
2006-03-09	CBON	ETF	30.65	30.78	30.12	30.41	17274.0
2006-03-09	CDL	ETF	11.63	11.63	11.48	11.57	285700.0
2006-03-09	CEF	ETF	7.51	7.69	7.51	7.63	377900.0
2006-03-09	CFO	ETF	9.65	9.65	9.6	9.6	13000.0
2006-03-09	CGO	ETF	14.23	14.65	14.1	14.65	118700.0
2006-03-09	CHB	ETF	14.51	14.67	13.89	14.3	1154700.0
2006-03-09	CHI	ETF	20.62	20.73	20.47	20.58	84600.0
2006-03-09	CHIC	ETF	18.94	19.0	18.47	18.93	183985.0
2006-03-09	CHIR	ETF	45.42	45.5601	45.2499	45.2601	550238.0
2006-03-09	CHY	ETF	16.36	16.37	16.16	16.19	61600.0
2006-03-09	CIZ	ETF	23.35	23.35	23.35	23.35	400.0
2006-03-09	CN	ETF	35.0	35.31	35.0	35.25	21700.0
2006-03-09	CNXT	ETF	3.205	3.27	3.12	3.14	12198571.0
2006-03-09	COMB	ETF	8.45	8.45	8.45	8.45	1415.0
2006-03-09	CPST	ETF	3.165	3.2	3.13	3.13	1586456.0
2006-03-09	CSA	ETF	19.36	19.9699	19.26	19.4	5300.0
2006-03-09	CSB	ETF	30.58	30.71	30.5	30.62	4500.0
2006-03-09	CSQ	ETF	14.0	14.09	13.95	14.06	333000.0
2006-03-09	CTEC	ETF	60.49999999999999	62.35	58.3	58.699999999999996	13466.2
2006-03-09	CYB	ETF	5.87	5.87	5.61	5.68	36700.0
2006-03-09	DBC	ETF	22.85	22.99	22.7301	22.95	413100.0
2006-03-09	DGT	ETF	66.84	66.84	66.47	66.52	5000.0
2006-03-09	DIG	ETF	17.0125	17.0125	17.0	17.0	1600.0
2006-03-09	DIV	ETF	12.42	12.54	12.42	12.49	22000.0
2006-03-09	DRIV	ETF	39.725	41.19	39.72	40.45	1253341.0
2006-03-09	DSI	ETF	6.185	6.185	6.185	6.185	16800.0
2006-03-09	DUSA	ETF	7.3	7.31	7.13	7.13	148372.0

> showing 50 of 306 rows — these rows as CSV

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