-- The ten largest transaction signers and receivers each month.
WITH t AS (
  SELECT DATE_TRUNC(block_date, MONTH) AS m, signer_account_id AS s, receiver_account_id AS r
  FROM `bigquery-public-data.crypto_near_mainnet_us.transactions`
  WHERE block_date >= '2026-01-01'
), a AS (SELECT m, 'signer' AS role, s AS account, COUNT(*) AS txs FROM t GROUP BY 1, 2, 3),
b AS (SELECT m, 'receiver' AS role, r AS account, COUNT(*) AS txs FROM t GROUP BY 1, 2, 3)
SELECT * FROM a QUALIFY ROW_NUMBER() OVER (PARTITION BY m ORDER BY txs DESC) <= 12
UNION ALL
SELECT * FROM b QUALIFY ROW_NUMBER() OVER (PARTITION BY m ORDER BY txs DESC) <= 12
ORDER BY 1, 2, 4 DESC