MLDZMNusers5
    Updated 2023-05-21
    with t1 as (select
    to_address
    FROM ethereum.core.ez_token_transfers
    WHERE contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
    and block_timestamp>= '2023-05-15'
    and from_address not in ('0x0000000000000000000000000000000000000000')
    )


    select
    l.LABEL as project,
    count(distinct t.from_address) as sender,
    count(distinct t.tx_hash) as no_txn
    from ethereum.core.fact_transactions t join ethereum.core.dim_labels l on t.to_address = l.address
    where t.block_timestamp>= '2023-05-15'
    and l.label_subtype != 'token_contract'
    and l.LABEL_TYPE in ('defi','nft','dex','dapp')
    and t.STATUS = 'SUCCESS'
    and t.from_address in (select to_address from t1)
    and project <> 'lido'
    group by 1 having project is not null
    order by 3 desc limit 10
    Run a query to Download Data