(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')

),

qmain as (

select block_timestamp,

ARGS,

b.tx_hash,

signer_id,

ACTION_NAME,

receiver_id,

method_name,

--args,

deposit / 1e24 as deposit,

PARSE_JSON(ARGS) :provider_id AS contract_address_check_type,

COALESCE(TRY_PARSE_JSON(ARGS):provider.name,'') AS sybil_name,

SPLIT_PART(PARSE_JSON(ARGS):provider_id, ':', 1) AS contract_address,

SPLIT_PART(PARSE_JSON(ARGS):provider_id, ':', 2) AS check_type,

COALESCE(TRY_PARSE_JSON(ARGS):provider.default_weight, 0)::INT AS weight,

tx_fee

from near.core.fact_actions_events_function_call b, txns

where b.tx_hash = txns.tx_hash

and receiver_id = 'v1.nadabot.near'

and method_name = 'verify_stamp_callback'

),

ranked_data AS (

SELECT

sybil_name,

contract_address_check_type,

contract_address,

check_type,

weight,

block_timestamp,

ROW_NUMBER() OVER (PARTITION BY contract_address_check_type ORDER BY block_timestamp DESC) AS rn