SYMBOL | TRANSACTIONS | SELLERS | BUYERS | VOLUME_USD | AVERAGE_PRICE_USD | MAX_PRICE_USD | |
|---|---|---|---|---|---|---|---|
1 | YGG | 3 | 4 | 3 | 8.022423654 | 0.445690203 | 2.409868691 |
2 | BANANA | 2 | 4 | 2 | 2.700268771 | 0.06586021393 | 0.2421259252 |
3 | WRON | 50098 | 3370 | 4053 | 442755.529096471 | 0.6053443674 | 1756.944050386 |
4 | WF | 1 | 1 | 1 | 0.04516721927 | 0.04516721927 | 0.04516721927 |
5 | APRS | 8 | 8 | 5 | 14.400343452 | 0.3789564066 | 6.632817145 |
6 | MGT | 7 | 7 | 3 | 16.452442614 | 0.3427592211 | 3.616759673 |
7 | SLP | 43 | 57 | 24 | 309.70719895 | 1.164312778 | 110.88402208 |
8 | USDC | 2215 | 1102 | 300 | 21581.706795315 | 0.2603436408 | 784.093125758 |
9 | WETH | 649 | 530 | 125 | 9951.010956679 | 0.3064489701 | 592.452883226 |
10 | LUAUSD | 120 | 109 | 26 | 4003.8367902 | 0.3633905237 | 624.951393179 |
11 | ANIMA | 3 | 6 | 2 | 2.010105376 | 0.09571930361 | 0.7356793689 |
12 | LUA | 121675 | 3022 | 2195 | 964556.917726024 | 1.328095047 | 15031.823333333 |
13 | PIXEL | 397 | 340 | 72 | 3706.933364805 | 0.4629615792 | 1181.678847217 |
14 | AXS | 606 | 495 | 151 | 3287.802168182 | 0.5997450143 | 186.605343858 |
Afonso_DiazBy Asset
Updated 2025-04-07
999
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,
tokens.symbol,
(a.decoded_log:acceptedSettlePrice / pow(10, decimals)) as price,
price * token_price_usd as price_usd,
quantity,
token_id,
a.decoded_log:settleToken::string 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
left join ronin.core.dim_contracts tokens on address = a.decoded_log:settleToken
where event_name = 'OrderMatched'
and decoded_log:order[0]:extraData[0][2] = token_id
and decoded_log::string ilike '%' || from_address || '%'
and tx_succeeded
and price > 0
),
Last run: 17 days ago
14
834B
25s