select *,

'Across' as bridg,

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

ethereum.public.udf_hex_to_int(segmented_data[0])::number/1e18 as amount,

ethereum.public.udf_hex_to_int(segmented_data[2]) as Chain_Id

from ethereum.core.fact_event_logs

where contract_address = lower('0x4D9079Bb4165aeb4084c526a32695dCfd2F77381')

and origin_function_signature in ('0x49228978')

and Chain_Id = '10'

and block_timestamp::date >= CURRENT_DATE() - interval '6 MONTH'

, Bridge as (

select

block_timestamp as send_date,

'Standard Op' as bridg,

origin_from_address as eth_comer

from ethereum.core.ez_eth_transfers

where origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- Optimism: Gateway

and block_timestamp::date >= CURRENT_DATE() - interval '6 MONTH'

UNION

select

block_timestamp as send_date,

'Standard Op' as bridg,

origin_from_address as eth_comer

from ethereum.core.ez_token_transfers

where to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- Optimism: Gateway

and block_timestamp::date >= CURRENT_DATE() - interval '6 MONTH'

UNION

select

block_timestamp as send_date,

'Hop' as bridg,