SELECT

tx_hash

FROM

near.defi.ez_dex_swaps

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_swap_transactions

FROM

swap_transactions b

JOIN

relayed_transactions r

ON b.tx_hash = r.tx_hash;