USER_CATEGORY | BUYERS | |
|---|---|---|
1 | Active Buyer (11 - 25 Transactions) | 124 |
2 | Casual Buyer (2 - 5 Transactions) | 605 |
3 | Frequent Buyer (26 - 50 Transactions) | 46 |
4 | Moderate Buyer (6 - 10 Transactions) | 150 |
5 | Occasional Buyer (1 Transaction) | 718 |
6 | Power Buyer (More than 50 Transactions) | 22 |
Afonso_DiazClassifying Users
Updated 2025-03-26
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
pricet as (
select
hour::date as date,
avg(price) as token_price_usd
from
ronin.price.ez_prices_hourly
where
symbol = 'RON'
and token_address is null
group by 1
),
main as (
select
tx_hash,
block_timestamp,
b.from_address as seller_address,
b.to_address as buyer_address,
b.contract_address as collection_id,
b.name as collection_name,
a.decoded_log:acceptedSettlePrice / 1e18 as price,
price * token_price_usd as price_usd,
token_id
from
ronin.core.ez_decoded_event_logs a
join
ronin.nft.ez_nft_transfers b using (tx_hash, block_timestamp)
left join
pricet on block_timestamp::date = date
where
event_name = 'OrderMatched'
and decoded_log:order[0]:extraData[0][2] = token_id
and tx_succeeded
and collection_name = 'Nyang Kit'
Last run: 19 days ago
6
265B
7s