SELECT date_trunc('week', block_timestamp) , TX_TO as Wallet , count(*) as Total_Swap_Count,
RANK () OVER (
ORDER BY Total_Swap_Count DESC
) Rank
from ethereum_sushi.ez_swaps
where (block_timestamp between '2022-4-1' and '2022-4-30') and platform = 'sushiswap' and tx_to not in (select address from ethereum_core.dim_labels )
and tx_to not in (select address from ethereum_core.dim_contracts) -- Filters Contract address
GROUP by 1,2
having Total_Swap_Count > 5
order by 3 DESC
limit 1000