kaibladeWeekly Number of Active Developers
    Updated 2023-01-21
    WITH deploy_actions As
    (SELECT *
    FROM near.core.fact_actions_events
    WHERE action_name ILIKE '%deploy%'
    ),

    deploy_tx AS
    (SELECT *
    FROM near.core.fact_transactions
    WHERE tx_hash IN (SELECT tx_hash FROM deploy_actions)
    ),

    weekly_dev AS
    (SELECT DATE_TRUNC('week', block_timestamp) AS "Weeks",
    COUNT (DISTINCT tx_signer) AS "Number of Developers"
    FROM deploy_tx
    GROUP BY "Weeks")

    SELECT *,
    (CASE
    WHEN "Weeks" ILIKE '%2023%' THEN 'Year 2023'
    WHEN "Weeks" ILIKE '%2022%' THEN 'Year 2022'
    WHEN "Weeks" ILIKE '%2021%' THEN 'Year 2021'
    WHEN "Weeks" ILIKE '%2020%' THEN 'Year 2020'
    END) AS "Years"
    FROM weekly_dev








    -- WHERE tx_hash = '5TzgKyiaBhKUVii7vER3FQ4iKGg9my7RHfjwUzPLQMQS'

    Run a query to Download Data