SELECT date_trunc('{{interval}}',block_timestamp) as date,

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

count(DISTINCT tx_signer) as n_users,

count(DISTINCT tx_hash) as n_txns

FROM near.core.fact_transactions

WHERE tx_receiver = 'aurora'

AND tx_signer not in ('aurora.near', 'relay.aurora')

AND block_timestamp::date >= '2021-08-25'

AND tx_status = 'Success'

GROUP BY 1,2