select

TO_ADDRESS

,sum(VALUE) as claim_mond_from_dev_faucet

from monad.testnet.fact_transactions

where FROM_ADDRESS = lower('0xe081Ffe3b3AD41DfDC7179159D73b7CfFc52B8fF')

group by 1

),

raw_transaction as (

select

TX_HASH

,BLOCK_TIMESTAMP

,VALUE * -1 as VALUE

,FROM_ADDRESS as wallet

from monad.testnet.fact_traces

where FROM_ADDRESS in (select TO_ADDRESS from monad_dev_wallet group by 1)

and TX_SUCCEEDED

and TYPE = 'CALL' -- 只选择 call 类型的交易

and VALUE > 0 -- 确保有价值转移

union all

select

TX_HASH

,BLOCK_TIMESTAMP

,VALUE

,TO_ADDRESS as wallet

from monad.testnet.fact_traces

where TO_ADDRESS in (select TO_ADDRESS from monad_dev_wallet group by 1)

and TX_SUCCEEDED

and TYPE = 'CALL' -- 只选择 call 类型的交易

and VALUE > 0 -- 确保有价值转移