Transactions | Users | SUCCESFUL_TXN | SUCCESS_RATE | |
---|---|---|---|---|
1 | 33 | 6 | 33 | 100 |
MLDZMNmple1
Updated 2024-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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
1
15B
2s