flipside

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

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