headitmanager Deposits of Ethereum
Updated 2022-07-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with polygon_start_data as (select min(block_timestamp) as p_date from crosschain.ez_borrowing where blockchain='polygon')
, ethereum_start_data as (select min(block_timestamp) as e_date from crosschain.ez_borrowing where blockchain='ethereum')
, deposited as (select count(*),sum(amount_usd),symbol,blockchain from crosschain.ez_lending where action='Deposit'
and symbol in ('sUSD','UST','USDT','USDC','TUSD','DAI')
group by symbol,blockchain)
,collateral as (select count(*),sum(amount_usd),collateral_symbol,blockchain from crosschain.ez_borrowing where action='Borrow'
and collateral_symbol in ('sUSD','UST','USDT','USDC','TUSD','DAI')
group by collateral_symbol,blockchain)
select * from deposited where blockchain='ethereum'
Run a query to Download Data