banbannardVoting Activity 2
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with base as (select tokenid,
max(block_timestamp) as latest_transfer
from ethereum.core.ez_nft_transfers
where
nft_address ilike '0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B'
group by 1),
base2 as (select nft_to_address as holder,
count(distinct(a.tokenid)) as nft_holding
from ethereum.core.ez_nft_transfers a
join base b
on a.tokenid = b.tokenid and a.block_timestamp = b.latest_transfer
where nft_address ilike '0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B'
group by 1
order by 2 desc)
select avg(nft_holding)
from base2
Run a query to Download Data