PREVIEW / etf_daily / 2005-10-31

all etf daily files

  file:    by_date/etf_daily/2005/2005-10-31.parquet
  size:    15 KB
  rows:    285

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
2005-10-31	SPY	ETF	120.29	121.3	120.13	120.13	77698900.0
2005-10-31	QQQ	ETF	38.43	39.05	38.42	38.87	115430994.0
2005-10-31	IWM	ETF	63.45	64.55	63.41	63.78	35208700.0
2005-10-31	DIA	ETF	104.24	104.79	103.89	103.91	5342600.0
2005-10-31	GLD	ETF	47.02	47.04	46.33	46.4	2327500.0
2005-10-31	TLT	ETF	89.77	90.04	89.58	89.78	547700.0
2005-10-31	AAA	ETF	56.18	56.47	56.15	56.2	9000.0
2005-10-31	ADRE	ETF	102.79	103.56	101.9101	103.31	16600.0
2005-10-31	AFK	ETF	25.37	25.46	25.37	25.4	5900.0
2005-10-31	AGG	ETF	100.1	100.43	100.06	100.21	91300.0
2005-10-31	AIQ	ETF	34.35	35.25	34.2	34.55	32280.0
2005-10-31	AIS	ETF	1.24	1.25	1.09	1.14	235100.0
2005-10-31	ARB	ETF	37.48	37.99	37.35	37.41	263400.0
2005-10-31	BAB	ETF	53.42	53.5	53.22	53.41	18300.0
2005-10-31	BBC	ETF	6.93	6.93	6.6	6.66	26600.0
2005-10-31	BBH	ETF	63.82	64.75	63.6767	64.4367	1773300.0
2005-10-31	BCM	ETF	61.35	61.92	61.16	61.41	26500.0
2005-10-31	BIS	ETF	622.4	656.0	622.4	654.4	158.0
2005-10-31	BITS	ETF	10.76	11.12	10.48	10.64	4511.0
2005-10-31	BKF	ETF	16.7	17.18	16.68	17.18	280200.0
2005-10-31	BNE	ETF	13.98	14.38	13.98	14.22	209300.0
2005-10-31	BRF	ETF	15.5	15.5	15.21	15.308	19300.0
2005-10-31	BTF	ETF	84.3	85.0	84.3	84.64999999999999	6180.0
2005-10-31	CBON	ETF	32.6	32.75	32.33	32.64	20743.0
2005-10-31	CDL	ETF	13.65	13.99	13.65	13.78	430300.0
2005-10-31	CEF	ETF	5.89	5.89	5.71	5.75	469800.0
2005-10-31	CEW	ETF	25.85	25.85	25.75	25.78	1500.0
2005-10-31	CGO	ETF	15.0	15.01	15.0	15.0	77400.0
2005-10-31	CHB	ETF	14.0	14.08	13.66	13.88	445300.0
2005-10-31	CHI	ETF	19.67	19.7	19.35	19.52	123500.0
2005-10-31	CHIC	ETF	16.87	17.78	16.86	17.62	553266.0
2005-10-31	CHIR	ETF	44.2599	44.37	44.0799	44.1399	9542398.0
2005-10-31	CHY	ETF	15.6	15.67	15.5	15.52	118500.0
2005-10-31	CIL	ETF	25.91	25.91	25.91	25.91	100.0
2005-10-31	CIZ	ETF	21.6	21.6	21.6	21.6	200.0
2005-10-31	CN	ETF	31.37	31.74	31.37	31.74	11000.0
2005-10-31	CNXT	ETF	1.91	1.96	1.9	1.94	9216893.0
2005-10-31	COMB	ETF	8.25	8.25	8.25	8.25	1000.0
2005-10-31	CPST	ETF	2.45	2.52	2.38	2.42	1588876.0
2005-10-31	CSA	ETF	17.09	17.49	17.09	17.29	78500.0
2005-10-31	CSB	ETF	28.73	28.91	28.54	28.63	10000.0
2005-10-31	CSM	ETF	2.4325	2.4325	2.4325	2.4325	4000.0
2005-10-31	CSQ	ETF	13.62	13.75	13.62	13.71	260100.0
2005-10-31	CTEC	ETF	45.0	45.0	42.55	42.99999999999999	21282.4
2005-10-31	CURE	ETF	0.1113	0.1125	0.085	0.0862	7228856.0
2005-10-31	CYB	ETF	3.15	3.22	3.13	3.22	15500.0
2005-10-31	DGT	ETF	63.78	63.89	63.74	63.89	1200.0
2005-10-31	DIG	ETF	13.8	13.8	13.8	13.8	800.0
2005-10-31	DIV	ETF	12.08	12.08	11.99	12.05	21500.0
2005-10-31	DRIV	ETF	28.43	28.44	27.27	28.01	1753453.0

> showing 50 of 285 rows — these rows as CSV

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