flipside

    OSMOSIS Active Wallets per day
    OneDataAnalystOSMOSIS Active Wallets per day
    Updated 2022-06-04
    SELECT Count(address) As Active_Addresses, DATE
    From(
    SELECT Distinct tx_from AS address , Date_Trunc('day', block_timestamp) AS date
    FROM osmosis.core.fact_transactions
    )
    WHERE date < CURRENT_DATE
    GROUP BY 2
    order by 2

    Run a query to Download Data