campf7
Updated 2022-11-14Copy Reference Fork
9
1
2
3
4
5
6
7
›
⌄
select mindate::date as date,
count (distinct delegator) as "New Delegators",
sum ("New Delegators") over (order by date) as "Total Delegators"
from (select delegator,min(block_timestamp) as mindate from flow.core.ez_staking_actions
where tx_succeeded = 'TRUE' and BLOCK_TIMESTAMP::date<CURRENT_DATE
group by 1) group by 1
Run a query to Download Data