smritiMarginFi protocol fee
    Updated 2025-04-16
    SELECT
    DATE_TRUNC('day', ft.block_timestamp) AS day,
    SUM(ft.fee) AS protocol_fee_in_Lamports
    FROM solana.core.fact_transactions ft
    INNER JOIN (
    SELECT DISTINCT tx_id
    FROM solana.core.fact_decoded_instructions
    WHERE
    program_id = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'
    AND block_timestamp >= CURRENT_DATE - INTERVAL '10 days'
    ) d ON ft.tx_id = d.tx_id
    WHERE block_timestamp >= CURRENT_DATE - INTERVAL '10 days'
    AND ft.succeeded = 'true'
    GROUP BY 1
    ORDER BY day DESC














    Last run: about 2 months ago
    DAY
    PROTOCOL_FEE_IN_LAMPORTS
    1
    2025-04-16 00:00:00.00042627721
    2
    2025-04-15 00:00:00.000138383356
    3
    2025-04-14 00:00:00.000154574399
    4
    2025-04-13 00:00:00.000126326246
    5
    2025-04-12 00:00:00.000185777888
    6
    2025-04-11 00:00:00.000164946611
    7
    2025-04-10 00:00:00.000117594506
    8
    2025-04-09 00:00:00.000259713436
    9
    2025-04-08 00:00:00.000194785965
    10
    2025-04-07 00:00:00.0006628708814
    11
    2025-04-06 00:00:00.0005571878403
    11
    420B
    60s