Eman-RazDistribution of CARV Claimers By Amount
Updated 2025-01-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with tab1 as (select origin_from_address, sum(amount), case
when sum(amount)<=1 then 'V<=1 $CARV'
when sum(amount)>1 and sum(amount)<=10 then '1<V<=10 $CARV'
when sum(amount)>10 and sum(amount)<=100 then '10<V<=100 $CARV'
when sum(amount)>100 and sum(amount)<=1000 then '100<V<=1k $CARV'
when sum(amount)>1000 and sum(amount)<=10000 then '1k<V<=10k $CARV'
when sum(amount)>10000 and sum(amount)<=100000 then '10k<V<=100k $CARV'
when sum(amount)>100000 then 'V>100k $CARV'
end as "Class"
from base.core.ez_token_transfers
where origin_function_signature='0x2f52ebb7'
and origin_to_address='0x584cb7dae5158be594aa1022fb38017c791af2a0' -- $CARV Airdrop
and contract_address='0xc08cd26474722ce93f4d0c34d16201461c10aa8c' -- $CARV Token
and from_address=origin_to_address
and to_address=origin_from_address
and symbol='CARV'
group by 1)
select "Class", count(distinct origin_from_address) as "Claimer Count"
from tab1
group by 1
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived