sagharkariUntitled Query
    Updated 2022-11-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