SELECT

d.DEPOSITOR_ADDRESS,

d.SYMBOL,

d.SUPPLIED_USD,

d.BLOCK_TIMESTAMP,

ROW_NUMBER() OVER (PARTITION BY d.DEPOSITOR_ADDRESS, d.BLOCK_TIMESTAMP ORDER BY d.tx_hash, d.event_index) AS rn

FROM

ethereum.aave.ez_deposits d

WHERE

d.BLOCKCHAIN = 'ethereum' AND

d.AAVE_VERSION = 'Aave AMM' AND

d.SYMBOL IS NOT NULL

),

unique_withdrawals AS (

SELECT

w.DEPOSITOR_ADDRESS,

w.SYMBOL,

w.WITHDRAWN_USD,

w.BLOCK_TIMESTAMP,

ROW_NUMBER() OVER (PARTITION BY w.DEPOSITOR_ADDRESS, w.BLOCK_TIMESTAMP ORDER BY w.tx_hash, w.event_index) AS rn

FROM

ethereum.aave.ez_withdraws w

WHERE

w.BLOCKCHAIN = 'ethereum' AND

w.AAVE_VERSION = 'Aave AMM' AND

w.SYMBOL IS NOT NULL

),

flash_loans AS (

SELECT DISTINCT

b.BORROWER_ADDRESS,

b.SYMBOL,

b.BLOCK_TIMESTAMP

FROM

ethereum.aave.ez_borrows b

JOIN