near-toll-audit / pipeline/sql/08_burn_by_contract.sql · raw
-- Who actually burns NEAR: tokens_burnt by executing account, for one month before and one after the April 2026 break.SELECT DATE_TRUNC(block_date, MONTH) AS m, executor_account_id AS account, COUNT(*) AS receipts, SUM(gas_burnt) AS gas, SUM(tokens_burnt) / 1e24 AS tokens_burnt_nearFROM `bigquery-public-data.crypto_near_mainnet_us.execution_outcomes`WHERE block_date BETWEEN '2026-03-01' AND '2026-03-31' OR block_date BETWEEN '2026-10-01' AND '2026-10-31'GROUP BY 1, 2QUALIFY ROW_NUMBER() OVER (PARTITION BY m ORDER BY tokens_burnt_near DESC) <= 60ORDER BY 1, 5 DESC