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