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 | 0x025776f8aec3f445a64fea642cd7776302157815 | 1263 | 381 | 524 | 51319.10773873 | 27.35560114 | 19636.244609837 | 10.467081349 |
3 | 0x1f963c268e711d09f7a9173532665d9c4491120a | 830 | 759 | 425 | 5217.185666063 | 1.975458412 | 1046.344577827 | 0.3961925702 |
4 | 0x9a1e3d2a010dbe576f9cccd57b2fc0df96c8e44d | 815 | 185 | 294 | 74578.109440238 | 76.255735624 | 25729.65154813 | 26.308437166 |
5 | 0x4e42894a5b5657641d5e786d2606aac0cc3f65cf | 750 | 82 | 281 | 27.807061 | 0.005800388194 | 10.218695661 | 0.002131559379 |
6 | 0x08bd7ab3f21f838bcbc83bab491947ca1aa95b1a | 509 | 134 | 152 | 2881.8732922 | 2.045332358 | 857.573059382 | 0.6086395028 |
7 | 0xe8835036f4007a9781820c62c487d592ad9801be | 498 | 182 | 198 | 6538.809284942 | 6.919374905 | 1510.155273345 | 1.598047908 |
8 | 0xce0fee0ac17f37cd66642f0ec8a4675ae7f590dd | 475 | 117 | 157 | 5524.389044411 | 7.58844649 | 1199.909075027 | 1.648226751 |
9 | 0x28b734946e13ce84af3d09e209c28b63467bb215 | 469 | 276 | 236 | 2667.121798444 | 3.928014431 | 1037.78098174 | 1.528396144 |
10 | 0x810a9d701d187fa7991659ca97279fbd49dee8eb | 468 | 238 | 310 | 21000.458675455 | 37.103283879 | 5894.603734436 | 10.41449423 |
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: 28 days ago
10
1KB
3s