PREVIEW / etf_daily / 2006-03-02

all etf daily files

  file:    by_date/etf_daily/2006/2006-03-02.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-03-02	SPY	ETF	128.9	129.42	128.61	129.36	60642300.0
2006-03-02	QQQ	ETF	41.55	41.84	41.41	41.69	69878146.0
2006-03-02	IWM	ETF	73.66	73.89	73.09	73.59	36546000.0
2006-03-02	DIA	ETF	110.16	110.5	109.82	110.38	5008800.0
2006-03-02	GLD	ETF	56.15	56.82	55.99	56.74	3862000.0
2006-03-02	TLT	ETF	90.06	90.1	89.4	89.85	1640000.0
2006-03-02	AAA	ETF	53.64	54.0	53.64	54.0	2500.0
2006-03-02	ADRE	ETF	130.14	131.34	130.14	131.16	16096.0
2006-03-02	AFK	ETF	25.46	25.52	25.46	25.48	7200.0
2006-03-02	AGG	ETF	99.85	99.85	99.47	99.7	134000.0
2006-03-02	AIQ	ETF	29.45	29.85	29.1	29.3	23560.0
2006-03-02	AIS	ETF	1.35	1.36	1.32	1.36	332800.0
2006-03-02	AOM	ETF	6.29	6.29	6.1	6.14	27400.0
2006-03-02	ARB	ETF	35.88	35.88	34.53	35.15	2552300.0
2006-03-02	BAB	ETF	57.32	57.7	57.08	57.5	33500.0
2006-03-02	BBC	ETF	15.75	15.77	14.52	15.4	166800.0
2006-03-02	BBH	ETF	65.32	65.7933	65.0	65.7933	1543800.0
2006-03-02	BCM	ETF	71.77	71.95	71.5	71.83	37100.0
2006-03-02	BITS	ETF	33.04	33.204	32.304	32.484	67806.0
2006-03-02	BKF	ETF	13.23	13.55	13.23	13.48	37800.0
2006-03-02	BNE	ETF	15.02	15.09	14.95	15.05	175200.0
2006-03-02	BOSS	ETF	34.63	34.63	34.47	34.47	100.0
2006-03-02	BRF	ETF	15.45	15.45	15.12	15.12	38100.0
2006-03-02	BTF	ETF	87.94999999999999	88.14999999999999	87.44999999999999	88.14999999999999	12340.0
2006-03-02	CBON	ETF	30.06	30.32	30.05	30.05	8083.0
2006-03-02	CDL	ETF	11.27	11.6	11.23	11.58	911100.0
2006-03-02	CEF	ETF	7.74	7.99	7.74	7.95	604700.0
2006-03-02	CEW	ETF	25.61	25.62	25.61	25.61	800.0
2006-03-02	CFO	ETF	9.8	9.8	9.8	9.8	1000.0
2006-03-02	CGO	ETF	14.42	14.48	14.31	14.42	35000.0
2006-03-02	CHB	ETF	16.02	16.05	15.58	15.68	507400.0
2006-03-02	CHI	ETF	20.85	20.95	20.81	20.85	82200.0
2006-03-02	CHIC	ETF	18.99	19.05	18.42	18.96	311765.0
2006-03-02	CHIR	ETF	45.33	45.6501	45.3201	45.5901	1689232.0
2006-03-02	CHY	ETF	16.44	16.5	16.43	16.48	59300.0
2006-03-02	CIL	ETF	25.56	25.56	25.56	25.56	200.0
2006-03-02	CN	ETF	35.75	36.19	35.75	35.99	53400.0
2006-03-02	CNXT	ETF	3.19	3.2901	3.15	3.17	35398537.0
2006-03-02	CPST	ETF	3.25	3.25	3.13	3.18	1769349.0
2006-03-02	CSA	ETF	19.48	19.76	19.48	19.51	13200.0
2006-03-02	CSB	ETF	30.94	31.2	30.93	31.2	6000.0
2006-03-02	CSQ	ETF	14.29	14.32	14.2	14.2	374100.0
2006-03-02	CTEC	ETF	57.15	57.199999999999996	56.3	56.699999999999996	3419.8
2006-03-02	CYB	ETF	6.3	6.3	6.13	6.16	36400.0
2006-03-02	DBC	ETF	23.36	23.72	23.27	23.66	885900.0
2006-03-02	DGT	ETF	66.4	66.73	66.4	66.66	3900.0
2006-03-02	DIG	ETF	17.3125	17.3125	17.2625	17.2625	6640.0
2006-03-02	DIV	ETF	12.82	12.82	12.76	12.79	89700.0
2006-03-02	DRIV	ETF	38.1	38.3	37.75	37.94	402353.0
2006-03-02	DSI	ETF	6.185	6.195	6.165	6.175	16400.0

> showing 50 of 300 rows — these rows as CSV

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