olavtop 10 withdrawer
Updated 2022-09-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
origin_from_address as wallet_address,
count(distinct(tx_hash)) as tx_num,
sum(amount) as amount_eth,
sum(amount_usd) as amount_usd
from ethereum.core.ez_token_transfers
where origin_to_address = lower('0x3B968D2D299B895A5Fcf3BBa7A64ad0F566e6F88')
and block_timestamp::date >= current_date - interval '{{ month_number }} months'
and origin_function_signature = '0x36118b52' --withdraw function signature
and symbol = 'WETH'
group by wallet_address
order by amount_usd desc
limit 10
Run a query to Download Data