SELECT

SUM(amount_usd) AS usd_amount, symbol

FROM ethereum.core.ez_token_transfers

WHERE to_address = lower('0xD13206d94275200E90827069702D1a9f59fb4c5f')

GROUP BY symbol

),

eth_transfers AS (

SELECT

SUM(amount_usd) AS usd_amount, 'ETH' as symbol

FROM ethereum.core.ez_eth_transfers

WHERE eth_to_address = lower('0xD13206d94275200E90827069702D1a9f59fb4c5f')

GROUP BY symbol

),

bsc_transfers as (

SELECT

SUM(amount) AS usd_amount, t.symbol

FROM bsc.core.ez_token_transfers t

WHERE to_address = lower('0xD13206d94275200E90827069702D1a9f59fb4c5f')

GROUP BY t.symbol

),

price as (

SELECT price

FROM bsc.price.ez_hourly_token_prices

WHERE symbol = 'WBNB'

ORDER BY hour DESC

LIMIT 1

),

bnb_transfers as (

SELECT

SUM(amount * price) AS usd_amount,

'BNB' as symbol

FROM bsc.core.ez_bnb_transfers, price

WHERE bnb_to_address = lower('0xD13206d94275200E90827069702D1a9f59fb4c5f')

GROUP BY symbol

),