CCTP Bridge Volume by Bridge Path

cloudr3nCCTP Bridge Volume by Bridge Path

Updated 2024-03-27

with

eth_tx as (

SELECT

block_timestamp,

tx_hash,

decoded_log,

decoded_log:amount*pow(10,(-1)*decimals)*price as amount,

decoded_log:burnToken as burnToken,

case when decoded_log:destinationDomain=0 then 'Ethereum'

when decoded_log:destinationDomain=1 then 'Avalanche'

when decoded_log:destinationDomain=2 then 'OP Mainnet'

when decoded_log:destinationDomain=3 then 'Arbitrum'

when decoded_log:destinationDomain=4 then 'Noble'

when decoded_log:destinationDomain=6 then 'Base'

else 'unlabelled'

end as destinationDomain,

'Ethereum' as sourceDomain,

origin_from_address,

symbol

FROM

ethereum.core.ez_decoded_event_logs

LEFT JOIN

ethereum.price.ez_hourly_token_prices on decoded_log:burnToken=token_address and date_trunc('hour', block_timestamp)=hour

WHERE

contract_address='0xbd3fa81b58ba92a82136038b25adec7066af3155'

and event_name in ('DepositForBurn')

avax_tx as (