EVENT_MODULE | EVENT_RESOURCE | COUNT(*) | |
|---|---|---|---|
1 | loan_book | LoanStarted | 1894058 |
2 | object | TransferEvent | 1894058 |
3 | document_manager | DocumentCollectionCreated | 1894058 |
4 | collection | Mint | 1894058 |
5 | loan_book | PendingLoanCreated | 1894058 |
6 | transaction_fee | FeeStatement | 17963258 |
7 | zvt_loanbook_alpha | UnaccountedFee | 148452 |
8 | loan_book | PaymentMade | 16043765 |
9 | collection | Burn | 1339203 |
10 | token | MutationEvent | 1894058 |
11 | loan_book | PaymentScheduleIndexUpdated | 148452 |
12 | risk_score_manager | RiskScoreCreated | 1894058 |
13 | fungible_asset | Deposit | 29057081 |
14 | fungible_asset | Withdraw | 28008233 |
0xHaM-dTxs Test
Updated 10 days ago
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
-- count(distinct TX_HASH) as n_txs,
-- count(distinct SENDER) as n_users
EVENT_MODULE,
EVENT_RESOURCE,
count(*)
from aptos.core.fact_events
where PAYLOAD_FUNCTION ilike '0x5f1ee32ffd50e4c6b1733b00e8e4cf53050d27527488c0c45544e153f8c3618f%'
-- where TX_HASH = '0x2428a9fa0e8486cddbaaecaabdb7e0a3d5915008c25ec6a6fc30cb2eb8c65bad'
group by all
-- limit 10
Last run: 10 days ago
14
572B
69s