flipside

    2024-04-17 12:21 AM
    feyikemi2024-04-17 12:21 AM
    Updated 2024-04-16
    SELECT
    Date_trunc('second', block_timestamp) Date,
    Count(DISTINCT tx_id) Txns,
    --abs(Txns/Date) as TPS
    FROM
    sei.core.fact_transactions
    WHERE
    block_timestamp :: date > current_date - 30
    GROUP BY
    1
    ORDER BY
    1 DESC
    QueryRunArchived: QueryRun has been archived