mohamadreza221166Total Unique Users On Swimming Protocol
    Updated 2022-07-27
    WITH swims AS(
    SELECT
    INNER_INSTRUCTION:instructions[0]:parsed:info:source AS wallet
    FROM solana.core.fact_events
    WHERE PROGRAM_ID = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
    AND SUCCEEDED = 'TRUE'
    )

    SELECT COUNT(DISTINCT wallet) AS UNIQUE_USERS
    FROM swims
    WHERE wallet IS NOT NULL
    Run a query to Download Data