MLDZMNmple1
    Updated 2024-01-30
    select
    count(*) as "Transactions",
    count(distinct signers[0]) as "Users",
    SUM(CASE When succeeded = True Then 1 Else 0 End ) as succesful_txn,
    succesful_txn/"Transactions"*100 as success_rate
    from solana.core.fact_events
    where program_id = '5D9yi4BKrxF8h65NkVE1raCCWFKUs5ngub2ECxhvfaZe'
    and BLOCK_TIMESTAMP >= current_date-{{Days_back}}



    Last run: about 1 year agoAuto-refreshes every 6 hours
    Transactions
    Users
    SUCCESFUL_TXN
    SUCCESS_RATE
    1
    33633100
    1
    15B
    2s