saber-jltotal marinade
    Updated 2025-05-22
    SELECT
    count(distinct TX_ID) as tx_count,
    count(distinct ADDRESS) as user,
    sum(AMOUNT/1e9) as sol_amount,
    CASE
    WHEN action IN ('deposit') THEN 'deposit'
    when action IN ('deposit_stake') THEN 'stake'
    WHEN action IN ('claim') THEN 'withdraw'
    when action IN ('order_unstake') THEN 'unstake'
    END AS action_type
    FROM solana.defi.fact_stake_pool_actions s
    WHERE stake_pool_name = 'marinade'
    AND s.block_timestamp >= '2025-01-01'
    group by action_type
    Last run: 21 days ago
    TX_COUNT
    USER
    SOL_AMOUNT
    ACTION_TYPE
    1
    26747463815473.36567035unstake
    2
    4652144615.463734286stake
    3
    25227524874253.64187328withdraw
    4
    6266263478205.655436518deposit
    4
    149B
    2s