MufasaDistinct sweat Users
    Updated 2022-09-21
    with sweat_users as (
    select
    count(distinct(tx_signer)) as signers,
    -- count(distinct(tx_hash)) as no_of_transactions
    -- count(distinct(block_timestamp::date)) as date,
    min(block_timestamp::date) as minimum_date
    from near.core.fact_transactions
    where tx_receiver = 'token.sweat'
    and tx_status = 'Success'
    )
    select * from sweat_users
    Run a query to Download Data