WITH eth_vol AS (
SELECT sum(AMOUNT_USD) as eth_usd
FROM ethereum.core.ez_eth_transfers
WHERE ORIGIN_TO_ADDRESS = lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1')
),
token_vol AS (
SELECT sum(AMOUNT_USD) as token_usd
FROM ethereum.core.ez_token_transfers
WHERE ORIGIN_TO_ADDRESS = lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1')
)
SELECT eth_usd+token_usd as totalusd_vol
FROM eth_vol FULL JOIN token_vol