rashmannapplicable-emerald
    Updated 2024-10-02
    SELECT
    COUNT(TX_ID) / COUNT(DISTINCT TX_FROM) AS avg_tx_per_user
    FROM
    sei.core.fact_transactions;
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(DAY, -60, CURRENT_DATE)
    AND TX_SUCCEEDED = TRUE;

    QueryRunArchived: QueryRun has been archived