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

),

optimism_usdc_transfers as (

select

block_timestamp,

tx_hash,

block_number,

from_address as sender,

to_address as receiver,

(raw_amount / pow(10, 6)) as transfer_amount,

'Optimism' as chain

from optimism.core.fact_token_transfers, fix_parameter

where contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607'

and raw_amount::float > 0

and block_timestamp >= current_date - time_frame

),

optimism_results as (

select

receiver as "Receiver",

sum(transfer_amount) as "Amount of USDC transferred"