Moelend
    Updated 2022-06-29
    select
    --'LENDING' as action,
    date_trunc(day,BLOCK_TIMESTAMP):: date as days,
    case when days between '2022-05-09' and '2022-05-20' then 'market volatility' else'other' end as day_type,
    count(distinct TX_HASH) as count_tx,
    sum(AMOUNT_USD) as amount,
    count(distinct DEPOSITOR) as users
    from
    ethereum.sushi.ez_lending
    where
    BLOCK_TIMESTAMP >= '2022-01-01'
    group by 1,2

    Run a query to Download Data