SELECT

TO_ADDRESS,

SUM(AMOUNT) AS amount_in

FROM base.core.ez_token_transfers

WHERE CONTRACT_ADDRESS = '0xf5bc3439f53a45607ccad667abc7daf5a583633f'

AND TO_ADDRESS NOT IN (

'0xc15dbc29e669d9ee4480af3d643bdca77178a976', -- Main token contract

'0xc7193e127166637db955c03593e1b04ac1de77d1', -- Token Deployer Contract

'0x0d0707963952f2fba59dd06f2b425ace40b492fe', -- Gate.io Hot Wallet

'0x5063022bf21eadbadc9eba91fb008eb3ca33a165', -- APGN License NFT Wallet

'0x66fe87f0673a100c37c628c0e01752092da35899', -- Proxy Wallet

'0xf8bb13359c402f399b152ca5df7a8b00ec2a6dee', -- Uniswap Pool

'0x1ff8d3277d1d1e708e93e45a1732f09167387c55' -- Contract created by AgentLayer deployer

)

GROUP BY TO_ADDRESS

),

outflows AS (

SELECT

FROM_ADDRESS,

SUM(AMOUNT) AS amount_out

FROM base.core.ez_token_transfers

WHERE CONTRACT_ADDRESS = '0xf5bc3439f53a45607ccad667abc7daf5a583633f'

AND FROM_ADDRESS NOT IN (

'0xc15dbc29e669d9ee4480af3d643bdca77178a976', -- Main token contract

'0xc7193e127166637db955c03593e1b04ac1de77d1', -- Token Deployer Contract

'0x0d0707963952f2fba59dd06f2b425ace40b492fe', -- Gate.io Hot Wallet

'0x5063022bf21eadbadc9eba91fb008eb3ca33a165', -- APGN License NFT Wallet

'0x66fe87f0673a100c37c628c0e01752092da35899', -- Proxy Wallet

'0xf8bb13359c402f399b152ca5df7a8b00ec2a6dee', -- Uniswap Pool

'0x1ff8d3277d1d1e708e93e45a1732f09167387c55' -- Contract created by AgentLayer deployer

)

GROUP BY FROM_ADDRESS

SELECT

COALESCE(inflows.TO_ADDRESS, outflows.FROM_ADDRESS) AS wallet,