freemartianNon-Voters Holdings & Activities
Updated 2022-06-21
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
35
36
›
⌄
with receive as (
select nft_to_address as receiver, count(nft_to_address) as positive_number
from ethereum.core.ez_nft_transfers
where nft_address = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
group by receiver
),
voters as (
select event_inputs:voter as voter, COUNT(*) as votes
from ethereum.core.fact_event_logs
where ORIGIN_TO_ADDRESS = LOWER('0x5d2C31ce16924C2a71D317e5BbFd5ce387854039')
and event_name = 'VoteCast'
group by voter
),
non_voters as (
select nft_to_address as total_buyer, count(total_buyer) as holdings
from ethereum.core.ez_nft_transfers
where NFT_ADDRESS = LOWER('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
and total_buyer not in (select voter from voters)
group by total_buyer
)
select
(case
when holdings = 1 then '1'
when holdings >= 2 and holdings <= 5 then '2-5'
when holdings >= 6 and holdings <= 10 then '6-10'
when holdings >= 11 and holdings <= 25 then '11-25'
when holdings >= 26 and holdings <= 100 then '26-100'
when holdings >= 101 then '> 100'
end
) as asset_count,
count(DISTINCT total_buyer) as number_of_non_voter
from non_voters
join voters where voter not in ( select total_buyer from non_voters)
Run a query to Download Data