SpiltadavidTotal transactions on Zomland
    Updated 2022-11-19
    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
    Run a query to Download Data