SELECT

tx_hash

FROM

near.core.fact_transactions

WHERE

block_timestamp >= '2023-03-01'

),

relayed_transactions AS (

SELECT

tx_hash

FROM

near.core.fact_actions_events

WHERE

action_name = 'Delegate'

AND receipt_succeeded = TRUE

AND block_timestamp >= '2023-03-01'

SELECT

COUNT(DISTINCT b.tx_hash) AS total_relayed_stake_transactions

FROM

stake_transactions b

JOIN

relayed_transactions r

ON b.tx_hash = r.tx_hash;