nt.NAME,

count(distinct nt.TX_HASH) as trades,

count(distinct nt.FROM_ADDRESS) as n_sellers,

count(distinct tt.ORIGIN_FROM_ADDRESS) as n_buyers,

count(distinct TOKEN_ID) as n_tokens,

sum(AMOUNT_USD)as volume,

avg(AMOUNT_USD)as avg_volume,

median(AMOUNT_USD)as median_volume,

max(AMOUNT_USD)as max_volume,

from ronin.nft.ez_nft_transfers nt

join ronin.core.ez_token_transfers tt on nt.TX_HASH = tt.TX_HASH and nt.TO_ADDRESS = tt.ORIGIN_FROM_ADDRESS

where nt.NAME ilike 'Axie%'

and tt.ORIGIN_FROM_ADDRESS = tt.FROM_ADDRESS

and nt.BLOCK_TIMESTAMP::date>='2025-01-01'

group by 1

order by 6 desc