SpiltadavidUnique users unstaking
Updated 2022-11-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
with a as (select 'Stake' as platform,
sum(stake_amount/1e24) as "Stake amount in USD",
avg(stake_amount/1e24) as "Average stake amount in USD",
median(stake_amount/1e24) as "Median stake amount in USD",
max(stake_amount/1e24) as "Max stake amount in USD",
--sum("Stake amount in USD") over (order by day) AS "Cumulative unstaked amount in USD",
count(distinct tx_hash) as "Stake Count",
count(distinct tx_signer) as "Unique Stakers"
--sum("Unique Stakers") over (order by day) as "Cumulative staked unique stakers"
from near.core.dim_staking_actions
where action='Stake'
and block_timestamp>current_date-14
group by 1),
b as
(select 'Unstake' as platform,
sum(stake_amount/1e24) as "Unstake amount in USD",
avg(stake_amount/1e24) as "Average unstake amount in USD",
median(stake_amount/1e24) as "Median unstake amount in USD",
max(stake_amount/1e24) as "Max unstake amount in USD",
-- sum("Unstake amount in USD") over (order by day) as "Cumulative unstaked amount in USD",
count(distinct tx_hash) as "Unstake Count",
count(distinct tx_signer) as "Unique Unstakers"
-- sum("Unique Unstakers") over (order by day) as "Cumulative unstaked unique unstakers"
from near.core.dim_staking_actions
where action like '%Unstake%'
and block_timestamp>current_date-14
group by 1)
select * from a
union all
select * from b
Run a query to Download Data