sarathkashi stable coins 2
Updated 2022-07-10
9
1
2
3
4
5
6
7
8
›
⌄
with data1 as (select date(block_timestamp) as date,tx_hash,origin_from_address,action,symbol,amount_usd from ethereum.sushi.ez_lending where
symbol in ('USDC','USDT','DAI','UST','FEI','FRAX','BUSD','TUSD','sUSD') and action = 'Deposit'
)
select date,symbol as tokens ,count(tx_hash) as transactions, count(distinct origin_from_address) as users,
sum(amount_usd) as volume
from data1
where date > '2022-06-05'
group by 1,2
Run a query to Download Data