-- forked from Number of users and transactions by method_name @ https://flipsidecrypto.xyz/edit/queries/21577c44-5d7c-4afe-a9cc-23d50a255215

-- forked from Number of users and transactions @ https://flipsidecrypto.xyz/edit/queries/89b08bfa-3f2d-413b-abb3-44c25b447496

SELECT

count(DISTINCT tx_signer) as n_users,

count(DISTINCT tx_hash) as n_txns

FROM near.core.fact_transactions

WHERE tx_receiver = 'aurora'

AND block_timestamp::date >= current_date - interval '{{last_period}}'

AND tx_status = 'Success'