with tab1 as (

select BLOCK_TIMESTAMP::date as day

,TX_HASH

from ronin.nft.ez_nft_transfers

where ORIGIN_TO_ADDRESS='0xfff9ce5f71ca6178d3beecedb61e7eff1602950e'

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

),

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 Tab1.day

,sum(TX_FEE) as "Network Fee"

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

,sum(CUMULATIVE_GAS_USED*GAS_PRICE) as "Fee Paid"

,sum("Fee Paid")over(order by tab1.day) as "Total Fee Paid"

from tab1

left join tab2

on tab1.TX_HASH=tab2.TX_HASH

and tab1.day=tab2.day

group by 1