Abbas_ra21boba network Factory: Contracts Deploying activity copy
    Updated 2025-05-08
    -- forked from SwellChain Factory: Contracts Deploying activity @ https://flipsidecrypto.xyz/studio/queries/9577b6a3-45e1-418f-b80d-741839401b2a

    -- forked from The Law Offices of NEAR part 2 @ https://flipsidecrypto.xyz/studio/queries/49827d4c-92df-45a5-b4d8-5684a183fd40

    select
    'All time' AS Time,
    count (DISTINCT TO_ADDRESS) as Total_contracts
    from
    boba.core.fact_traces
    where
    TYPE like 'CREATE%'
    union ALL
    select
    'last 60 days' AS Time,
    count (DISTINCT TO_ADDRESS) as Total_contracts
    from
    boba.core.fact_traces
    where
    TYPE like 'CREATE%'
    and BLOCK_TIMESTAMP::date >= current_date - 60
    union ALL
    select
    'last 30 days' AS Time,
    count (DISTINCT TO_ADDRESS) as Total_contracts
    from
    boba.core.fact_traces
    where
    TYPE like 'CREATE%'
    and BLOCK_TIMESTAMP::date >= current_date - 30
    union ALL
    select
    'last 7 days' AS Time,
    count (DISTINCT TO_ADDRESS) as Total_contracts
    from
    boba.core.fact_traces
    where
    QueryRunArchived: QueryRun has been archived