mo1151- OP 4th airdrop - groups
Updated 2024-10-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with wallets as (select
TO_ADDRESS as wallet,
AMOUNT as op,
case when op <=100 then 'less than 100 OP'
when (op <=500 and op>100) then '100_500 OP'
when (op <=1000 and op>500) then '500_1k OP'
when (op <=2000 and op>1000) then '1-2k OP'
when (op <=3000 and op>2000) then '2-3k OP'
when (op <=4000 and op>3000) then '3-4k OP'
when (op <=5000 and op>4000) then '4-5k OP'
when (op <6000 and op>5000) then '5-6k OP'
when (op =6000 ) then '6k OP'
else null end as groups
from optimism.core.ez_token_transfers
where FROM_ADDRESS= '0xfb4d5a94b516df77fbdbcf3cfeb262baaf7d4db7'
and CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'
)
select count(wallet) as wallets, sum(op) as total_op, (total_op/wallets) as avg_op,groups
from wallets
group by groups
QueryRunArchived: QueryRun has been archived