SELECT

to_varchar(data:call:transaction:from) as squid_user,

created_at as bridge_date,

to_varchar(id) as transaction_hash,

to_varchar(lower(data:call:chain)) || '➡' || to_varchar(lower(data:call:returnValues:destinationChain)) as route

FROM

axelar.axelscan.fact_gmp

WHERE

status = 'executed'

AND simplified_status = 'received'

AND created_at :: date >= '{{Start_Date}}'

AND created_at :: date <= '{{End_Date}}'

),

table2 as (

with tab1 as (

select

block_timestamp as activity_date,

origin_from_address as user,

tx_hash,

contract_address

from

mantle.core.fact_event_logs

where

block_timestamp :: date >= '{{Start_Date}}'

and block_timestamp :: date <= '{{End_Date}}'

),

tab2 as (

select

address,

address_name,

label,

label_type

from

mantle.core.dim_labels