MLDZMNusers5
Updated 2023-05-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
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