count(distinct tx_signer) as wallet

from near.core.fact_transactions

where

tx_receiver in ('v2.perp.spin-fi.near','spot.spin-fi.near','boostfarm.ref-labs.near','staking.v1.pembrock.near',

'token.v2.ref-finance.near','near','meta-pool.near','contract.main.burrow.near','v1.jumbo_exchange.near','claiming-v1.jumbo_exchange.near',

'linear-protocol.near','token.jumbo_exchange.near','farming-v1.jumbo_exchange.near','v2-nearx.stader-labs.near',

'nearx.stader-labs.near','v1.pembrock.near','rewards.v1.pembrock.near','v3.oin_finance.near','ref-finance.sputnik-dao.near','nearx-price-feed.stader-labs.near','xtoken.ref-finance.near')

group by collection

limit 10