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

),

disbursement_with_price AS (

SELECT

d.block_timestamp,

DATE_TRUNC('week', d.block_timestamp) AS week,

d.tx_hash,

d.amount,

d.deposit_id,

d.source_chain_id,

d.receiver,

d.token_address,

d.token_symbol,

p.price AS token_price,

d.amount * p.price AS amount_usd

FROM disbursement d

LEFT JOIN boba.price.ez_prices_hourly p

ON d.token_symbol = p.symbol

AND DATE_TRUNC('hour', d.block_timestamp) = p.hour