flipside

    Daily trend of senders in the last 30 days
    thefeministDaily trend of senders in the last 30 days
    Updated 2024-07-15
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
    COUNT(DISTINCT SENDER) AS daily_senders_count
    FROM
    axelar.core.fact_transfers
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE)
    GROUP BY
    DATE_TRUNC('day', BLOCK_TIMESTAMP)
    ORDER BY
    date;

    QueryRunArchived: QueryRun has been archived