near-toll-audit / pipeline/sql/16_intents_signers_oct.sql · raw
-- Who signs direct calls into intents.near: the largest signers in the last full month.SELECT signer_account_id AS signer, COUNT(*) AS txsFROM `bigquery-public-data.crypto_near_mainnet_us.transactions`WHERE block_date BETWEEN '2026-10-01' AND '2026-10-31' AND receiver_account_id = 'intents.near'GROUP BY 1 ORDER BY 2 DESC LIMIT 40