Elprognerd2- txs dai
    Updated 2023-03-31
    SELECT
    date_trunc('day', block_timestamp) as date,
    count(DISTINCT tx_id) as "Number of TXs",
    sum("Number of TXs") over (order by date) as "Cumulative TXs",
    count(DISTINCT tx_from) as "Number of active users"
    FROM axelar.core.fact_transactions
    GROUP BY 1
    order by 1



    Run a query to Download Data