saeedmzn2024-04-01 06:26 PM
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
›
⌄
-- select *
-- from blast.core.ez_native_transfers
-- where ORIGIN_FROM_ADDRESS = lower('0xeEBbAf298bb8B5076723d69AF61bf75a5C2ad8d6')
-- order by BLOCK_TIMESTAMP desc
-- where tx_hash= '0x50c8718cfca126a15c76af059fd5dae57a83531e725cb63fb1dff58d13595966'
-- where ORIGIN_FUNCTION_SIGNATURE = '0x98d8abf0' --deposit
-- where FROM_ADDRESS ='0xc02819a157320ba2859951a1dfc1a5e76c424dd4'
with borrow as (
select ORIGIN_FROM_ADDRESS borrower ,
amount_usd
from blast.core.ez_native_transfers
where ORIGIN_FUNCTION_SIGNATURE ='0x98d8abf0'
and FROM_ADDRESS = '0xc02819a157320ba2859951a1dfc1a5e76c424dd4'
and ORIGIN_FROM_ADDRESS = to_address
group by 1,2
)
select sum (amount_usd)
from borrow
QueryRunArchived: QueryRun has been archived