'PAXG' AS token,

sum(current_bal) as total_supply,

sum(current_bal* price) as market_cap

from ethereum.core.ez_current_balances a join ethereum.core.fact_hourly_token_prices b on a.CONTRACT_ADDRESS = B.TOKEN_ADDRESS and a.LAST_ACTIVITY_BLOCK_TIMESTAMP::date = b.hour::date

where CONTRACT_ADDRESS='0x45804880de22913dafe09f4980848ece6ecbaf78'

group by 1

union

select

'XAUt' AS token,

sum(current_bal) as total_supply,

sum(current_bal* price) as market_cap

from ethereum.core.ez_current_balances a join ethereum.core.fact_hourly_token_prices b on a.CONTRACT_ADDRESS = B.TOKEN_ADDRESS and a.LAST_ACTIVITY_BLOCK_TIMESTAMP::date = b.hour::date

where CONTRACT_ADDRESS='0x68749665ff8d2d112fa859aa293f07a622782f38'

group by 1