MLDZMNarb2
    Updated 2023-04-17
    select
    count (distinct sender) as new_users
    from (
    select
    distinct FROM_ADDRESS as sender,
    min(block_timestamp) as first_transaction_stamp
    from Arbitrum.core.fact_transactions
    WHERE tx_hash is not null
    and block_timestamp>=CURRENT_DATE-7
    group by 1
    )
    Run a query to Download Data