PREVIEW / etf_daily / 2005-11-18

all etf daily files

  file:    by_date/etf_daily/2005/2005-11-18.parquet
  size:    16 KB
  rows:    295

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-18	SPY	ETF	125.06	125.28	124.33	125.13	72437200.0
2005-11-18	QQQ	ETF	41.51	41.651	41.0253	41.45	108820140.0
2005-11-18	IWM	ETF	66.63	67.08	66.37	66.89	28896800.0
2005-11-18	DIA	ETF	107.57	107.7	106.9	107.53	8014000.0
2005-11-18	GLD	ETF	48.5	48.61	48.2	48.46	1453800.0
2005-11-18	TLT	ETF	90.37	90.45	90.06	90.14	734200.0
2005-11-18	AAA	ETF	53.0	53.0	52.57	52.98	6700.0
2005-11-18	ADRE	ETF	109.76	110.6715	109.5	109.8555	64528.0
2005-11-18	AFK	ETF	25.39	25.44	25.38	25.44	4700.0
2005-11-18	AGG	ETF	100.33	100.4	99.97	100.11	127300.0
2005-11-18	AIQ	ETF	27.25	28.55	26.8	27.9	38120.0
2005-11-18	AIS	ETF	1.18	1.21	1.14	1.19	94300.0
2005-11-18	AOM	ETF	3.7	3.7	3.54	3.54	13200.0
2005-11-18	ARB	ETF	39.0	39.27	38.75	39.11	179800.0
2005-11-18	BAB	ETF	54.89	55.07	53.67	54.32	86700.0
2005-11-18	BBC	ETF	6.68	7.95	6.68	7.34	208900.0
2005-11-18	BBH	ETF	70.0033	70.6433	69.62	69.9267	1401600.0
2005-11-18	BCM	ETF	63.0	63.09	62.62	62.73	17700.0
2005-11-18	BITS	ETF	14.16	14.52	13.76	14.32	7478.0
2005-11-18	BKF	ETF	21.76	21.82	21.55	21.68	45900.0
2005-11-18	BNE	ETF	15.38	15.49	15.13	15.38	122000.0
2005-11-18	BRF	ETF	15.09	15.15	15.09	15.15	2400.0
2005-11-18	BTF	ETF	87.69999999999999	87.69999999999999	87.55	87.6	160.0
2005-11-18	CBON	ETF	33.1	33.19	32.53	32.81	12012.0
2005-11-18	CDL	ETF	13.89	13.89	13.48	13.55	513900.0
2005-11-18	CEF	ETF	6.0	6.0	5.92	5.95	344200.0
2005-11-18	CEW	ETF	25.75	25.87	25.75	25.87	4900.0
2005-11-18	CGO	ETF	15.0	15.01	15.0	15.0	21000.0
2005-11-18	CHB	ETF	15.5	15.55	14.9	15.0	746600.0
2005-11-18	CHI	ETF	19.97	20.03	19.9	20.03	81200.0
2005-11-18	CHIC	ETF	17.44	17.48	16.77	17.06	103717.0
2005-11-18	CHIR	ETF	44.6001	44.64	44.1999	44.3499	1691922.0
2005-11-18	CHY	ETF	15.46	15.63	15.46	15.63	84100.0
2005-11-18	CIL	ETF	26.03	26.03	26.03	26.03	1400.0
2005-11-18	CN	ETF	33.65	33.74	33.55	33.62	9500.0
2005-11-18	CNXT	ETF	2.29	2.3701	2.28	2.37	9974167.0
2005-11-18	CPI	ETF	25.5	25.51	25.5	25.51	300.0
2005-11-18	CPST	ETF	3.76	3.81	3.65	3.65	7388283.0
2005-11-18	CSA	ETF	16.99	17.0	16.75	16.75	66900.0
2005-11-18	CSB	ETF	28.35	28.6	28.34	28.42	8800.0
2005-11-18	CSQ	ETF	13.0	13.31	13.0	13.25	539200.0
2005-11-18	CTEC	ETF	42.199999999999996	44.5	42.199999999999996	43.75	11096.2
2005-11-18	CURE	ETF	0.0688	0.0688	0.0612	0.0688	2091600.0
2005-11-18	CYB	ETF	3.5	3.55	3.5	3.5	10300.0
2005-11-18	DGT	ETF	64.85	64.99	64.85	64.99	800.0
2005-11-18	DIG	ETF	14.5875	14.725	14.5875	14.6	6080.0
2005-11-18	DIV	ETF	11.81	11.89	11.79	11.88	14900.0
2005-11-18	DRIV	ETF	24.88	26.39	24.5	26.21	1882829.0
2005-11-18	DSI	ETF	5.995	5.995	5.885	5.885	10000.0
2005-11-18	DUSA	ETF	9.67	9.9	9.48	9.81	71074.0

> showing 50 of 295 rows — these rows as CSV

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