bridges as ( -- bridge users table

select

tx_signer,

min(block_timestamp) as debut

from near.core.fact_transactions

where tx_receiver = 'wrap.near'

group by 1

)

select

x.tx_receiver as protocol,

count(distinct tx_hash) as transactions

from near.core.fact_transactions x

join bridges y on x.tx_signer=y.tx_signer and x.block_timestamp>y.debut

GROUP BY 1

Order by 2 DESC

limit 10