with act1 as (

with tab1 as (

select case

when DECODED_LOG:bridgeData:destinationChainId=1151111081099710 then 'Solana'

when DECODED_LOG:bridgeData:destinationChainId=534352 then 'Scroll'

when DECODED_LOG:bridgeData:destinationChainId=20000000000001 then 'Bitcoin'

when DECODED_LOG:bridgeData:destinationChainId=1329 then 'Sei'

when DECODED_LOG:bridgeData:destinationChainId=5000 then 'Mantle'

end as dst_chain

,TX_HASH

from avalanche.core.ez_decoded_event_logs

where EVENT_NAME='LiFiTransferStarted'

and DECODED_LOG:bridgeData:integrator='jumper.exchange'

and ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

and BLOCK_TIMESTAMP::date>=current_date-90

and DECODED_LOG:bridgeData:destinationChainId in ('1151111081099710','534352','1329','5000','20000000000001')

),

tab2 as (

select date_trunc('minute',BLOCK_TIMESTAMP) as time

,ORIGIN_FROM_ADDRESS

,AMOUNT_USD

,TX_HASH

from avalanche.core.ez_token_transfers

where ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

and ORIGIN_FROM_ADDRESS=FROM_ADDRESS

and BLOCK_TIMESTAMP::date>=current_date-90

select dst_chain

,time

,ORIGIN_FROM_ADDRESS

,AMOUNT_USD

from tab1

left join tab2

on tab1.TX_HASH=tab2.TX_HASH

),