messariOsmosis Daily
    Updated 2023-04-26
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) as date,
    SUM(GAS_USED) as gas_used,
    COUNT(DISTINCT BLOCK_ID) as num_blocks,
    COUNT(DISTINCT TX_FROM) as num_active_users,
    COUNT(DISTINCT TX_ID) as num_transactions
    FROM
    osmosis.core.fact_transactions
    WHERE
    TX_SUCCEEDED = true
    GROUP BY
    date
    order by
    date desc
    Run a query to Download Data