nitsMetamask Top 10 DEX Contracts
Updated 2022-06-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH metamask as
(SELECT DISTINCT origin_from_address as ofa from ethereum.core.ez_token_transfers
where origin_to_address = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
),
contracts as
(select contract_address as ca , count(DISTINCT origin_from_address) as popular_by_users
from ethereum.core.fact_event_logs
where origin_from_address in (SELECT * from metamask) and ca != '0x881d40237659c251811cec9c364ef91dc08d300c'
GROUP by 1
order by 2 desc )
SELECT * from
( SELECT * from contracts
inner join ethereum.core.dim_labels
on ca = address )
where label_type ='dex'
ORDER by 2 desc
limit 10
Run a query to Download Data