Afonso_DiazUntitled Query
Updated 2023-01-23
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
origin_from_address as swapper,
count(distinct tx_hash) as swaps_count,
sum(amount_in_usd) as swap_volume
from ethereum.core.ez_dex_swaps
where block_timestamp > current_date - 90
and '0x92d6c1e31e14520e676a687f0a93788b716beff5' in (token_in, token_out)
group by swapper
order by swaps_count desc
limit 10
Run a query to Download Data