SELECT

block_timestamp,

tx_hash,

origin_from_address,

row_number() over (

partition by origin_from_address

ORDER BY

block_timestamp

) as rank

FROM

(

SELECT

block_timestamp,

tx_hash,

origin_from_address

FROM

gnosis.defi.ez_lending_deposits

WHERE

platform ilike '%spark%'

UNION

SELECT

block_timestamp,

tx_hash,

origin_from_address

FROM

gnosis.defi.ez_lending_borrows

WHERE

platform ilike '%spark%'

UNION

SELECT

block_timestamp,

tx_hash,

origin_from_address

FROM

gnosis.defi.ez_lending_withdraws