Moelend
Updated 2022-06-29Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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