adambalaMetrics on True Freeze
Updated 2022-11-27
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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