select case when '{{TimeFrame}}' = 'Last 7 Days' then 7

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

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

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

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

when '{{TimeFrame}}' = 'Last 365 Days' then 365

when '{{TimeFrame}}' = 'All Time' then 5000

else 5000 end as timeframe)

select symbol_out,

count (distinct tx_hash) as "Swaps",

count (distinct swapper) as "Swappers",

sum (coalesce (amount_in_usd,amount_out_usd)) As "Volume [$]",

avg (coalesce (amount_in_usd,amount_out_usd)) as "Average Volume [$]"

from aptos.defi.ez_dex_swaps t1 join timetable

where platform ilike '%cellana%'

and block_timestamp >= CURRENT_DATE - timeframe

and token_in not in ('0x2ebb2ccac5e027a87fa0e2e5f656a3a4238d6a48d93ec9b610d570fc0aa0df12','0x4def3d3dee27308886f0a3611dd161ce34f977a9a5de4e80b237225923492a2a::coin::T','0x63be1898a424616367e19bbd881f456a78470e123e2770b5b5dcdceb61279c54::movegpt_token::MovegptCoin')

and token_out not in ('0x2ebb2ccac5e027a87fa0e2e5f656a3a4238d6a48d93ec9b610d570fc0aa0df12','0x4def3d3dee27308886f0a3611dd161ce34f977a9a5de4e80b237225923492a2a::coin::T','0x63be1898a424616367e19bbd881f456a78470e123e2770b5b5dcdceb61279c54::movegpt_token::MovegptCoin')

group by 1 having "Volume [$]" > 0 and symbol_out is not null

order by 3 desc