Abbas_ra21Daily Supply comparative
    Updated 2024-05-10
    select
    date_trunc('{{Interval}}',BLOCK_TIMESTAMP) AS Date,
    PLATFORM,
    sum(
    case
    when Amount_USD is not null then Amount_USD
    else Amount * Price
    end
    ) AS Volume,
    count(DISTINCT DEPOSITOR) AS Users,
    count(*) AS Events
    from
    base.defi.ez_lending_deposits A
    inner join base.price.ez_hourly_token_prices B on B.TOKEN_ADDRESS = A.TOKEN_ADDRESS
    and HOUR = date_trunc('hour', BLOCK_TIMESTAMP)
    and Date >= current_date - {{comparison_duration_D}}
    group by
    1,2




    QueryRunArchived: QueryRun has been archived