DataFi2024-04-03 03:28 PM
Updated 2024-04-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with rwa_token as (
select '0x57e114b691db790c35207b2e685d4a43181e6061' as token_address, 'Ethena' as name union all
select '0xfaba6f8e4a5e8ab82f62fe7c39859fa577269be3' as token_address, 'Ondo Finance' as name union all
select '0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2' as token_address, 'Marker RWA' as name union all
select '0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f' as token_address, 'Synthetix' as name union all
select '0x6123b0049f904d730db3c36a31167d9d4121fa6b' as token_address, 'Ribbon Finance' as name
)
select
date_trunc('day',e.block_timestamp) as time,
r.name,
COUNT(DISTINCT e.borrower)
from ethereum.defi.ez_lending_flashloans e
inner join rwa_token r on e.token_address = r.token_address
where e.block_timestamp >= current_date() - interval '180 days'
group by 1,2
SELECT *
from ethereum.core.ez_token_transfers
where to_address = '0xfaba6f8e4a5e8ab82f62fe7c39859fa577269be3'
QueryRunArchived: QueryRun has been archived