COUNT(tx_hash) AS total_trades,

COUNT(CASE WHEN amount_out_usd > amount_in_usd THEN 1 END) AS winning_trades,

(COUNT(CASE WHEN amount_out_usd > amount_in_usd THEN 1 END) * 100.0 / COUNT(*)) AS win_rate_percentage,

(MAX(amount_in_usd) - MIN(amount_in_usd)) AS trade_win_margin

FROM

ethereum.defi.ez_dex_swaps

WHERE

origin_from_address = '{{wallet_address}}'

AND event_name = 'Swap'

AND DATE(block_timestamp) >= '2024-01-01'

AND DATE(block_timestamp) < '2025-01-01';