flipside

    Percentage of other transfer(chains) that airswap users transfer to
    ydcny555Percentage of other transfer(chains) that airswap users transfer to
    Updated 2022-10-22
    with airswap_users as
    (
    select distinct from_address as users from ethereum.core.ez_token_transfers
    where to_address='0x579120871266ccd8de6c85ef59e2ff6743e7cd15'
    )

    select count(distinct tx_hash) , label from ethereum.core.ez_token_transfers inner join ethereum.core.dim_labels
    on ADDRESS=to_address
    where from_address in (select users from airswap_users) and label_type='layer2'
    group by label
    Run a query to Download Data