-- forked from m3ji / User Activities Overview @ https://flipsidecrypto.xyz/m3ji/q/JlL2mysppFVG/user-activities-overview

with txs_gnosis_ 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,

'gnosis' 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

FROM