crypto_gostamount staking and unstaking
    Updated 2024-11-17
    SELECT
    DATE_TRUNC('month', block_timestamp) AS month,
    action,
    SUM(amount) AS total_amount
    FROM
    NEAR.gov.fact_staking_actions
    WHERE
    action IN ('staking', 'unstaking')
    AND block_timestamp >= DATE_TRUNC('year', CURRENT_DATE)
    GROUP BY
    month,
    action
    ORDER BY
    month,
    action;
    QueryRunArchived: QueryRun has been archived