flipside

    2024-04-17 01:02 AM
    feyikemi2024-04-17 01:02 AM
    Updated 2024-04-17
    SELECT
    --Date_trunc('day', block_timestamp) Date,
    --Count(DISTINCT tx_id) Txns,
    Count(Tx_succeeded)/100
    FROM sei.core.fact_transactions
    WHERE block_timestamp :: date > current_date - 30
    AND Tx_succeeded = 'True'
    --GROUP BY 1
    --ORDER BY 1 DESC
    QueryRunArchived: QueryRun has been archived