PROJECT | SENDER | NO_TXN | |
---|---|---|---|
1 | blur | 4088 | 236173 |
2 | blur.io | 2532 | 162514 |
3 | uniswap | 2211 | 117827 |
4 | opensea | 2682 | 82648 |
5 | looksrare | 1033 | 11015 |
6 | uniswap_v3 | 468 | 9561 |
7 | metamask | 1002 | 8030 |
8 | 1inch | 644 | 7807 |
9 | x2y2 | 1038 | 7670 |
10 | 0x | 432 | 6131 |
MLDZMNblend8
Updated 2024-01-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with decoded_date as (select *,
concat('0x',substring(data, 155, 40)) AS collection,
concat('0x',substring(data, 219, 40)) as lender,
concat('0x',substring(data, 283, 40)) as borrower,
ethereum.public.udf_hex_to_int(substring(data, 371, 16))::float/1e18 as loan_Amount,
ethereum.public.udf_hex_to_int(substring(data, 448, 3))::float as rate,
ethereum.public.udf_hex_to_int(substring(data, 511, 4))::float as tokenID
from ethereum.core.fact_event_logs
where contract_address='0x29469395eaf6f95920e59f858042f0e28d98a20b'
and TOPICS[0] = '0x06a333c2d6fe967ca967f7a35be2eb45e8caeb6cf05e16f55d42b91b5fe31255' --- loantaken
)
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-01-01'
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 lender from decoded_date)
group by 1 having project is not null
order by 3 desc limit 10
Last run: about 1 year ago
10
219B
43s