PREVIEW / etf_daily / 2005-10-19

all etf daily files

  file:    by_date/etf_daily/2005/2005-10-19.parquet
  size:    15 KB
  rows:    281

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-19	SPY	ETF	117.5	119.8	117.12	119.78	116563800.0
2005-10-19	QQQ	ETF	37.74	38.672	37.61	38.67	132942280.0
2005-10-19	IWM	ETF	61.91	63.51	61.38	63.51	42623200.0
2005-10-19	DIA	ETF	102.61	104.35	102.36	104.31	12384800.0
2005-10-19	GLD	ETF	46.51	46.51	46.04	46.34	2958200.0
2005-10-19	TLT	ETF	90.66	90.87	90.35	90.35	904800.0
2005-10-19	AAA	ETF	54.6	55.31	54.6	55.31	4300.0
2005-10-19	ADRE	ETF	99.0	100.81	97.69	100.81	62008.0
2005-10-19	AFK	ETF	25.6	25.65	25.5905	25.5905	6100.0
2005-10-19	AGG	ETF	100.74	100.96	100.74	100.8	138100.0
2005-10-19	AIQ	ETF	35.25	36.75	35.15	36.75	13920.0
2005-10-19	AIS	ETF	1.1	1.2	1.05	1.08	784600.0
2005-10-19	ARB	ETF	37.9	38.58	37.9	38.58	166200.0
2005-10-19	BAB	ETF	51.2	53.12	51.2	52.99	42800.0
2005-10-19	BBC	ETF	7.65	7.65	7.45	7.59	28700.0
2005-10-19	BBH	ETF	61.37	62.7133	61.27	62.6933	2172000.0
2005-10-19	BCM	ETF	59.74	60.22	59.51	60.19	19000.0
2005-10-19	BIS	ETF	632.0	635.2	627.2	635.2	28.1
2005-10-19	BITS	ETF	10.28	11.08	10.28	10.76	1718.0
2005-10-19	BKF	ETF	19.0	19.0	15.9	17.11	1307300.0
2005-10-19	BNE	ETF	13.37	13.52	12.96	13.39	235500.0
2005-10-19	BRF	ETF	15.33	15.34	15.24	15.24	7600.0
2005-10-19	BTF	ETF	84.3	84.64999999999999	83.24999999999999	84.64999999999999	20920.0
2005-10-19	CBON	ETF	30.3	31.55	30.3	31.49	64807.0
2005-10-19	CDL	ETF	13.6	13.76	13.48	13.76	147000.0
2005-10-19	CEF	ETF	5.71	5.75	5.58	5.69	457300.0
2005-10-19	CEW	ETF	25.91	25.91	25.91	25.91	1700.0
2005-10-19	CHB	ETF	12.9	13.57	12.53	13.42	1143100.0
2005-10-19	CHI	ETF	19.05	19.23	18.99	19.23	107300.0
2005-10-19	CHIC	ETF	17.22	17.5	17.19	17.5	584485.0
2005-10-19	CHIR	ETF	43.11	43.3101	42.8001	43.26	1653464.0
2005-10-19	CHY	ETF	15.51	15.57	15.5	15.53	66200.0
2005-10-19	CIL	ETF	26.11	26.11	26.11	26.11	300.0
2005-10-19	CN	ETF	31.65	31.65	30.8845	31.58	38400.0
2005-10-19	CNXT	ETF	1.77	1.82	1.76	1.82	4858965.0
2005-10-19	COMB	ETF	8.16	8.16	8.16	8.16	5359.0
2005-10-19	CPI	ETF	24.2	24.2	24.1	24.1	400.0
2005-10-19	CPST	ETF	2.46	2.55	2.33	2.4	8037817.0
2005-10-19	CSB	ETF	28.5	29.0	28.5	28.92	3500.0
2005-10-19	CSM	ETF	2.425	2.425	2.425	2.425	1600.0
2005-10-19	CSQ	ETF	13.28	13.4599	13.15	13.44	302500.0
2005-10-19	CTEC	ETF	45.599999999999994	46.199999999999996	44.5	46.050000000000004	5009.0
2005-10-19	CURE	ETF	0.0963	0.0988	0.0938	0.0963	188136.0
2005-10-19	CYB	ETF	3.4	3.4	3.2	3.2	3800.0
2005-10-19	DGT	ETF	62.75	63.37	62.46	63.26	4400.0
2005-10-19	DIG	ETF	14.325	14.325	13.975	13.975	2000.0
2005-10-19	DIV	ETF	12.01	12.0501	11.95	11.99	9000.0
2005-10-19	DRIV	ETF	34.69	36.35	34.65	36.3	667517.0
2005-10-19	DSI	ETF	5.63	5.75	5.625	5.75	17000.0
2005-10-19	DUSA	ETF	9.02	9.19	8.85	9.15	76400.0

> showing 50 of 281 rows — these rows as CSV

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