SELECT Block_timestamp,Tx_hash,

contract_address, event_name,

decoded_log:taker AS Swappers

FROM base.core.fact_decoded_event_logs

WHERE contract_address = '0xdef1c0ded9bec7f1a1670819833240f027b25eff'

AND event_name = 'TransformedERC20'

),

user AS (

SELECT MIN(Date_trunc('Day', BLOCK_TIMESTAMP)) AS Date,

FROM matchasummary

GROUP BY Swappers )

SELECT Date, count( DISTINCT Swappers) AS "New Swappers",

SUM(count( DISTINCT Swappers)) OVER (ORDER BY Date) AS "Cumulative New Swappers",

FROM user

GROUP BY Date

ORDER BY DATE DESC