select depositor, amount, amount_usd, platform, block_timestamp, 'arbitrum' as chain from arbitrum.defi.ez_lending_deposits

union all

select depositor, amount, amount_usd, platform, block_timestamp, 'base' as chain from base.defi.ez_lending_deposits

union all

select depositor, amount, amount_usd, platform, block_timestamp, 'avalanche' as chain from avalanche.defi.ez_lending_deposits

union all

select depositor, amount, amount_usd, platform, block_timestamp, 'bsc' as chain from bsc.defi.ez_lending_deposits

union all

select depositor, amount, amount_usd, platform, block_timestamp, 'ethereum' as chain from ethereum.defi.ez_lending_deposits

union all

select depositor, amount, amount_usd, platform, block_timestamp, 'optimism' as chain from optimism.defi.ez_lending_deposits

union all

select depositor, amount, amount_usd, platform, block_timestamp, 'polygon' as chain from polygon.defi.ez_lending_deposits)

, final as (

select sum(coalesce(amount_usd,0)) as value, depositor, chain, platform

from depositors

where block_timestamp > current_date - {{dayscope}}

group by depositor, chain, platform)

select * from final

order by value desc

limit 50000