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