headitmanager Deposits of Ethereum
    Updated 2022-07-10
    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