SELECT

token_address,

symbol,

decimals,

avg_price_usd

FROM

$query('eb8c7a0a-f771-4e55-9140-8aeb5f2e7c45')

),

UserTransfers AS (

SELECT

ACCOUNT_ADDRESS,

TOTAL_AMOUNT,

TOKEN_ADDRESS

FROM

$query('c107a7d2-1167-45ff-91ea-c364bab2b5c8')

SELECT

ut.ACCOUNT_ADDRESS,

ut.TOTAL_AMOUNT,

ut.TOKEN_ADDRESS,

tp.symbol,

tp.decimals,

tp.avg_price_usd,

(ut.TOTAL_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd AS amount_usd

FROM

UserTransfers ut

JOIN

token_price_and_decimal tp

ON

ut.TOKEN_ADDRESS = tp.token_address;