PREVIEW / etf_daily / 2005-11-17

all etf daily files

  file:    by_date/etf_daily/2005/2005-11-17.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-17	SPY	ETF	123.68	124.65	123.14	124.64	55717500.0
2005-11-17	QQQ	ETF	40.91	41.32	40.85	41.307	94448324.0
2005-11-17	IWM	ETF	65.43	66.41	65.42	66.38	22203100.0
2005-11-17	DIA	ETF	107.14	107.48	106.86	107.38	5314800.0
2005-11-17	GLD	ETF	48.23	48.58	48.17	48.48	4172400.0
2005-11-17	TLT	ETF	90.17	90.9	90.05	90.56	1003100.0
2005-11-17	AAA	ETF	52.67	52.84	52.61	52.84	2300.0
2005-11-17	ADRE	ETF	108.74	110.2799	108.74	110.183	20936.0
2005-11-17	AFK	ETF	25.45	25.48	25.4	25.4	9100.0
2005-11-17	AGG	ETF	100.23	100.46	100.02	100.15	274600.0
2005-11-17	AIQ	ETF	23.6	26.25	23.6	26.25	76220.0
2005-11-17	AIS	ETF	1.16	1.17	1.13	1.16	77100.0
2005-11-17	AOM	ETF	3.67	3.67	3.57	3.65	8500.0
2005-11-17	ARB	ETF	38.05	38.81	38.05	38.6	129800.0
2005-11-17	BAB	ETF	54.51	54.97	54.27	54.96	79900.0
2005-11-17	BBC	ETF	6.35	6.71	6.35	6.71	74600.0
2005-11-17	BBH	ETF	68.97	69.98	68.6667	69.98	1725000.0
2005-11-17	BCM	ETF	62.96	63.4	62.87	62.9	43400.0
2005-11-17	BITS	ETF	14.276	14.4	13.68	14.28	8657.0
2005-11-17	BKF	ETF	21.75	21.75	21.5	21.66	91100.0
2005-11-17	BNE	ETF	15.25	15.5	15.15	15.2	201400.0
2005-11-17	BRF	ETF	15.1	15.1	15.0	15.06	13600.0
2005-11-17	BTF	ETF	87.5	87.94999999999999	87.44999999999999	87.5	1400.0
2005-11-17	CBON	ETF	33.01	33.2	32.85	33.0	18539.0
2005-11-17	CDL	ETF	13.41	13.78	13.36	13.77	269200.0
2005-11-17	CEF	ETF	6.0	6.02	5.94	5.99	467700.0
2005-11-17	CEW	ETF	25.71	25.71	25.71	25.71	1600.0
2005-11-17	CGO	ETF	15.0	15.01	15.0	15.0	18800.0
2005-11-17	CHB	ETF	14.54	14.97	14.5	14.76	708100.0
2005-11-17	CHI	ETF	19.9	20.11	19.85	19.91	122200.0
2005-11-17	CHIC	ETF	17.07	17.38	16.87	17.35	313144.0
2005-11-17	CHIR	ETF	44.16	44.2899	44.1501	44.28	1721097.0
2005-11-17	CHY	ETF	15.62	15.67	15.5001	15.56	97900.0
2005-11-17	CIL	ETF	26.07	26.07	26.03	26.03	1500.0
2005-11-17	CN	ETF	33.49	33.72	33.42	33.68	3600.0
2005-11-17	CNXT	ETF	2.19	2.2501	2.15	2.24	5544451.0
2005-11-17	COMB	ETF	8.25	8.4	8.25	8.4	700.0
2005-11-17	CPI	ETF	25.5	25.5	25.5	25.5	300.0
2005-11-17	CPST	ETF	3.69	4.02	3.55	3.82	20317261.0
2005-11-17	CSA	ETF	17.0	17.05	17.0	17.0	22700.0
2005-11-17	CSB	ETF	28.32	28.4	28.0601	28.31	15500.0
2005-11-17	CSM	ETF	2.4325	2.4325	2.4325	2.4325	2000.0
2005-11-17	CSQ	ETF	13.04	13.13	12.93	13.01	611400.0
2005-11-17	CTEC	ETF	43.15	43.25	42.35	42.5	5795.0
2005-11-17	CURE	ETF	0.0625	0.0663	0.06	0.0638	2035664.0
2005-11-17	CYB	ETF	3.46	3.55	3.46	3.46	4300.0
2005-11-17	DGT	ETF	64.5	64.65	64.5	64.65	2300.0
2005-11-17	DIG	ETF	14.5	14.75	14.475	14.75	20880.0
2005-11-17	DIV	ETF	11.8	11.86	11.79	11.84	38500.0
2005-11-17	DRIV	ETF	24.42	24.68	23.86	24.68	741331.0

> showing 50 of 292 rows — these rows as CSV

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