Eman-RazSilo TVL
Updated 2023-12-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with deposit as (select sum(amount_usd) as "Deposit Volume (USD)", count(distinct tx_hash) as "Deposit Count", count(distinct depositor) as "Depositor Count"
from arbitrum.defi.ez_lending_deposits
where platform='Silo' and event_name='Deposit'),
withdraw as (select sum(amount_usd) as "Withdraw Volume (USD)"
from arbitrum.defi.ez_lending_withdraws
where platform='Silo' and event_name='Withdraw'),
borrow as (select sum(amount_usd) as "Borrow Volume (USD)", count(distinct tx_hash) as "Borrow Count", count(distinct Borrower) as "Borrower Count"
from arbitrum.defi.ez_lending_borrows
where platform='Silo' and event_name='Borrow'),
repay as (select sum(amount_usd) as "Repay Volume (USD)"
from arbitrum.defi.ez_lending_repayments
where platform='Silo' and event_name='Repay')
select * from deposit , withdraw , borrow , repay
QueryRunArchived: QueryRun has been archived