SELECT CASE WHEN pool_name = 'STETH-WETH LP' THEN 'stETH-WETH LP'
WHEN pool_name = 'stETH-WETH LP' THEN 'stETH-WETH LP'
WHEN pool_name = '0xdc24316b9ae028f1497c275eb9192a3ea0f67022' THEN 'Lido: Curve Liquidity Farming Pool Contract'
END as pool_names,
pool_address,
CASE WHEN direction = 'IN' THEN 'swap from stETH'
WHEN direction = 'OUT' THEN 'swap for stETH'
END as swap,
platform,
count(tx_id) as n_swaps
FROM ethereum.dex_swaps
WHERE token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
GROUP BY pool_names,platform,swap,pool_address
ORDER BY n_swaps DESC