Sniper2024-04-13 04:53 PM
Updated 2024-06-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
with vertex as ( select date(block_timestamp) as date,
tx_hash,
trader,
symbol,
amount_usd
from arbitrum.vertex.ez_clearing_house_events
where MODIFICATION_TYPE = 'deposit'),
tbl as (select
trader,
sum(amount_usd) as volume
from vertex
group by 1)
select
count(DISTINCT trader) as traders,
case
when volume <= 10 then '<= 10 USD'
when volume <= 100 then '10-100 USD'
when volume <= 500 then '100-500 USD'
when volume <= 1000 then '500-1k USD'
when volume <= 5000 then '1-5k USD'
when volume <= 10000 then '5-10k USD'
when volume > 10000 then '> 10k USD'
end as category
from tbl
where volume is not null
group by 2
QueryRunArchived: QueryRun has been archived