PREVIEW / etf_daily / 2005-12-09

all etf daily files

  file:    by_date/etf_daily/2005/2005-12-09.parquet
  size:    16 KB
  rows:    294

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-12-09	SPY	ETF	126.16	126.78	125.82	126.33	50744500.0
2005-12-09	QQQ	ETF	41.571	41.77	41.3799	41.715	56531746.0
2005-12-09	IWM	ETF	68.4	68.76	67.92	68.64	22101700.0
2005-12-09	DIA	ETF	107.67	108.11	107.35	107.74	5127800.0
2005-12-09	GLD	ETF	52.31	52.9	52.03	52.4	5882400.0
2005-12-09	TLT	ETF	89.98	90.01	89.47	89.54	817400.0
2005-12-09	AAA	ETF	54.56	54.8	54.5	54.79	1000.0
2005-12-09	ADRE	ETF	114.9	114.9	113.86	114.38	37864.0
2005-12-09	AFK	ETF	25.58	25.7	25.47	25.7	4400.0
2005-12-09	AGG	ETF	100.15	100.17	99.73	99.96	175800.0
2005-12-09	AIQ	ETF	28.1	28.55	27.6	28.2	12200.0
2005-12-09	AIS	ETF	1.43	1.45	1.33	1.42	182800.0
2005-12-09	AOM	ETF	3.49	3.49	3.4	3.45	5300.0
2005-12-09	ARB	ETF	39.67	40.27	39.6	39.74	77400.0
2005-12-09	BAB	ETF	58.7	58.82	58.15	58.36	67500.0
2005-12-09	BBC	ETF	13.0	13.21	12.28	12.38	342400.0
2005-12-09	BBH	ETF	68.85	68.85	67.7033	67.78	1050000.0
2005-12-09	BCM	ETF	65.49	65.72	65.25	65.32	25000.0
2005-12-09	BITS	ETF	13.24	13.6	13.0	13.4	3100.0
2005-12-09	BKF	ETF	20.15	20.69	20.15	20.29	46400.0
2005-12-09	BNE	ETF	15.04	15.05	14.9	14.98	89300.0
2005-12-09	BRF	ETF	15.15	15.15	15.05	15.07	7400.0
2005-12-09	BTF	ETF	87.3	87.79999999999998	87.24999999999999	87.39999999999999	680.0
2005-12-09	CBON	ETF	31.17	31.4	31.01	31.17	2600.0
2005-12-09	CDL	ETF	13.24	13.3	13.08	13.27	265000.0
2005-12-09	CEF	ETF	6.55	6.66	6.48	6.55	787000.0
2005-12-09	CEW	ETF	25.94	26.0	25.94	26.0	700.0
2005-12-09	CGO	ETF	13.29	13.46	13.29	13.31	42000.0
2005-12-09	CHB	ETF	14.5	14.63	13.89	14.31	590800.0
2005-12-09	CHI	ETF	20.27	20.5	20.2301	20.47	149500.0
2005-12-09	CHIC	ETF	19.42	19.74	19.19	19.63	230792.0
2005-12-09	CHIR	ETF	44.46	44.5701	44.46	44.5401	685947.0
2005-12-09	CHY	ETF	15.64	15.88	15.64	15.85	77300.0
2005-12-09	CIZ	ETF	21.95	21.95	21.95	21.95	100.0
2005-12-09	CN	ETF	31.05	31.19	30.86	31.11	9700.0
2005-12-09	CNXT	ETF	2.56	2.6301	2.56	2.61	7832297.0
2005-12-09	CPST	ETF	3.6	3.66	3.48	3.54	2503898.0
2005-12-09	CSA	ETF	16.8	16.9	16.65	16.65	39100.0
2005-12-09	CSB	ETF	30.2	30.45	30.15	30.41	26600.0
2005-12-09	CSM	ETF	2.4425	2.4425	2.4425	2.4425	13600.0
2005-12-09	CSQ	ETF	13.05	13.11	13.01	13.11	432300.0
2005-12-09	CTEC	ETF	53.4	53.4	50.99999999999999	51.050000000000004	4206.6
2005-12-09	CURE	ETF	0.0238	0.0262	0.0238	0.0238	4174384.0
2005-12-09	CYB	ETF	3.72	3.74	3.72	3.74	5900.0
2005-12-09	DGT	ETF	65.5	65.66	65.47	65.52	1400.0
2005-12-09	DIG	ETF	15.6875	15.7875	15.3875	15.3875	10080.0
2005-12-09	DIV	ETF	11.95	11.97	11.92	11.93	27500.0
2005-12-09	DRIV	ETF	29.1	29.75	28.55	29.62	1120872.0
2005-12-09	DUSA	ETF	10.04	10.04	9.89	9.89	147504.0
2005-12-09	DVY	ETF	61.85	62.53	61.85	62.28	1001700.0

> showing 50 of 294 rows — these rows as CSV

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