datavortexDeployer by contract call
    Updated 2024-12-06
    WITH top_deployers AS (
    SELECT
    signer_id AS deployer,
    COUNT(DISTINCT tx_hash) AS total_contracts_deployed
    FROM
    near.core.fact_actions_events
    WHERE
    action_name = 'DeployContract'
    AND receipt_succeeded = TRUE
    GROUP BY
    signer_id
    ORDER BY
    total_contracts_deployed DESC
    LIMIT
    7
    ), categorized_methods AS (
    SELECT
    signer_id,
    method_name,
    CASE
    WHEN method_name IN (
    'ft_transfer_call',
    'ft_resolve_transfer',
    'ft_on_transfer',
    'ft_transfer'
    ) THEN 'Token Transfers'
    WHEN method_name IN (
    'add_request_and_confirm',
    'add_liquidity',
    'forward',
    'forward_tokens'
    ) THEN 'Liquidity Management'
    WHEN method_name IN (
    'withdraw_reward',
    'claim_reward_by_seed',
    'claim',
    QueryRunArchived: QueryRun has been archived