kaibladeStake Transaction Volume Over Time
    Updated 2022-11-10
    WITH raw_data AS
    (SELECT *
    FROM near.core.dim_staking_actions
    where action = 'Stake'
    -- FROM near.core.fact_receipts
    -- WHERE receiver_id ='bflame.poolv1.near'
    -- AND array_size(logs) > 0
    ORDER BY block_timestamp DESC)

    SELECT DATE_TRUNC('day',block_timestamp) AS days, COUNT(tx_hash) AS tx_count
    FROM raw_data
    GROUP BY days





    Run a query to Download Data