SELECT

swapper AS TopTraderSolana,

SUM(swap_from_amount_usd) AS TotalSwappedVolumeSolana,

ROW_NUMBER() OVER (ORDER BY SUM(swap_from_amount_usd) DESC) AS Rank

FROM

solana.defi.ez_dex_swaps

WHERE

block_timestamp BETWEEN '2024-10-01' AND '2024-10-31'

AND swap_from_amount_usd IS NOT NULL

GROUP BY

swapper

),

EthereumTopTraders AS (

SELECT

origin_from_address AS TopTraderEthereum,

SUM(amount_in_usd) AS TotalSwappedVolumeEthereum,

ROW_NUMBER() OVER (ORDER BY SUM(amount_in_usd) DESC) AS Rank

FROM

ethereum.defi.ez_dex_swaps

WHERE

block_timestamp BETWEEN '2024-10-01' AND '2024-10-31'

AND amount_in_usd IS NOT NULL

GROUP BY

origin_from_address

SELECT

S.TopTraderSolana,

S.TotalSwappedVolumeSolana,

E.TopTraderEthereum,

E.TotalSwappedVolumeEthereum

FROM

SolanaTopTraders S

FULL OUTER JOIN

EthereumTopTraders E ON S.Rank = E.Rank