sum(TRANSACTION_FEE/pow(10,24)) as Fee_in_near,

sum(TRANSACTION_FEE/pow(10,24)) * avg(price_usd) as Fee_in_usd,

avg(price_usd) as near_price

from near.core.fact_transactions inner join near.core.fact_prices p

on TIMESTAMP::date = block_timestamp::date

where block_timestamp > CURRENT_DATE - 31

and tx_status = 'Success'

and symbol = 'wNEAR'