select

distinct tx_hash,

transaction_fee as tx_fee

from

near.core.fact_transactions b

where

(

tx_receiver = 'v1.nadabot.near'

or tx_signer = 'v1.nadabot.near'

and tx_succeeded = TRUE

)

),

qmain as (

select

block_timestamp,

ARGS,

b.tx_hash,

signer_id,

ACTION_NAME,

receiver_id,

method_name,

--args,

deposit / 1e24 as deposit

from

near.core.fact_actions_events_function_call b,

txns

where

b.tx_hash = txns.tx_hash

),

main as (

SELECT

block_timestamp,

signer_id,

receiver_id,