freemartianPunks Bonding
Updated 2022-07-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
case
when contract_address = '0x0463a06fbc8bf28b3f120cd1bfc59483f099d332' then 'SushiSwap Punk LP'
when contract_address = lower('0xFB2f1C0e0086Bcef24757C3b9bfE91585b1A280f') then 'xPUNKWETH'
when contract_address = lower('0x08765C76C758Da951DC73D3a8863B34752Dd76FB') then 'xPUNK'
when contract_address = lower('0x269616D549D7e8Eaa82DFb17028d0B212D11232A') then 'CryptoPunks (PUNK)'
else 'others'
end as position,
sum(raw_amount)/pow(10,18) as amount,
count(distinct from_address) as Bonders
from ethereum.core.ez_token_transfers
where to_address = '0x91e453f442d25523f42063e1695390e325076ca2'
and position != 'others'
group by position
Run a query to Download Data