WITH borrows AS(

SELECT

DATE_TRUNC('{{period}}', block_timestamp) AS date,

token_symbol AS asset,

borrower,

tx_hash,

amount_usd

FROM avalanche.defi.ez_lending_borrows AS a

WHERE 1 = 1

AND platform = 'Benqi'

AND block_timestamp :: DATE BETWEEN '2024-01-01' AND '2024-12-31'

AND borrower IN(

SELECT borrower

FROM (

SELECT

borrower, MIN(block_timestamp)

FROM avalanche.defi.ez_lending_borrows

WHERE platform = 'Benqi'

GROUP BY borrower

HAVING MIN(block_timestamp :: DATE) BETWEEN '2024-01-01' AND '2024-12-31'

) AS sub

)

AND borrower NOT IN(SELECT address FROM avalanche.core.dim_contracts)

),

total_borrowers AS(

SELECT

COUNT(DISTINCT borrower) AS total_borrowers

FROM borrows

),

repayments AS(

SELECT

DATE_TRUNC('{{period}}', block_timestamp) AS date,

token_symbol AS asset,

borrower,