SYMBOL | TRANSACTIONS | BUYERS | SELLERS | COLLECTIONS | VOLUME_USD | AVERAGE_PRICE_USD | |
|---|---|---|---|---|---|---|---|
1 | PHPC | 12 | 4 | 16 | 4 | 1.282583098e-10 | 5.576448252e-12 |
2 | LUA | 121711 | 2198 | 3064 | 13 | 964755.157068089 | 1.327353668 |
3 | WETH | 30789 | 7047 | 9659 | 70 | 5656291.46300927 | 1.223718021 |
4 | PIXEL | 916 | 336 | 822 | 38 | 16802.283037149 | 1.886413275 |
5 | LUAUSD | 120 | 26 | 109 | 1 | 4003.8367902 | 0.3633905237 |
6 | ANIMA | 14 | 11 | 16 | 8 | 486.826560262 | 13.522960007 |
7 | KDR | 336 | 86 | 292 | 34 | 37931.171924326 | 44.415892183 |
8 | SLP | 1324 | 633 | 1028 | 31 | 1.090955324e-13 | 1.148241071e-18 |
9 | WRON | 314580 | 36536 | 45675 | 90 | 14207527.0951887 | 2.988646655 |
10 | WF | 1007 | 144 | 826 | 21 | 21483.043338745 | 6.070371104 |
11 | MGT | 21 | 12 | 22 | 7 | 863.387621337 | 13.490431583 |
12 | USDC | 6946 | 1859 | 4698 | 75 | 5.871338294e-7 | 8.246748114e-13 |
13 | APRS | 26 | 16 | 36 | 9 | 485.019971993 | 5.329889802 |
14 | BANANA | 87 | 17 | 75 | 12 | 5115.457034086 | 21.49351695 |
15 | YGG | 23 | 12 | 24 | 9 | 534.749575558 | 10.283645684 |
16 | AXS | 10685 | 3375 | 5668 | 68 | 1016930.2820403 | 0.5146116627 |
Afonso_DiazBy Asset
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: 28 days ago
16
838B
39s