freemartianPunks Bonding
    Updated 2022-07-04
    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