SELECT

CAST(created_at AS VARCHAR) AS date,

(data:call:transaction:from) AS Sender,

LOWER((data:call:chain)) AS source_chain,

LOWER((data:call:transactionHash)) AS source_tx,

(data:call:chain_type) AS source_chain_type,

LOWER((data:call:returnValues:destinationChain)) AS destination_chain,

destination_chain_type AS destination_chain_type,

CAST((data:value) AS VARCHAR) AS usd_amount,

CAST((data:gas:gas_used_amount) * (data:gas_price_rate:source_token.token_price.usd) AS VARCHAR) AS fee_usd,

CAST(id AS VARCHAR) AS id,

'GMP' as transfer_type

FROM axelar.axelscan.fact_gmp

WHERE data:approved:returnValues:contractAddress = '0xce16F69375520ab01377ce7B88f5BA8C48F8D666'

AND status = 'executed'

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

AND source_chain = 'base'

),

tokens AS (

SELECT bg.date, bg.sender, bg.source_chain, bg.destination_chain, bg.source_tx, bg.usd_amount, bt.origin_function_signature,

bt.contract_address AS token_address, bt.symbol, bt.amount AS token_amount, bt.amount_usd,

'token' AS type

FROM base_gmp bg

INNER JOIN base.core.ez_token_transfers bt

ON bg.source_tx = bt.tx_hash

AND bg.sender = bt.origin_from_address

AND bg.sender = bt.from_ADDRESS

WHERE bt.block_timestamp::DATE ='{{End_Date}}'

AND bt.contract_address IS NOT NULL

SELECT bg.date, bg.sender, bg.source_chain, bg.destination_chain, bg.source_tx, bg.usd_amount, bt.origin_function_signature,

'0xEeeeeEeeeEeEeeEeEeEeeEEEeeeeEeeeeeeeEEeE' AS token_address, 'ETH' AS symbol,

bt.amount AS token_amount, bt.amount_usd, 'native' AS type

FROM base_gmp bg