with table1 as (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)) as source_chain,

to_varchar(lower(data:call:returnValues:destinationChain)) as destination_chain,

data:approved:returnValues:symbol as symbol

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 (

select

blockchain,

block_timestamp as swap_date,

tx_hash,

trader,

platform,

coalesce(amount_in_usd,amount_out_usd) as volume_usd,

symbol_in,

symbol_out,

symbol_in || '➡' || symbol_out as token_pair

from

crosschain.defi.ez_dex_swaps

where

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

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