MLDZMNwgno2
    Updated 2022-10-15
    select
    date_trunc('day', first_transaction_stamp) as day,
    count (distinct sender) as new_users
    from (
    select
    distinct FROM_ADDRESS as sender,
    min(block_timestamp) as first_transaction_stamp
    from gnosis.core.fact_transactions
    WHERE tx_hash is not null
    group by 1
    )
    where day>=CURRENT_DATE-30
    group by 1
    Run a query to Download Data