Afonso_DiazBy Tokens Overtime
Updated 2025-03-26
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
ronin.price.ez_prices_hourly
where
symbol = 'RON'
and token_address is null
group by 1
),
main 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,
a.decoded_log:acceptedSettlePrice / 1e18 as price,
price * token_price_usd as price_usd,
token_id
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
where
event_name = 'OrderMatched'
and decoded_log:order[0]:extraData[0][2] = token_id
and tx_succeeded
and collection_name = 'Nyang Kit'
QueryRunArchived: QueryRun has been archived