MARKET | Max Trade Price | Avg Trade Price | Med Trade Price | Min Trade Price | |
|---|---|---|---|---|---|
1 | Axie Market | 8143.42 | 7.176509883 | 2.6 | 0 |
0-MIDTrade Price Stats
Updated 2025-03-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 tab1 as (
select
FROM_ADDRESS
,TO_ADDRESS
,TOKEN_ID
,NAME
,TX_HASH
from ronin.nft.ez_nft_transfers
where ORIGIN_TO_ADDRESS='0xfff9ce5f71ca6178d3beecedb61e7eff1602950e'
),
tab2 as (
select --BLOCK_TIMESTAMP::date as day
AMOUNT_USD
,ORIGIN_FROM_ADDRESS
,TX_HASH
from ronin.core.ez_token_transfers
where ORIGIN_FROM_ADDRESS=FROM_ADDRESS
and BLOCK_TIMESTAMP::date>=current_date-1
)
select 'Axie Market' as market
,max(AMOUNT_USD)as "Max Trade Price"
,avg(AMOUNT_USD)as "Avg Trade Price"
,median(AMOUNT_USD)as "Med Trade Price"
,min(AMOUNT_USD)as "Min Trade Price"
from tab1
left join tab2
on tab1.TX_HASH=tab2.TX_HASH
and tab1.TO_ADDRESS=tab2.ORIGIN_FROM_ADDRESS
group by 1
order by 1
Last run: 12 days ago
1
43B
3s