min AS

SELECT

min( a.block_timestamp ) AS "date"

, a.origin_from_address AS "swapper"

FROM

ethereum.defi.ez_dex_swaps a

WHERE

a.event_name = 'Swap'

AND a.platform = 'sushiswap'

GROUP BY 2

ORDER BY 1 DESC

SELECT

date_trunc( 'week' , a."date" ) AS "date"

, count( distinct a."swapper" ) AS "swapper"

FROM

min a

WHERE

"date" >= '2023-02-01'

AND "date" <= dateadd( 'week' , -1 , current_date )

GROUP BY 1

ORDER BY 1 DESC