COLLECTION_ADDRESS | TRANSACTIONS | BUYERS | SELLERS | VOLUME | AVERAGE_AMOUNT | VOLUME_USD | AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|---|---|---|---|
1 | 0x7f51575f486e26f83e575a3fe77db71032e4d124 | 1332 | 347 | 601 | 114497.88210668 | 63.71612805 | 40120.758747942 | 22.326521284 |
2 | 0x9a1e3d2a010dbe576f9cccd57b2fc0df96c8e44d | 815 | 185 | 294 | 74578.109440238 | 76.255735624 | 25729.65154813 | 26.308437166 |
3 | 0x025776f8aec3f445a64fea642cd7776302157815 | 1263 | 381 | 524 | 51319.10773873 | 27.35560114 | 19636.244609837 | 10.467081349 |
4 | 0x33962384ea96fffd38981bcab9e84ebb9ce111f9 | 47 | 18 | 23 | 23879.3 | 477.586 | 6939.45045965 | 138.789009193 |
5 | 0x810a9d701d187fa7991659ca97279fbd49dee8eb | 468 | 238 | 310 | 21000.458675455 | 37.103283879 | 5894.603734436 | 10.41449423 |
6 | 0xcf57971769e2abe438c9644655bd7ae0f2f9fec8 | 171 | 77 | 129 | 13307.58574299 | 66.206894244 | 4917.950422326 | 24.467415036 |
7 | 0x75e9ea2c01b0ce74c22f0e5d02cec57d8e5abe81 | 156 | 87 | 104 | 11561.255692433 | 56.396369231 | 3448.227058189 | 16.820619796 |
8 | 0x9a6c24fe29c70d41bcc3099c4b40dac930372e22 | 340 | 121 | 211 | 9610.477188573 | 22.143956656 | 3788.39331192 | 8.729016848 |
9 | 0xe73d273406546e31de2f3f43c533badce9c51927 | 70 | 33 | 26 | 8334.281938 | 65.624267228 | 2416.597575505 | 19.028327366 |
10 | 0xe8835036f4007a9781820c62c487d592ad9801be | 498 | 182 | 198 | 6538.809284942 | 6.919374905 | 1510.155273345 | 1.598047908 |
Afonso_DiazTop collections
Updated 2025-05-05
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
sei.price.ez_prices_hourly
where
token_address = 'usei'
group by 1
),
main as (
select
tx_hash,
block_timestamp,
-- Determine NFT collection address
iff(
decoded_log:consideration[0]:token != '0x0000000000000000000000000000000000000000',
decoded_log:consideration[0]:token,
decoded_log:offer[0]:token
) as collection_address,
-- Determine buyer and seller addresses
iff(
collection_address = '0x0000000000000000000000000000000000000000',
origin_from_address,
decoded_log:consideration[0]:recipient
) as buyer_address,
iff(
collection_address != '0x0000000000000000000000000000000000000000',
origin_from_address,
decoded_log:consideration[0]:recipient
Last run: 26 days ago
10
1KB
3s