case when CONTRACT_ADDRESS = '0x924f1bf31b19a7f9695f3fc6c69c2ba668ea4a0a' then 'USDC' else 'USDT'

end as token,

sum(CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e6) AS amount,

count( distinct ORIGIN_FROM_ADDRESS) as users,

count(distinct TX_HASH) as txs

from monad.testnet.fact_event_logs

where --tx_hash = '0x5003f064fdcedfce235f5dfe1a7b6b3c6b0bb8365e2348e7e9b38793a0b3ec2a'

ORIGIN_FUNCTION_SIGNATURE = '0x32f289cf'

and CONTRACT_ADDRESS in ('0x924f1bf31b19a7f9695f3fc6c69c2ba668ea4a0a','0x9ebcd0ab11d930964f8ad66425758e65c53a7df1')

and ORIGIN_TO_ADDRESS = '0x181579497d5c4efec2424a21095907ed7d91ac9a'

group by all