mo1154- OP 5th airdrop - claims
Updated 2024-10-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with claims as (
select count(TO_ADDRESS) as wallets,
sum(AMOUNT) as claimed,
'op' as token
from optimism.core.ez_token_transfers
where FROM_ADDRESS= '0x9a69d97a451643a0bb4462476942d2bc844431ce'
and CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'),
total as (
select
sum(AMOUNT) as total,
'op' as token
from optimism.core.ez_token_transfers
where TO_ADDRESS= '0x9a69d97a451643a0bb4462476942d2bc844431ce'
and CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'
)
select wallets, claimed,total, c.token, (claimed/total)*100 as "% of claimed "
from claims c join total t on c.token=t.token
QueryRunArchived: QueryRun has been archived