flipside

    Total New Wallets
    MasiTotal New Wallets
    Updated 2025-04-12
    with tb1 as (SELECT min(block_timestamp::Date) as day,
    from_address
    FROM mezo.testnet.fact_transactions
    group by 2
    )

    select
    count(distinct from_address) as "New Wallets"
    from tb1
    where day = current_date - 1
    Last run: 12 days ago
    New Wallets
    1
    		541
    1
    7B
    1s