SELECT

block_timestamp,

tx_hash,

decoded_log:amount / 1e18 AS amount,

decoded_log:depositId AS deposit_id,

decoded_log:sourceChainId AS source_chain_id,

decoded_log:to AS receiver,

decoded_log:token AS token_address,

CASE

WHEN decoded_log:token = '0x0000000000000000000000000000000000000000' THEN 'ETH'

WHEN decoded_log:token = '0xa18bf3994c0cc6e3b63ac420308e5383f53120d7' THEN 'BOBA'

END AS token_symbol

FROM boba.core.ez_decoded_event_logs

WHERE event_name = 'DisbursementSuccess'

AND origin_function_signature = '0x92c3ec48'

AND tx_succeeded = TRUE

SELECT

MIN(CASE WHEN token_symbol = 'BOBA' THEN amount END) AS min_boba_bridged,

MAX(CASE WHEN token_symbol = 'BOBA' THEN amount END) AS max_boba_bridged

FROM disbursement;