select NFT_FROM_ADDRESS as borrower,

TX_HASH as borrowHash,

NFT_ADDRESS,

PROJECT_NAME

from ethereum.core.ez_nft_transfers

where NFT_TO_ADDRESS='0x29469395eaf6f95920e59f858042f0e28d98a20b'

),

repay as (

select NFT_TO_ADDRESS as borrower,

TX_HASH as repayHash

from ethereum.core.ez_nft_transfers

where NFT_FROM_ADDRESS='0x29469395eaf6f95920e59f858042f0e28d98a20b'

SELECT date_trunc('day', block_timestamp) as day,

sum(RAW_AMOUNT/1e18) as "ETH Borrowed"

FROM ethereum.core.fact_token_transfers

WHERE ORIGIN_TO_ADDRESS='0x29469395eaf6f95920e59f858042f0e28d98a20b'

and CONTRACT_ADDRESS='0x0000000000a39bb272e79075ade125fd351887ac'

and TX_HASH in (select distinct borrowHash from borrow)

GROUP BY 1

SELECT count(*),

CASE ORIGIN_FUNCTION_SIGNATURE

WHEN '0x736da5ad' THEN 'refinance'

WHEN '0x06aec5ef' THEN 'takeBid'

WHEN '0xe263967e' THEN 'borrow'

WHEN '0x5b43226f' THEN 'seize'

WHEN '0x3ed7d74d' THEN 'buyToBorrowETH'

WHEN '0xb2a0bb86' THEN 'buyToBorrowLockedETH'