flipside

    LB 2
    MLDZMNLB 2
    Updated 2024-04-21
    -- How many users are deposted into the Aave over the past month?
    select
    count(distinct DEPOSITOR) as "Total depositors"
    from
    ethereum.defi.ez_lending_deposits
    where
    PLATFORM in ('Aave V3', 'Aave V2')
    and Block_timestamp >= current_date - INTERVAL '1 MONTH'
    QueryRunArchived: QueryRun has been archived