SpiltadavidWallets activity
    Updated 2022-10-17
    WITH total_trans_per_user_per_day AS (
    SELECT
    date_trunc('day', block_timestamp) AS day,
    from_address AS address,
    COUNT(tx_hash) AS num_trans
    FROM gnosis.core.fact_transactions
    GROUP BY day, from_address
    ORDER BY day
    ),
    active_users_gt_1 AS (
    SELECT
    day,
    COUNT(address) AS active_addresses
    FROM total_trans_per_user_per_day
    GROUP BY day
    ),
    active_users_gt_2 AS (
    SELECT
    day,
    COUNT(address) AS active_addresses
    FROM total_trans_per_user_per_day
    WHERE num_trans >= 2
    GROUP BY day
    )

    SELECT
    a.day,
    a.active_addresses AS at_least_one_trans,
    b.active_addresses AS more_than_one_trans
    FROM active_users_gt_1 a LEFT JOIN active_users_gt_2 b ON a.day = b.day
    WHERE a.day >= '2022-09-01'
    ORDER BY a.day
    Run a query to Download Data