SELECT

tx.TX_HASH,

tx.block_timestamp as block_timestamp,

tr.to_Address as ua,

RAW_AMOUNT/pow(10,18) as amount

FROM

blast.core.fact_transactions tx

INNER join blast.core.fact_token_transfers tr on tx.tx_hash = tr.tx_hash

and tr.contract_address = lower('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')

and tx.to_Address = '0xf7be503166828fe8565c520d66645ac6a06bbdd7'

and tx.ORIGIN_FUNCTION_SIGNATURE != '0xca1d209d'

WHERE

tx.status = 'SUCCESS'

),

now_balance as (

SELECT

ua,

sum(am) as current_balance

FROM

(

SELECT

from_Address as ua,

- amount as am

FROM

blast.core.ez_token_transfers

WHERE

contract_address = lower('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')

union

all

SELECT

to_Address as ua,

amount as am

FROM

blast.core.ez_token_transfers

WHERE