PLAYER_TIER | Players | |
|---|---|---|
1 | 50-200 USD | 2043 |
2 | 200-1000 USD | 2121 |
3 | 10-50 USD | 3317 |
4 | More than 1000 USD | 3303 |
5 | Less then 10 USD | 49020 |
MLDZMNPlayer2
Updated 2025-04-01
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
30
31
32
33
34
35
36
›
⌄
with tb1 as (select
*
from blast.core.ez_decoded_event_logs
where CONTRACT_ADDRESS = lower('0xc15568330926e2a6f1519992b0364ca00faf6a7a')
and ORIGIN_FUNCTION_SIGNATURE in ('0x37d8b79d','0xce55803f')
),
tb2 as (select
ORIGIN_FROM_ADDRESS as player,
count(distinct tx_hash) as no_deposits,
sum(AMOUNT) as vol_ETH,
sum(AMOUNT_USD) as vol_usd
from blast.core.ez_native_transfers
where tx_hash in (select tx_hash from tb1)
and TO_ADDRESS = '0xc9438f95aa8d9ee1b5edea15c7fa4b2cac723dce'
group by 1
)
select
case
when vol_usd <= 10 then 'Less then 10 USD'
when vol_usd>10 and vol_usd<=50 then '10-50 USD'
when vol_usd>50 and vol_usd<=200 then '50-200 USD'
when vol_usd>200 and vol_usd<=1000 then '200-1000 USD'
when vol_usd>1000 then 'More than 1000 USD'
end as player_tier,
count(distinct player) as "Players"
from tb2
group by 1 having player_tier is not null
Last run: about 1 month agoAuto-refreshes every 12 hours
5
117B
422s