DATE_TRUNC('{{period}}',tr.block_timestamp) as date,

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 = 'pixelparty.near'

AND date >= '2021-04-01'

GROUP BY date, label