with result as (

SELECT

block_timestamp,

tx_hash,

origin_from_address,

amount_usd,

row_number() over (

partition by amount_usd

ORDER BY

block_timestamp

) as rank

FROM

(

SELECT

block_timestamp,

tx_hash,

origin_from_address,

amount_usd

FROM

base.defi.ez_lending_deposits

WHERE

1 = 1

AND platform = 'Aave V3'

AND amount_usd IS NOT NULL

AND origin_from_address NOT IN(

SELECT

address

FROM

base.core.dim_contracts

)

)

),

volume as (

SELECT