MLDZMNsne6
Updated 2023-02-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with tb1 as (select
distinct ORIGIN_FROM_ADDRESS as wallets
from ethereum.core.fact_event_logs
where ORIGIN_TO_ADDRESS='0x881d40237659c251811cec9c364ef91dc08d300c'
and EVENT_NAME='Swap')
select
USER_ADDRESS,
CURRENT_BAL as blnce,
row_number() over (order by blnce desc) as rank1
from ethereum.core.ez_current_balances
where USER_ADDRESS in (select wallets from tb1)
and CONTRACT_ADDRESS= lower('0x85F17Cf997934a597031b2E18a9aB6ebD4B9f6a4')
order by 2 desc limit 10
Run a query to Download Data