Eman-RazDistribution of Depositors Based on the Deposit Volume
Updated 2024-01-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with tab1 as (select depositor, sum(amount_usd) as "Deposit Volume (USD)", case
when sum(amount_usd)<=1 then 'V<=1 USD'
when sum(amount_usd)>1 and sum(amount_usd)<=10 then '1<V<=10 USD'
when sum(amount_usd)>10 and sum(amount_usd)<=100 then '10<V<=100 USD'
when sum(amount_usd)>100 and sum(amount_usd)<=1000 then '100<V<=1k USD'
when sum(amount_usd)>1000 and sum(amount_usd)<=10000 then '1k<V<=10k USD'
when sum(amount_usd)>10000 and sum(amount_usd)<=100000 then '10k<V<=100k USD'
when sum(amount_usd)>100000 and sum(amount_usd)<=1000000 then '100k<V<=1M USD'
ELSE 'V>1M USD' end as "Class"
from arbitrum.defi.ez_lending_deposits
where platform='Silo' and event_name='Deposit'
group by 1)
select "Class", count(distinct depositor) as "Depositor Count"
from tab1
group by 1
QueryRunArchived: QueryRun has been archived