with final_table as (WITH token_transfer AS (

WITH filtered_transfers AS (

SELECT

data:link:height::string AS block_number,

data:link:txhash AS tx_hash,

data:send:original_source_chain AS original_source_chain,

data:send:original_destination_chain AS original_destination_chain,

data:time_spent:destination_chain_type AS destination_chain_type,

data:time_spent:source_chain_type AS source_chain_type,

sender_address,

created_at::date AS date,

CAST((data:send:amount) * (data:link:price) AS VARCHAR) AS usd_amount_sent,

CAST(data:send:fee_value AS VARCHAR) AS fee_usd,

id

FROM axelar.axelscan.fact_transfers

WHERE sender_address = '0xce16F69375520ab01377ce7B88f5BA8C48F8D666'

AND simplified_status = 'received'

AND created_at::date between '{{Start_Date}}' and '{{End_Date}}'

)

SELECT

CAST(date AS VARCHAR) AS date,

CASE

WHEN ft.original_source_chain = 'base' THEN base_tx.from_address

WHEN ft.original_source_chain = 'arbitrum' THEN arbitrum_tx.from_address

WHEN ft.original_source_chain = 'ethereum' THEN ethereum_tx.from_address

WHEN ft.original_source_chain = 'avalanche' THEN avalanche_tx.from_address

WHEN ft.original_source_chain = 'optimism' THEN optimism_tx.from_address

WHEN ft.original_source_chain = 'binance' THEN binance_tx.from_address

WHEN ft.original_source_chain = 'polygon' THEN polygon_tx.from_address

END AS sender,

CAST(ft.original_source_chain AS VARCHAR) AS source_chain,

CAST(ft.source_chain_type AS VARCHAR) AS source_chain_type,