SELLER_ADDRESS | TRANSACTIONS | VOLUME | AVERAGE_PRICE | VOLUME_USD | AVERAGE_PRICE_USD | |
|---|---|---|---|---|---|---|
1 | 0x7b2d268eea7f99520f7e968052fac76f52c73c7e | 303 | 607860.955220219 | 154.750752347 | 922630.087493617 | 234.885460156 |
2 | 0xc0fc9bfd335cde161598070812c3d59e26863518 | 533 | 74863.991524365 | 3.035970296 | 106828.050871192 | 4.332213426 |
3 | 0x584d6633bca1d8c125e53179727df43d81e57920 | 732 | 62206.433331612 | 3.243973369 | 93289.379599542 | 4.864902983 |
4 | 0x4b688cc0d7f4db8c8ce2f41509897c6b18cd2ea6 | 300 | 45419.302808143 | 9.378340452 | 85645.733454473 | 17.684438046 |
5 | 0x3dbf47a0f55eef8bd1618459a8df8abd7dcd4298 | 2181 | 29605.973833619 | 9.842411514 | 27816.619502058 | 9.253699102 |
6 | 0x7f30f5530d790c0221523b9936008d4b3d0cfd2c | 17 | 29194.773007099 | 1536.567000374 | 4130.873173448 | 217.41437755 |
7 | 0x6b81ea1d1af42f9efaa40954643ee0fe2e4532bf | 81 | 27381.760205916 | 260.778668628 | 30529.858546453 | 290.760557585 |
8 | 0x69060a83016325b3e5283f130452cbee1f29a3ce | 239 | 26360.39424221 | 64.450841668 | 54417.550208449 | 133.050245008 |
9 | 0x4ee5301f7945dc3781ffe3e0cff9d3c18379e08a | 1099 | 25610.18404981 | 21.270916985 | 29390.786529927 | 24.431243998 |
10 | 0x4607574786cd6307b6c166218cb23fe68bdcedc4 | 154 | 25249.278382944 | 163.956353136 | 173975.89819839 | 1129.713624665 |
11 | 0xee04aff62fc896cd8ce13a320b483c7841e051ff | 210 | 24300.621020179 | 2.869022553 | 23485.773449348 | 2.772818589 |
12 | 0xbb6d2c997d38d068ac721978c6ac0c75d65c32d1 | 42 | 23908.481963296 | 498.093374235 | 5184.418801331 | 108.008725028 |
13 | 0x649e3693267fbd07239d03c18113d4f5db385add | 630 | 23334.528201671 | 10.558610046 | 9829.854422503 | 4.447897929 |
14 | 0xd29be4885e53bb300a2fdcc6b4793aeb3ef90da2 | 84 | 23091.200382612 | 7.67914878 | 36738.168114923 | 12.217548425 |
15 | 0xeb62eec22ccf13f60a9c3352ec507f00720b00e0 | 15 | 21426.956015068 | 1428.463734338 | 155917.194419126 | 10394.479627942 |
16 | 0xe9ef9234fa9d0585e5f153420386c92653e2fc65 | 349 | 21335.955686327 | 0.2344713579 | 28519.293662412 | 0.3134126078 |
17 | 0xc0b0fab405f64919f942810095efeeb536834104 | 25 | 21317 | 852.68 | 41017.332083333 | 1640.693283333 |
18 | 0x0dc1eaef2b34e0530106d0fa6f5d26d5e666e169 | 66 | 21226.151717901 | 321.608359362 | 1471.012793231 | 22.288072625 |
19 | 0xa0caa7803205026ec08818664c4211aff7565f56 | 82 | 21030.984606928 | 191.190769154 | 19121.706172495 | 173.833692477 |
20 | 0xa86772c7476118cce273034d6b1df3094f6670b9 | 24 | 20942.758146171 | 654.461192068 | 35199.998209905 | 1099.99994406 |
Afonso_DiazTop Sellers
Updated 2025-03-27
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,
token_address,
symbol,
avg(price) as token_price_usd
from ronin.price.ez_prices_hourly
group by 1, 2, 3
),
txns 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,
pricet.symbol,
(a.decoded_log:acceptedSettlePrice / 1e18) as price,
price * token_price_usd as price_usd,
quantity,
token_id,
a.decoded_log:settleToken as token_address
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 and a.decoded_log:settleToken = token_address
where event_name = 'OrderMatched'
and decoded_log:order[0]:extraData[0][2] = token_id
and decoded_log::string ilike '%' || from_address || '%'
and tx_succeeded
),
Last run: 18 days ago
100
10KB
36s