SELECT DATE_TRUNC('day',tr.block_timestamp) as DAY, COUNT(DISTINCT tr.TX_HASH) as number_transactions, COUNT(DISTINCT tr.TX_SIGNER) as users,
SUM(TRANSACTION_FEE)/POW(10,24) as transaction_fees, tr.tx:actions[0]:FunctionCall:method_name as label
FROM near.core.fact_transactions tr
WHERE tx_receiver = 'zomland.near'
AND DAY >= '2022-05-15'
GROUP BY DAY, label