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 data:approved:returnValues:contractAddress in

('0xce16F69375520ab01377ce7B88f5BA8C48F8D666',

'0x492751eC3c57141deb205eC2da8bFcb410738630',

'0xDC3D8e1Abe590BCa428a8a2FC4CfDbD1AcF57Bd9') and

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

blast.core.fact_event_logs

where

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

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

),

tab2 as (

select

address,

address_name,

project_name,