with tab1 as (

select --BLOCK_TIMESTAMP::date as day

from ronin.nft.ez_nft_transfers

where ORIGIN_TO_ADDRESS='0xfff9ce5f71ca6178d3beecedb61e7eff1602950e'

and BLOCK_TIMESTAMP::date>=current_date-1

),

tab2 as (

select --BLOCK_TIMESTAMP::date as day

TX_HASH

,TX_FEE

,GAS_USED

,GAS_PRICE/1e9 as gas_price

,CUMULATIVE_GAS_USED

from ronin.core.fact_transactions

select 'Axie Market' as platform

,avg(TX_FEE) as "Network Fee"

,avg((CUMULATIVE_GAS_USED-GAS_USED)*GAS_PRICE) as "Platform Fee"

,avg(CUMULATIVE_GAS_USED*GAS_PRICE) as "Total Fee"

from tab1

left join tab2

on tab1.TX_HASH=tab2.TX_HASH

group by 1