date_trunc('day', block_timestamp) as DATE,

count(DISTINCT tx_signer) as Users,

count(DISTINCT tx_hash) as Trxs,

tx:actions[0]:FunctionCall:method_name as FUNCTION ,

sum(TRANSACTION_FEE)/POW(10,24) as fee

FROM near.core.fact_transactions

WHERE tx_receiver ='x.paras.near'

or tx_receiver ='marketplace.paras.near'

GROUP BY DATE, FUNCTION

order by DATE