Eman-Raz🔎Transactions Tracker (volume>10k $USD)
Updated 2024-04-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with deposit as (select depositor as "Address", amount_usd as "Volume (USD)", block_timestamp::date as "Date", tx_hash as "TX Hash", 'Deposit' as "Action"
from arbitrum.defi.ez_lending_deposits
where platform='Silo' and event_name='Deposit' and amount_usd>=10000),
withdraw as (select depositor as "Address", amount_usd as "Volume (USD)", block_timestamp::date as "Date", tx_hash as "TX Hash", 'Withdraw' as "Action"
from arbitrum.defi.ez_lending_withdraws
where platform='Silo' and event_name='Withdraw' and amount_usd>=10000),
borrow as (select borrower as "Address", amount_usd as "Volume (USD)", block_timestamp::date as "Date", tx_hash as "TX Hash", 'Borrow' as "Action"
from arbitrum.defi.ez_lending_borrows
where platform='Silo' and event_name='Borrow' and amount_usd>=10000),
repay as (select borrower as "Address", amount_usd as "Volume (USD)", block_timestamp::date as "Date", tx_hash as "TX Hash", 'Repay' as "Action"
from arbitrum.defi.ez_lending_repayments
where platform='Silo' and event_name='Repay' and amount_usd>=10000)
select * from deposit union all
select * from withdraw union all
select * from borrow union all
select * from repay
Auto-refreshes every 6 hours
QueryRunArchived: QueryRun has been archived