adambalaMetrics on True Freeze
    Updated 2022-11-27
    with bank_swaps as (
    select
    tx_id
    from ethereum.dex_swaps
    where direction= 'OUT' and token_address = '0x55b1e2d8b13e7acad03353fad58fc3fa065c5822' )

    select name ,count(distinct tx_id)
    from ethereum.dex_swaps inner join ethereum.core.dim_contracts
    on lower(address)=lower(TOKEN_ADDRESS)
    where tx_id in (select* from bank_swaps)
    and token_address != '0x55b1e2d8b13e7acad03353fad58fc3fa065c5822' group by 1
    Run a query to Download Data