SELECT

token_address,

symbol,

decimals,

avg_price_usd

FROM

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

),

UserTransfers AS (

SELECT

ACCOUNT_ADDRESS,

INFLOW_AMOUNT,

OUTFLOW_AMOUNT,

NETFLOW_AMOUNT,

TOKEN_ADDRESS

FROM

$query('bcb0a7d3-612f-4e13-9cdc-835fb48b153a')

SELECT

ut.ACCOUNT_ADDRESS,

ut.NETFLOW_AMOUNT,

ut. INFLOW_AMOUNT,

ut.OUTFLOW_AMOUNT,

ut.TOKEN_ADDRESS,

tp.symbol,

tp.decimals,

tp.avg_price_usd,

(ut.INFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd AS inflow_amount_usd,

(ut.OUTFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd AS outflow_amount_usd,

(ut.NETFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd AS netflow_amount_usd

FROM

UserTransfers ut

JOIN

token_price_and_decimal tp

ON