PREVIEW / etf_daily / 2005-11-23

all etf daily files

  file:    by_date/etf_daily/2005/2005-11-23.parquet
  size:    16 KB
  rows:    292

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-11-23	SPY	ETF	126.25	127.41	126.21	127.03	50854700.0
2005-11-23	QQQ	ETF	41.73	42.02	41.71	41.8	64101105.0
2005-11-23	IWM	ETF	67.8	68.35	67.77	68.01	21290900.0
2005-11-23	DIA	ETF	108.42	109.46	108.42	109.18	5402800.0
2005-11-23	GLD	ETF	48.8	49.25	48.24	49.15	1731700.0
2005-11-23	TLT	ETF	90.59	90.69	89.86	90.18	768300.0
2005-11-23	AAA	ETF	53.38	53.63	53.056	53.63	2900.0
2005-11-23	ADRE	ETF	111.4	112.22	110.8001	111.652	68968.0
2005-11-23	AFK	ETF	25.35	25.42	25.33	25.42	4700.0
2005-11-23	AGG	ETF	100.74	100.77	100.37	100.62	230400.0
2005-11-23	AIQ	ETF	27.75	28.6	27.4	28.35	6400.0
2005-11-23	AIS	ETF	1.19	1.21	1.15	1.19	92400.0
2005-11-23	AOM	ETF	3.47	3.47	3.43	3.43	15100.0
2005-11-23	ARB	ETF	39.0	39.26	38.95	39.02	65500.0
2005-11-23	BAB	ETF	53.05	53.85	53.05	53.82	55200.0
2005-11-23	BBC	ETF	9.25	9.5	8.85	8.92	214700.0
2005-11-23	BBH	ETF	70.2233	70.3333	69.7333	70.2067	1482000.0
2005-11-23	BCM	ETF	64.33	64.79	64.28	64.79	17200.0
2005-11-23	BITS	ETF	13.92	14.08	13.796	14.0	5848.0
2005-11-23	BKF	ETF	21.13	22.78	20.65	22.31	98700.0
2005-11-23	BNE	ETF	15.45	15.59	15.4	15.46	43000.0
2005-11-23	BRF	ETF	15.15	15.19	15.15	15.18	4100.0
2005-11-23	BTF	ETF	88.14999999999999	88.49999999999999	88.0	88.35000000000001	1880.0
2005-11-23	CBON	ETF	33.05	33.2	33.05	33.2	10779.0
2005-11-23	CDL	ETF	13.72	13.9	13.72	13.82	480000.0
2005-11-23	CEF	ETF	6.08	6.15	6.0	6.14	754700.0
2005-11-23	CEW	ETF	25.9	25.9	25.9	25.9	100.0
2005-11-23	CGO	ETF	13.85	13.85	13.25	13.45	54600.0
2005-11-23	CHB	ETF	15.06	15.19	14.93	14.96	411700.0
2005-11-23	CHI	ETF	19.88	19.97	19.82	19.85	104300.0
2005-11-23	CHIC	ETF	17.7	18.05	17.5	17.74	150266.0
2005-11-23	CHIR	ETF	44.31	44.55	44.31	44.5401	1103369.0
2005-11-23	CHY	ETF	15.66	15.66	15.46	15.5	111600.0
2005-11-23	CIL	ETF	26.09	26.09	26.09	26.09	700.0
2005-11-23	CIZ	ETF	21.58	21.6	21.58	21.6	500.0
2005-11-23	CN	ETF	33.33	33.33	33.13	33.32	11300.0
2005-11-23	CNXT	ETF	2.53	2.5501	2.4	2.41	17845302.0
2005-11-23	COMB	ETF	8.6475	8.65	8.6475	8.65	5450.0
2005-11-23	CPI	ETF	25.8	26.0	25.8	26.0	300.0
2005-11-23	CPST	ETF	3.85	3.89	3.77	3.81	3769342.0
2005-11-23	CSA	ETF	16.95	17.0	16.92	16.95	15100.0
2005-11-23	CSB	ETF	28.8	28.88	28.46	28.64	11900.0
2005-11-23	CSM	ETF	2.4325	2.4325	2.4325	2.4325	9200.0
2005-11-23	CSQ	ETF	13.08	13.19	13.02	13.18	429500.0
2005-11-23	CTEC	ETF	44.025	46.8	44.025	46.65	17924.0
2005-11-23	CURE	ETF	0.0725	0.0838	0.07	0.0813	3058152.0
2005-11-23	CYB	ETF	3.7	3.7	3.65	3.65	1200.0
2005-11-23	DGT	ETF	65.83	66.15	65.83	65.93	22600.0
2005-11-23	DIG	ETF	15.0	15.0125	15.0	15.0	960.0
2005-11-23	DIV	ETF	11.95	12.0	11.91	11.99	19000.0

> showing 50 of 292 rows — these rows as CSV

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