COUNT(DISTINCT DECODED_LOG:contributor::STRING) AS participants

FROM

base.core.fact_decoded_event_logs

WHERE

CONTRACT_ADDRESS = LOWER('0x194E9beA4f46667EC86332B96E2BE2247B164Fa7')

AND BLOCK_TIMESTAMP::DATE > '2024-10-01'

AND EVENT_NAME = 'Contribution';