supply as (

select

tx_hash,

block_timestamp,

args:amount as amount_unadj,

signer_id as user,

predecessor_id as token_address,

'Supply' as event_name

from

near.core.fact_actions_events_function_call

join

lateral flatten (input => logs) f

where

receipt_succeeded

and receiver_id = 'v1.nearlend-official.near'

and method_name = 'ft_on_transfer'

and try_parse_json(replace(f.value, 'EVENT_JSON:', '')):event = 'deposit'

),

borrow as (

select

tx_hash,

block_timestamp,

try_parse_json(try_parse_json(replace(f.value, 'EVENT_JSON:', '')):data)[0]:amount as amount_unadj,

signer_id as user,

try_parse_json(try_parse_json(replace(f.value, 'EVENT_JSON:', '')):data)[0]:token_id as token_address,

'Borrow' as event_name

from

near.core.fact_actions_events_function_call

join

lateral flatten (input => logs) f

where

receipt_succeeded

and receiver_id = 'v1.nearlend-official.near'