select

date(block_timestamp) as date,

trf.CONTRACT_ADDRESS as token_contract_address,

trf.TX_HASH as transaction_hash,

trf.FROM_ADDRESS as "from",

trf.TO_ADDRESS as "to",

cast(trf. RAW_AMOUNT as double) as value

from base.core.fact_token_transfers trf

where 1=1

--trf.{{topics_length_column}} = 3

and trf.CONTRACT_ADDRESS in

('0x833589fcd6edb6e08f4c7c32d4f71b54bda02913',

),

transfer_in as (

select

date,

token_contract_address,

transaction_hash,

"to" as address,

sum(cast(value as double)) as amount_in

from transfers

-- AND cast(value as double) > 0

group by 1,2,3,4

),

transfer_out as (

select

date,

token_contract_address,

transaction_hash,

"from" as address,

sum(cast(value as double)) as amount_out