SELECT

transfers.to_address AS wallet_address,

SUM(transfers.raw_amount) / POWER(10, contracts.decimals) AS total_inflow,

CONCAT('https://debank.com/profile/', transfers.to_address) AS debank_profile

FROM

arbitrum.core.fact_token_transfers transfers

INNER JOIN arbitrum.core.dim_contracts contracts ON transfers.contract_address = contracts.address

AND transfers.contract_address = LOWER('{{token_address}}')

WHERE

transfers.block_timestamp BETWEEN '{{start_date}}' AND '{{end_date}}'

AND NOT EXISTS (

SELECT

1

FROM

crosschain.core.address_labels crosschain_addresses

WHERE

crosschain_addresses.blockchain = 'arbitrum'

AND crosschain_addresses.address = transfers.to_address

)

AND NOT EXISTS (

SELECT

1

FROM arbitrum.core.dim_labels labels

WHERE

labels.address = transfers.to_address

)

AND NOT EXISTS (

SELECT

1

FROM arbitrum.core.dim_contracts dim_contracts

WHERE

dim_contracts.address = transfers.to_address

)

AND NOT EXISTS (

SELECT