hessTop Swappers Based on Volume
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with swap as (select 'Swap to AAVE' as type, origin_from_address,
count(DISTINCT(tx_hash)) as transaction, count(DISTINCT(origin_from_address)) as users,
sum(amount_out) as volume
from ethereum.core.ez_dex_swaps
where block_timestamp::date >= '2023-06-20'
and TOKEN_OUT = lower('0x7Fc66500c84A76Ad7e9c93437bFc5Ac33E2DDaE9')
group by 1,2)
select origin_from_address, volume
from swap
order by 2 desc
limit 25
Run a query to Download Data