MLDZMNusa9
    Updated 2023-02-28
    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