Cipher009-CpUJ5ktranslating_dune_to_flipside
    Updated 2024-06-26
    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'

    union all

    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';

    QueryRunArchived: QueryRun has been archived