Bridge_in as (

select

*

from

avalanche.core.ez_decoded_event_logs ev

where

1 = 1

and ev.block_timestamp >= '{{start_time}}'::DATE

and ev.origin_from_address = '0xe93685f3bba03016f02bd1828badd6195988d950'

and ev.event_name = 'Transfer'

)

-- receive_with_layer0 as (

select

ev.block_timestamp,

ev.decoded_log:_to as wallet,

ev.decoded_log:_amount / 1e8 as amount,

ev.decoded_log:_srcChainId as chain_id,

case

when chain_id = 101 then 'Ethereum'

when chain_id = 102 then 'BNB'

when chain_id = 106 then 'Avalanche'

when chain_id = 108 then 'Aptos'

when chain_id = 109 then 'Polygon'

when chain_id = 110 then 'Arbitrum'

when chain_id = 111 then 'Optimisim'

when chain_id = 112 then 'Fantom'

when chain_id = 114 then 'Swimmer'

when chain_id = 115 then 'DFK'

when chain_id = 116 then 'Harmony'

when chain_id = 125 then 'Celo'

when chain_id = 126 then 'MoonBeam'

when chain_id = 118 then 'Dexalot'

when chain_id = 138 then 'Fuse'

when chain_id = 145 then 'Gnosis'

when chain_id = 150 then 'Klaytn'