SELECT

block_number,

tx_hash,

borrower,

token_address,

amount AS borrowed_tokens

FROM

ethereum.defi.ez_lending_borrows

WHERE

platform = 'Aave V3'

AND token_address IN (LOWER('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'), LOWER('0xdAC17F958D2ee523a2206206994597C13D831ec7'), LOWER('0x6B175474E89094C44Da98b954EedeAC495271d0F'), LOWER('0x40D16FC0246aD3160Ccc09B8D0D3A2cD28aE6C2f'))

),

token_balances AS (

SELECT

block_number,

user_address,

balance / POWER(10,8) AS balance

FROM

ethereum.core.fact_token_balances

WHERE

contract_address = LOWER('0x5Ee5bf7ae06D1Be5997A1A72006FE6C607eC6DE8') -- aETHWBTC

AND balance > 0

),

wbtc_holders AS (

SELECT DISTINCT

ab.borrower

FROM

aave_borrows ab

INNER JOIN

token_balances tb

ON ab.borrower = tb.user_address

AND tb.block_number >= (ab.block_number - 250)

AND tb.block_number < ab.block_number

),

latest_balance_before_borrow AS (