alitaslimiArbitrum | List of Top Addresses Interacted by BTC.b Users
    Updated 2025-02-19
    select
    origin_to_address as "Address",
    project_name as "Label",
    count(distinct tx_hash) as "Transactions",
    count(distinct origin_from_address) as "Users"
    from
    arbitrum.core.ez_decoded_event_logs logs
    join arbitrum.core.dim_labels labels on logs.origin_to_address = labels.address
    where
    tx_status = 'SUCCESS'
    and contract_address = '0x2297aebd383787a160dd0d9f71508148769342e3'
    group by
    "Address",
    "Label"
    order by
    "Transactions" desc