Cipher009-CpUJ5kPyth_Contracts_2
    Updated 2024-06-26
    select 'Ethereum' as network, count(distinct from_address) as unique_contract_addresses
    from ethereum.core.fact_traces
    where to_address = lower('0x4305FB66699C3B2702D4D05CF36551390A4C69C6') and tx_status = 'SUCCESS'

    union all

    select 'Gnosis' as network, count(distinct from_address) as unique_contract_addresses
    from gnosis.core.fact_traces
    where to_address = lower('0x2880AB155794E7179C9EE2E38200202908C17B43') and tx_status = 'SUCCESS'

    union all

    select 'Optimism' as network, count(distinct from_address) as unique_contract_addresses
    from optimism.core.fact_traces
    where to_address = lower('0xFF1A0F4744E8582DF1AE09D5611B887B6A12925C') and tx_status = 'SUCCESS'

    union all

    select 'Polygon' as network, count(distinct from_address) as unique_contract_addresses
    from polygon.core.fact_traces
    where to_address = lower('0xFF1A0F4744E8582DF1AE09D5611B887B6A12925C') and tx_status = 'SUCCESS';

    QueryRunArchived: QueryRun has been archived