SniperWeekly volume of staked in validators in flow
    Updated 2023-04-22
    SELECT
    trunc(block_timestamp,'week') as date,
    VALIDATOR_TYPE,
    count(distinct(t1.TX_ID)) as total_txs,
    sum (AMOUNT) as total_volume_staked
    FROM
    flow.core.ez_staking_actions t1 join flow.core.dim_validator_labels t2
    on t1.NODE_ID=t2.NODE_ID
    WHERE
    t1.ACTION in ('TokensCommitted','DelegatorTokensCommitted')
    group by 1, 2
    order by 2 DESC

    Run a query to Download Data