with to_address as (

select

to_address as address

,contract_address

,symbol

,sum(amount_precise) as tokens_received

from kaia.core.ez_token_transfers

where contract_address = '{{token_address}}'

group by 1, 2, 3

),

from_address as (

select

from_address as address

,contract_address

,symbol

,sum(amount_precise) as tokens_lost

from kaia.core.ez_token_transfers

where contract_address = '{{token_address}}'

group by 1, 2, 3

),

holders as (

select

address

,contract_address

,symbol

,sum(coalesce (tokens_received, 0) - coalesce(tokens_lost, 0)) as current_holdings

from to_address

left join from_address using (address)

group by 1, 2, 3