DataFi2024-04-03 03:28 PM
    Updated 2024-04-03
    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