Cipher009-CpUJ5kPyth_Contracts_1
    Updated 2024-06-26
    select 'Arbitrum' as network, count(distinct from_address) as unique_contract_addresses
    from arbitrum.core.fact_traces
    where to_address = lower('0xFF1A0F4744E8582DF1AE09D5611B887B6A12925C') and tx_status = 'SUCCESS'

    union all

    select 'Avalanche_C' as network, count(distinct from_address) as unique_contract_addresses
    from avalanche.core.fact_traces
    where to_address = lower('0x4305FB66699C3B2702D4D05CF36551390A4C69C6') and tx_status = 'SUCCESS'

    union all

    select 'Blast' as network, count(distinct from_address) as unique_contract_addresses
    from blast.core.fact_traces
    where to_address = lower('0xA2AA501B19AFF244D90CC15A4CF739D2725B5729') and tx_status = 'SUCCESS'

    union all

    select 'Binance Smart Chain' as network, count(distinct from_address) as unique_contract_addresses
    from bsc.core.fact_traces
    where to_address = lower('0x4D7E825F80BDF85E913E0DD2A2D54927E9DE1594') and tx_status = 'SUCCESS'

    union all

    select 'Base' as network, count(distinct from_address) as unique_contract_addresses
    from base.core.fact_traces
    where to_address = lower('0x8250F4AF4B972684F7B336503E2D6DFEDEB1487A') and tx_status = 'SUCCESS'
    QueryRunArchived: QueryRun has been archived