near-toll-audit / pipeline/sql/12_contracts_oct.sql · raw
-- What people actually call: top receivers in the last full month, plus every receiver whose name suggests an agent or AI product.WITH t AS ( SELECT receiver_account_id AS r, COUNT(*) AS txs, COUNT(DISTINCT signer_account_id) AS signers FROM `bigquery-public-data.crypto_near_mainnet_us.transactions` WHERE block_date BETWEEN '2026-10-01' AND '2026-10-31' GROUP BY 1)SELECT r AS receiver, txs, signers FROM tQUALIFY ROW_NUMBER() OVER (ORDER BY txs DESC) <= 400 OR REGEXP_CONTAINS(r, r'(^|[.\-_])(agent|agents|ai|shade|outlayer|nearai|llm|gpt|bot)([.\-_]|$)')ORDER BY txs DESC