Eman-RazDistribution of Stakers Based on the Number of NFTs Staked
Updated 2023-04-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with tab1 as (select EVENT_DATA:to as "Address", count(distinct EVENT_DATA:id) as "NFT Count", case
when count(distinct EVENT_DATA:id)=1 then 'n=1'
when count(distinct EVENT_DATA:id)>1 and count(distinct EVENT_DATA:id)<=5 then '1<n<=5'
when count(distinct EVENT_DATA:id)>5 and count(distinct EVENT_DATA:id)<=10 then '5<n<=10'
when count(distinct EVENT_DATA:id)>10 and count(distinct EVENT_DATA:id)<=20 then '10<n<=20'
when count(distinct EVENT_DATA:id)>20 and count(distinct EVENT_DATA:id)<=50 then '20<n<=50'
when count(distinct EVENT_DATA:id)>50 and count(distinct EVENT_DATA:id)<=100 then '50<n<=100'
when count(distinct EVENT_DATA:id)>100 then 'n>100'
end as class
from flow.core.fact_events
where event_contract ilike '%dimension%' and event_type='Stake' and tx_succeeded='true'
group by 1
order by 2 desc)
select class, count(distinct "Address") as "Address Count"
from tab1
group by 1
Run a query to Download Data