sagharkariUntitled Query
Updated 2022-11-11
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with tab1 as
(select date_trunc('day',block_timestamp) as day, DELEGATOR as staker,
count(tx_id) as stake_count ,
sum(amount) as total_flow
from flow.core.ez_staking_actions
where action in ('DelegatorTokensCommitted','TokensCommitted')
group by 1)
select avg(total_flow) as Avg, median(total_flow) AS Median, min(total_flow) as Min, max(total_flow) as Max
from tab1
group by 1
Run a query to Download Data