feyikemiKamino Avg Txns
    Updated 2025-03-27
    --kamino program : --6LtLpnUFNByNXLyCoK9wA2MykKAmQNZKBdY8s47dehDc

    SELECT
    Count(DISTINCT Date_trunc('second', block_timestamp)) Date,
    Count(DISTINCT tx_id) Txns,
    Txns/Date as Avg_Txn
    FROM solana.core.fact_events
    WHERE program_id IN ('6LtLpnUFNByNXLyCoK9wA2MykKAmQNZKBdY8s47dehDc', 'KLend2g3cP87fffoy8q1mQqGKjrxjC8boSyAYavgmjD')
    AND block_timestamp::date >= '2024-04-01'
    AND succeeded = 'True'

    ORDER BY 2 DESC
    Last run: about 2 months ago
    DATE
    TXNS
    AVG_TXN
    1
    8741044216614262.478128
    1
    29B
    10s