SocioAnalyticaactive users per contract POC
    Updated 2024-12-11
    SELECT * -- So far it seems that the PREDECESSOR_ID for the first call to a contract will contain the user account.
    FROM near.core.fact_actions_events_function_call
    WHERE ACTION_NAME = 'FunctionCall'
    AND METHOD_NAME <> 'new'
    AND block_timestamp >= current_date - 1
    AND tx_hash IN ('GkSaEQDuijcKPJY4pV6P3UGz8KPYFEY7zqHgEAkKbbqQ', '3yfAJt4rGz1GsH3v1dmfuQVQfy1F4SKZqDXgqaG3ais6')
    QUALIFY ROW_NUMBER() OVER (PARTITION BY tx_hash ORDER BY block_timestamp) = 1
    QueryRunArchived: QueryRun has been archived