Query: defillama yields by Paulo Sousa

select *
from @defillama.yields.overview_yields
order by data_obtained_at desc
limit 10

data_obtained_at	pool	chain	project	symbol	tvlusd	apybase	apyreward	apy	rewardtokens	apypct1d	apypct7d	apypct30d	stablecoin	ilrisk	exposure	predictions	poolmeta	mu	sigma	count	outlier	underlyingtokens	il7d	apybase7d	apymean30d	volumeusd1d	volumeusd7d	apybaseinception	year	month	day
2025-04-30 06:00:04.53239+00	747c1d2a-c668-4682-b9f9-296708a3dd90	Ethereum	lido	STETH	16677240503	2.825	null	2.825	None	0.12	0.011	0.06	false	no	single	{'predictedClass': 'Stable/Up', 'predictedProbability': 75, 'binnedConfidence': 2}	null	3.84583	0.05235	1065	false	['0x0000000000000000000000000000000000000000']	null	null	3.01637	null	null	null	2025	4	30
2025-04-30 06:00:04.53239+00	46bd2bdf-6d92-4066-b482-e885ee172264	Ethereum	ether.fi-stake	WEETH	4055631405	3.35094	0.53245	3.88339	['0x8F08B70456eb22f6109F57b8fafE862ED28E6040']	0.09001	0.00245	0.20441	false	no	single	{'predictedClass': 'Stable/Up', 'predictedProbability': 51, 'binnedConfidence': 1}	null	3.27124	0.04462	330	false	['0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2']	null	3.09876	3.7477	null	null	null	2025	4	30
2025-04-30 06:00:04.53239+00	80b8bf92-b953-4c20-98ea-c9653ef2bb98	Ethereum	binance-staked-eth	WBETH	3662214769	2.53347	null	2.53347	None	-0.05986	-0.09161	-0.08833	false	no	single	{'predictedClass': 'Stable/Up', 'predictedProbability': 64, 'binnedConfidence': 2}	null	3.22712	0.03133	683	false	['0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2']	null	null	2.87476	null	null	null	2025	4	30
2025-04-30 06:00:04.53239+00	7e382157-b1bc-406d-b17b-facba43b716e	Ethereum	aave-v3	WBTC	3599005400	0.02465	null	0.02465	None	-0.00021	-0.0013	-0.00121	false	no	single	{'predictedClass': 'Stable/Up', 'predictedProbability': 83, 'binnedConfidence': 3}	null	0.10141	0.00657	812	false	['0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599']	null	null	0.02411	null	null	null	2025	4	30
2025-04-30 06:00:04.53239+00	d8c4eff5-c8a9-46fc-a888-057c4c668e72	Ethereum	sky-lending	SUSDS	2975330047	null	null	4.5	None	0	0	0	true	no	single	{'predictedClass': 'Stable/Up', 'predictedProbability': 60, 'binnedConfidence': 1}	null	5.48971	0.05921	69	false	['0xdC035D45d973E3EC169d2276DDab16f1e407384F']	null	null	4.5	null	null	null	2025	4	30
2025-04-30 06:00:04.53239+00	db678df9-3281-4bc2-a8bb-01160ffd6d48	Ethereum	aave-v3	WEETH	2851521305	0.00063	null	0.00063	None	0.00001	-0.00001	-0.00011	false	no	single	{'predictedClass': 'Stable/Up', 'predictedProbability': 84, 'binnedConfidence': 3}	null	0.0921	0.00862	382	false	['0xCd5fE23C85820F7B72D0926FC9b05b43E359b7ee']	null	null	0.00065	null	null	null	2025	4	30
2025-04-30 06:00:04.53239+00	0e7d0722-9054-4907-8593-567b353c0900	Solana	jito-liquid-staking	JITOSOL	2576916153	9.14	null	9.14	None	0.01	1.39	0.88	false	no	single	{'predictedClass': 'Stable/Up', 'predictedProbability': 74, 'binnedConfidence': 2}	null	8.02712	0.02513	36	false	['J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn']	null	null	7.96596	null	null	null	2025	4	30
2025-04-30 06:00:04.53239+00	d4b3c522-6127-4b89-bedf-83641cdcd2eb	Ethereum	rocket-pool	RETH	2389641717	2.57234	null	2.57234	None	0.02365	-0.04932	-0.39892	false	no	single	{'predictedClass': 'Stable/Up', 'predictedProbability': 68, 'binnedConfidence': 2}	null	3.22751	0.03783	833	false	['0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2']	null	null	2.67871	null	null	null	2025	4	30
2025-04-30 06:00:04.53239+00	e6435aae-cbe9-4d26-ab2c-a4d533db9972	Ethereum	aave-v3	WSTETH	2319843645	0.08689	null	0.08689	None	0.00085	0.00215	-0.02218	false	no	single	{'predictedClass': 'Stable/Up', 'predictedProbability': 60, 'binnedConfidence': 1}	null	0.02968	0.00271	812	false	['0x7f39C581F595B53c5cb19bD0b3f8dA6c935E2Ca0']	null	null	0.09276	null	null	null	2025	4	30
2025-04-30 06:00:04.53239+00	66985a81-9c51-46ca-9977-42b4fe7bc6df	Ethereum	ethena-usde	SUSDE	2107507880	4.47675	null	4.47675	None	-0.00137	-0.12657	-6.33266	true	no	single	{'predictedClass': 'Stable/Up', 'predictedProbability': 86, 'binnedConfidence': 3}	7 days unstaking	14.03412	0.42514	438	false	None	null	null	5.34061	null	null	null	2025	4	30