0x0dC7a2832ed0823837907F8Ad7736ccADD14062Fscales (mint nft and staking)
Updated 2022-06-26
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
33
34
›
⌄
SELECT 'STAKING' as "Type Activity" ,count (holders.holder) as holders,count (staking.staker) as "number of wallets activity",
100 * ("number of wallets activity")/holders as "Percentage wallets that are very active staking"
from
(
select distinct ORIGIN_FROM_ADDRESS as holder
from ethereum.core.fact_event_logs E
where e.CONTRACT_ADDRESS=lower ('0x881D40237659C251811CEC9c364ef91dC08D300C')
) as Holders
left join
(
select distinct ORIGIN_FROM_ADDRESS as staker
from ethereum.core.fact_event_logs
where EVENT_NAME ilike 'stak%'
) staking
on holders.holder= staking.staker
UNION
SELECT 'NFT MINT' as "Type Activity",count (holders.holder) as holders,count (minters.Minter) as "number_of_wallets activity",
100 * ("number_of_wallets activity")/holders as "Percentage wallets that are very active mint nft"
from
(
select distinct ORIGIN_FROM_ADDRESS as holder
from ethereum.core.fact_event_logs E
where e.CONTRACT_ADDRESS=lower ('0x881D40237659C251811CEC9c364ef91dC08D300C')
) as Holders
left join
(
select distinct NFT_TO_ADDRESS as Minter
from ethereum.core.ez_nft_mints
where EVENT_TYPE ilike 'nft_mint'
) Minters
on holders.holder= minters.Minter
Run a query to Download Data