MLDZMNSummary of Maple Finance on Solana
    Updated 2024-01-30
    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
    Action
    Transactions
    Users
    Paid fee in SOL
    1
    Burn110.000025
    2
    Lender Set Allowlisted110.000025
    3
    Withdrawal Request Initialize110.000025
    4
    Lender Deposit330.000025
    5
    Mint330.000025
    6
    Lender Initialize110.000025
    7
    Transfer4060.00033
    8
    Lender Unlock Deposit110.000025
    9
    Open Term LoanFund310.000045
    10
    Open Term Loan Repay110.000005
    11
    Open Term Loan Drawdown310.000015
    11
    379B
    173s