WITH from_eth_to_ron as ( -- native bridge

BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS as sender,

DECODED_LOG:receipt:mainchain:tokenAddr as token_address,

DECODED_LOG:receipt:ronin:addr as receiver,

DECODED_LOG:receipt:ronin:tokenAddr as destination_tokenAddr,

DECODED_LOG:receipt:info:quantity as quantity,

'Ethereum'::VARCHAR as BLOCKCHAIN,

'axie infinity: ronin bridge v2'::VARCHAR as platform,

'ronin'::VARCHAR as destination_chain,

'inbound'::VARCHAR as direction,

coalesce(p.symbol,cont.symbol)::VARCHAR as symbol,

(log.DECODED_LOG:receipt:info:quantity::int/pow(10,p.decimals)) as amount,

(log.DECODED_LOG:receipt:info:quantity::int/pow(10,p.decimals))*p.price as amount_usd,

from ethereum.core.ez_decoded_event_logs log

left join crosschain.price.ez_prices_hourly p on (date_trunc('hour',log.block_timestamp)=p.hour and log.DECODED_LOG:receipt:mainchain:tokenAddr=p.token_address)

left join ethereum.core.dim_contracts cont on (log.DECODED_LOG:receipt:mainchain:tokenAddr=cont.address)

where log.TOPIC_0 = '0xd7b25068d9dc8d00765254cfb7f5070f98d263c8d68931d937c7362fa738048b'

and log.block_timestamp >= '2025-01-01'

and log.TX_SUCCEEDED = TRUE

and p.BLOCKCHAIN='ethereum'

and log.CONTRACT_ADDRESS = '0x64192819ac13ef72bf6b5ae239ac672b43a9af08'

,

from_ron_to_eth as ( -- native bridge

with

bridge_data as (

select

BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS::VARCHAR as sender,

regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,