kaibladeWeekly Stake Amount Volume
    Updated 2022-11-10
    WITH raw_data AS
    (
    SELECT tx_hash, block_timestamp, stake_amount/1e24 as stake_amount,action
    FROM near.core.dim_staking_actions
    WHERE action = 'Stake'
    )

    -- revised_stake AS
    -- (SELECT tx_hash, block_timestamp,
    -- (CASE
    -- WHEN action = 'Stake' THEN stake_amount
    -- ELSE stake_amount * -1
    -- END) AS signed_amount
    -- FROM raw_data)

    -- SELECT
    -- FROM near.core.fact_receipts
    -- WHERE receiver_id ='bflame.poolv1.near'
    -- AND array_size(logs) > 0
    -- ORDER BY block_timestamp DESC)

    SELECT DATE_TRUNC('week',block_timestamp) AS "Weeks", SUM(stake_amount) AS "Total Stake Amount"
    FROM raw_data
    GROUP BY "Weeks"





    Run a query to Download Data