token_transfers AS (

select

block_timestamp,

tx_hash,

contract_address,

contract_name,

decoded_log,

COALESCE(

decoded_log :from :: STRING,

decoded_log :src :: STRING

) AS from_address,

COALESCE(

decoded_log :to :: STRING,

decoded_log :dst :: STRING

) AS to_address,

COALESCE(

decoded_log :value :: DOUBLE,

decoded_log :wad :: DOUBLE,

decoded_log :amount :: DOUBLE

) AS transfer_value

from

berachain.testnet.ez_decoded_event_logs l

where l.block_timestamp >= sysdate() - interval '8 days'

and event_name in ('Deposit', 'Transfer')

and lower(contract_address) in (

lower('0x6e1e9896e93f7a71ecb33d4386b49deed67a231a'),

lower('0x767230a157d9a419d1bea97e0e37f9d2668f6b08'),

lower('0x7507c1dc16935B82698e4C63f2746A2fCf994dF8')

)

date_trunc('day', block_timestamp) as _date,

contract_address,

contract_name,

count(distinct tx_hash) as transfer_count,