Sniperoverall stats
Updated 2024-11-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select
count(*) as stakes,
count(distinct SIGNER_ID) as stakers,
sum(amount) as staked_token,
-- sum(amount * price) as staked_usd,
-- avg(amount * price) as avg_staked_usd,
avg(amount) as avg_staked_token,
-- staked_usd / stakers as volume_usd_per_user,
stakes / stakers as staked_per_user
-- sum(stakes) over (order by date) as cumulative_stakes ,
-- sum(stakers) over (order by date) as cumulative_stakers ,
-- sum (staked_token) over(order by date) as cumulative_volume_staked_token_native,
-- sum (staked_usd) over(order by date) as cumulative_volume_staked_usd
from
near.gov.fact_staking_actions
-- near_prices
where
-- BLOCK_TIMESTAMP::date = days
action = 'staking'
-- group by 1,2
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived