misaghlb$OP Airdrop - distribution
Updated 2022-11-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH claimed AS (
select raw_amount/1e18 as balance
from optimism.core.fact_token_transfers
where contract_address = '0x4200000000000000000000000000000000000042'
and from_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
),
balances_dist as (
SELECT
case
when balance >=5000 then 'More Than 5K'
when balance <5000 and balance >= 2000 then '2K - 5K'
when balance <2000 and balance >= 1000 then '1K - 2K'
when balance <1000 and balance >= 500 then '500 - 1K'
when balance <500 then 'less than 500'
end as bal_dist
from claimed
)
SELECT bal_dist, count(bal_dist) as counts from balances_dist
where bal_dist is not NULL
group by bal_dist
Run a query to Download Data