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,

tp.symbol,

ROUND(SUM((ut.NETFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd), 2) AS total_netflow_usd

FROM

UserTransfers ut

JOIN

token_price_and_decimal tp

ON

ut.TOKEN_ADDRESS = tp.token_address

WHERE

tp.symbol = 'APT'

GROUP BY

ut.ACCOUNT_ADDRESS, tp.symbol

HAVING

SUM((ut.NETFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd) IS NOT NULL

ORDER BY