from ethereum.core.fact_event_logs

where ORIGIN_FROM_ADDRESS in (lower('0xa6a688F107851131F0E1dce493EbBebFAf99203e')

, lower('0x15ec4512516d980090050fe101de21832c8edfee'), lower('0x10b6CbDFE187c04d63F179B87067C49e7a1E91Af'),

and event_name = 'WithdrawalBonded')

,

hop_amount as (

select

block_timestamp,

eth_to_address as address,

tx_hash,'ETH' as symbol,

amount_usd

from ethereum.core.ez_eth_transfers

where tx_hash in ( select tx_hash from hop_bridge)

and origin_from_address <> eth_to_address

select

block_timestamp,

to_address as address,

tx_hash,

symbol,

amount_usd

from ethereum.core.ez_token_transfers

where tx_hash in ( select tx_hash from hop_bridge)

and symbol in ('DAI','USDC','USDT')

and origin_from_address <> to_address)

,

native_bridge as (

select

block_timestamp,

origin_from_address as address,

tx_hash,

'ETH' as symbol,