DATE | TYPE | SENDER | NO_TXN | |
---|---|---|---|---|
1 | 2023-01-25 00:00:00.000 | nft | 622 | 2584 |
2 | 2023-01-11 00:00:00.000 | nft | 695 | 3247 |
3 | 2023-08-21 00:00:00.000 | nft | 494 | 1251 |
4 | 2023-10-30 00:00:00.000 | nft | 381 | 1130 |
5 | 2024-01-02 00:00:00.000 | nft | 366 | 807 |
6 | 2023-12-11 00:00:00.000 | nft | 542 | 1287 |
7 | 2023-05-16 00:00:00.000 | nft | 592 | 1721 |
8 | 2023-11-07 00:00:00.000 | nft | 620 | 1871 |
9 | 2023-02-13 00:00:00.000 | nft | 666 | 3050 |
10 | 2023-05-31 00:00:00.000 | dex | 180 | 538 |
11 | 2023-04-15 00:00:00.000 | defi | 38 | 50 |
12 | 2023-07-09 00:00:00.000 | nft | 679 | 1912 |
13 | 2023-02-19 00:00:00.000 | defi | 60 | 138 |
14 | 2023-06-19 00:00:00.000 | dex | 99 | 216 |
15 | 2023-12-02 00:00:00.000 | dex | 159 | 481 |
16 | 2023-07-26 00:00:00.000 | dex | 138 | 554 |
17 | 2023-08-24 00:00:00.000 | dapp | 25 | 45 |
18 | 2023-07-19 00:00:00.000 | dapp | 20 | 34 |
19 | 2023-02-18 00:00:00.000 | dapp | 50 | 66 |
20 | 2023-09-05 00:00:00.000 | dex | 97 | 282 |
MLDZMNblend7
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
block_timestamp::date as date,
l.LABEL_TYPE as type,
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,2
Last run: about 1 year ago
...
1556
63KB
40s