Alexaynear users total
    Updated 2022-10-26
    SELECT COUNT(DISTINCT TX_SIGNER) AS users
    FROM near.core.fact_actions_events_function_call a
    JOIN near.core.fact_transactions b ON a.TX_HASH = b.TX_HASH
    WHERE (a.METHOD_NAME='nft_buy' or a.method_name='nft_mint')
    AND a.BLOCK_TIMESTAMP::DATE> CURRENT_DATE -90
    Run a query to Download Data