piperArbitrum - Open Analyitics Bounty: Daily Number of Active Users
    Updated 2022-07-26


    SELECT
    block_timestamp::date AS date,
    COUNT(DISTINCT(from_address)) AS number_of_users
    FROM
    arbitrum.core.fact_transactions
    GROUP BY date
    ORDER BY date ASC
    Run a query to Download Data