MLDZMNusa9
Updated 2023-02-28Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with tb1 as (select
BLOCK_TIMESTAMP,
tx_hash,
DEPOSITOR_ADDRESS,
SUPPLIED_USD
from ethereum.aave.ez_deposits)
select
Label,
count(tx_hash) as usages
from Ethereum.core.fact_transactions x join ethereum.core.dim_labels y on x.TO_ADDRESS= y.address
where label_subtype != 'token_contract'
and LABEL_TYPE in ('dapp','defi')
and STATUS = 'SUCCESS'
and label not ilike '%Aave%'
and label not ilike '%mev bot%'
and FROM_ADDRESS in (select DEPOSITOR_ADDRESS from tb1)
group by 1
order by 2 desc limit 10
Run a query to Download Data