flipside

    Copy of per user average stats by action
    0-MIDCopy of per user average stats by action
    Updated 2023-02-18

    select POOL_ADDRESS
    ,sum(STAKE_AMOUNT/1e24)as stake_volume
    ,count(distinct TX_HASH) as stake_count
    from near.core.dim_staking_actions
    where BLOCK_TIMESTAMP>=current_date-7
    group by 1
    Run a query to Download Data