round(sum(TOKEN_IN_AMOUNT),2)as total_amount_swapping_to,

count (distinct TRADER) as Unique_address,

SPLIT_PART(TOKEN_IN_CONTRACT, '.', 3) AS swapping_to

from flow.core.fact_swaps

where

BLOCK_TIMESTAMP >= CURRENT_DATE() - interval '2 week'

group by 1,4

order by 2 desc