Action | Transactions | Users | Paid fee in SOL | |
---|---|---|---|---|
1 | Burn | 1 | 1 | 0.000025 |
2 | Lender Set Allowlisted | 1 | 1 | 0.000025 |
3 | Withdrawal Request Initialize | 1 | 1 | 0.000025 |
4 | Lender Deposit | 3 | 3 | 0.000025 |
5 | Mint | 3 | 3 | 0.000025 |
6 | Lender Initialize | 1 | 1 | 0.000025 |
7 | Transfer | 40 | 6 | 0.00033 |
8 | Lender Unlock Deposit | 1 | 1 | 0.000025 |
9 | Open Term LoanFund | 3 | 1 | 0.000045 |
10 | Open Term Loan Repay | 1 | 1 | 0.000005 |
11 | Open Term Loan Drawdown | 3 | 1 | 0.000015 |
MLDZMNSummary of Maple Finance on Solana
Updated 2024-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
select
case
when logs.value = 'Program log: Instruction: Transfer' then 'Transfer'
when logs.value = 'Program log: Instruction: OpenTermLoanFund' then 'Open Term LoanFund'
when logs.value = 'Program log: Instruction: OpenTermLoanDrawdown' then 'Open Term Loan Drawdown'
when logs.value = 'Program log: Instruction: MintTo' then 'Mint'
when logs.value = 'Program log: Instruction: Burn' then 'Burn'
when logs.value = 'Program log: Instruction: LenderInitialize' then 'Lender Initialize'
when logs.value = 'Program log: Instruction: LenderSetAllowlisted' then 'Lender Set Allowlisted'
when logs.value = 'Program log: Instruction: LenderDeposit' then 'Lender Deposit'
when logs.value = 'Program log: Instruction: PoolInitialize' then 'Pool Initialize'
when logs.value = 'Program log: Instruction: WithdrawalRequestInitialize' then 'Withdrawal Request Initialize'
when logs.value = 'Program log: Instruction: LenderUnlockDeposit' then 'Lender Unlock Deposit'
when logs.value = 'Program log: Instruction: LoanMakePayment' then 'Loan Make Payment'
when logs.value = 'Program log: Instruction: OpenTermLoanMakePayment' then 'Open Term Loan Make Payment'
when logs.value = 'Program log: Instruction: OpenTermLoanRepay' then 'Open Term Loan Repay'
when logs.value = 'Program log: Instruction: LoanDrawdown' then 'Loan Drawdown'
when logs.value = 'Program log: Instruction: LoanFund' then 'Loan Fund'
else null
end as "Action",
ZEROIFNULL(count(*)) as "Transactions",
ZEROIFNULL(count(distinct signers[0])) as "Users",
ZEROIFNULL(sum(FEE/1e9)) as "Paid fee in SOL"
from solana.core.fact_transactions s
join (select distinct block_timestamp, tx_id
from solana.core.fact_events where succeeded = True
and program_id = '5D9yi4BKrxF8h65NkVE1raCCWFKUs5ngub2ECxhvfaZe'
) events
using(tx_id, block_timestamp)
join lateral flatten (input => log_messages) logs
where BLOCK_TIMESTAMP >= current_date-{{Days_back}}
and logs.value ilike 'Program log:%'
group by 1 having "Action" is not null
Last run: about 1 year agoAuto-refreshes every 6 hours
11
379B
173s