PREVIEW / etf_daily / 2005-12-23

all etf daily files

  file:    by_date/etf_daily/2005/2005-12-23.parquet
  size:    16 KB
  rows:    297

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-23	SPY	ETF	126.78	126.86	126.42	126.76	27977300.0
2005-12-23	QQQ	ETF	41.51	41.59	41.299	41.403	38000400.0
2005-12-23	IWM	ETF	68.1	68.27	67.96	68.13	15255300.0
2005-12-23	DIA	ETF	108.85	108.95	108.6	108.75	1906900.0
2005-12-23	GLD	ETF	50.1	50.46	50.08	50.12	2877600.0
2005-12-23	TLT	ETF	91.19	92.04	91.1	91.8	2295800.0
2005-12-23	AAA	ETF	54.25	54.6	54.248	54.6	4100.0
2005-12-23	ADRE	ETF	115.09	116.41	115.09	116.368	12120.0
2005-12-23	AFK	ETF	25.3	25.3	25.16	25.16	7900.0
2005-12-23	AGG	ETF	100.37	100.94	100.37	100.88	154300.0
2005-12-23	AIQ	ETF	29.7	29.95	28.35	28.9	4180.0
2005-12-23	AIS	ETF	1.42	1.45	1.37	1.41	81500.0
2005-12-23	AOM	ETF	4.0	4.0	3.94	3.95	13000.0
2005-12-23	ARB	ETF	38.95	39.27	38.8	38.9	60200.0
2005-12-23	BAB	ETF	58.3	58.73	58.1	58.63	9000.0
2005-12-23	BBC	ETF	15.1	15.1	14.67	14.79	105100.0
2005-12-23	BBH	ETF	68.5533	68.5533	67.8	68.26	847200.0
2005-12-23	BCM	ETF	66.43	66.51	66.0	66.32	39300.0
2005-12-23	BITS	ETF	14.0	15.2	14.0	14.7816	12047.0
2005-12-23	BKF	ETF	20.19	20.65	20.19	20.6	17500.0
2005-12-23	BNE	ETF	15.1	15.16	15.02	15.06	48100.0
2005-12-23	BOSS	ETF	30.07	30.07	30.07	30.07	200.0
2005-12-23	BRF	ETF	15.01	15.18	14.97	15.18	8900.0
2005-12-23	BTF	ETF	85.0	85.07999999999998	85.0	85.05	480.0
2005-12-23	CBON	ETF	32.38	32.44	32.0	32.06	8339.0
2005-12-23	CDL	ETF	12.95	13.21	12.94	13.17	200400.0
2005-12-23	CEF	ETF	6.33	6.41	6.33	6.39	385400.0
2005-12-23	CFO	ETF	10.0	10.0	10.0	10.0	900.0
2005-12-23	CGO	ETF	13.87	13.93	13.6	13.6	61800.0
2005-12-23	CHB	ETF	14.21	14.36	13.92	14.05	203100.0
2005-12-23	CHI	ETF	20.25	20.4	20.22	20.26	49200.0
2005-12-23	CHIC	ETF	19.55	20.2	19.55	19.92	109850.0
2005-12-23	CHIR	ETF	44.8899	44.8899	44.5599	44.6199	392730.0
2005-12-23	CHY	ETF	15.95	16.04	15.8272	16.03	80200.0
2005-12-23	CN	ETF	32.74	32.74	32.25	32.4	43800.0
2005-12-23	CNXT	ETF	2.39	2.39	2.31	2.33	4422366.0
2005-12-23	CPI	ETF	27.75	27.75	27.75	27.75	200.0
2005-12-23	CPST	ETF	3.055	3.14	3.03	3.06	1251388.0
2005-12-23	CSA	ETF	16.78	17.06	16.78	16.92	18700.0
2005-12-23	CSB	ETF	31.58	31.65	31.45	31.6	11000.0
2005-12-23	CSM	ETF	2.45	2.45	2.45	2.45	8000.0
2005-12-23	CSQ	ETF	13.31	13.43	13.26	13.43	537500.0
2005-12-23	CTEC	ETF	47.599999999999994	48.449999999999996	47.05	48.099999999999994	9615.4
2005-12-23	CURE	ETF	0.04	0.04	0.0361	0.0387	5900864.0
2005-12-23	CYB	ETF	3.5499	3.5499	3.53	3.53	1600.0
2005-12-23	DGT	ETF	65.63	65.67	65.56	65.67	3300.0
2005-12-23	DIG	ETF	15.6375	15.6375	15.6375	15.6375	240.0
2005-12-23	DIV	ETF	11.95	12.01	11.94	12.01	28400.0
2005-12-23	DRIV	ETF	30.86	31.02	30.43	30.64	562620.0
2005-12-23	DSI	ETF	6.065	6.065	6.065	6.065	4400.0

> showing 50 of 297 rows — these rows as CSV

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