with txs_ethereum as (

SELECT

block_timestamp,

tx_hash,

action,

user,

contract_address,

protocol_market,

collateral_token_address,

collateral_token_symbol,

debt_token_address,

debt_token_symbol,

amount,

amount_usd,

row_number() over (

partition by user

ORDER BY

block_timestamp

) as rank,

'ethereum' as blockchain

FROM

(

SELECT

block_timestamp,

tx_hash,

'deposit' as action,

depositor as user,

contract_address,

protocol_market,

token_address as collateral_token_address,

token_symbol as collateral_token_symbol,

'' as debt_token_address,

'' as debt_token_symbol,

amount,

amount_usd