with fix_parameter as (

select

case

when '{{Days}}' = 'All time' then 2000

when '{{Days}}' = 'Last 30 days' then 30

when '{{Days}}' = 'Last 60 days' then 60

when '{{Days}}' = 'Last 90 days' then 90

when '{{Days}}' = 'Last 180 days' then 180

when '{{Days}}' = 'Last 360 days' then 360

else 30

end as time_frame

),

axelar_usdc_transfers as (

select

block_timestamp,

tx_id as tx_hash,

block_id as block_number,

sender,

receiver,

(amount / pow(10, 6))::float as transfer_amount,

'Axelar' as chain

from axelar.core.fact_transfers, fix_parameter

where currency = 'uusdc'

and amount::float > 0

and tx_succeeded = true

and block_timestamp >= current_date - time_frame

),

top_10_receiver as (

select

receiver as "Receiver",

sum(transfer_amount) as "Amount of USDC transferred"