Application Volume vs. Token Dilution: Auditing Economic Value Capture on NEAR Protocol

-- Query 1A: Daily Opening & Closing Supply Checkpoints (734 rows; 2025-11-02 to 2026-11-03)
WITH daily_blocks AS (
  SELECT
    block_date, block_height, block_timestamp_utc,
    CAST(total_supply AS BIGNUMERIC) / 1e24 AS total_supply_near,
    ROW_NUMBER() OVER(PARTITION BY block_date ORDER BY block_height ASC) AS rn_first,
    ROW_NUMBER() OVER(PARTITION BY block_date ORDER BY block_height DESC) AS rn_last
  FROM `bigquery-public-data.crypto_near_mainnet_us.blocks`
  WHERE block_date BETWEEN '2025-11-02' AND '2026-11-03'
)
SELECT block_date, block_height, block_timestamp_utc, total_supply_near,
       IF(rn_first = 1, 'DAY_OPEN', 'DAY_CLOSE') AS checkpoint_type
FROM daily_blocks WHERE rn_first = 1 OR rn_last = 1 ORDER BY block_height ASC;

-- Query 1B: Daily All-Shard Execution Gas Burned (365 rows; 2025-11-03 to 2026-11-02)
SELECT
  block_date,
  COUNT(1) AS execution_outcome_count,
  SUM(gas_burnt) / 1e12 AS total_tgas_burnt,
  SUM(CAST(tokens_burnt AS BIGNUMERIC)) / 1e24 AS total_tokens_burnt_near
FROM `bigquery-public-data.crypto_near_mainnet_us.execution_outcomes`
WHERE block_date BETWEEN '2025-11-03' AND '2026-11-02'
GROUP BY block_date ORDER BY block_date ASC;

-- 1. Mainnet RPC Account Snapshot at Block 222,873,598 (2026-11-03T13:03:36Z)
curl -s -X POST https://rpc.mainnet.near.org -H "Content-Type: application/json" -d '{
  "jsonrpc": "2.0", "id": 1, "method": "query",
  "params": {"request_type": "view_account", "block_id": 222873598, "account_id": "buybacks.multisignature.near"}
}'
-- Result: amount = 2161449129526092621826932205769 yoctoNEAR (2,161,449.13 NEAR); locked = 0; storage_usage = 356,468 bytes
-- Fastnear FT Check: https://api.fastnear.com/v0/account/buybacks.multisignature.near/ft -> 0 stablecoins detected
-- Fastnear Staking Check: https://api.fastnear.com/v0/account/buybacks.multisignature.near/staking -> pools: [] (0 staked)

-- 2. BigQuery Native NEAR Transfer Verification into buybacks.multisignature.near
SELECT
  block_date,
  receipt_predecessor_account_id AS sender_account,
  receipt_receiver_account_id AS receiver_account,
  COUNT(1) AS transfer_count,
  SUM(CAST(JSON_EXTRACT_SCALAR(args, '$.deposit') AS BIGNUMERIC)) / 1e24 AS total_transferred_near
FROM `bigquery-public-data.crypto_near_mainnet_us.action_receipt_actions`
WHERE block_date BETWEEN '2026-10-27' AND '2026-11-02'
  AND receipt_receiver_account_id = 'buybacks.multisignature.near'
  AND action_kind = 'TRANSFER'
GROUP BY block_date, sender_account, receiver_account
ORDER BY block_date ASC;

-- 1. Cached Protocol Breakdowns (`data/defi_collateral_breakdown.json` & `scripts/analyze_collateral_overlap.py`)
-- Endpoints: https://api.llama.fi/protocol/burrow | /protocol/meta-pool-near | /protocol/linear-protocol
-- Historical Chain TVL: https://api.llama.fi/v2/historicalChainTvl/NEAR (`data/tvl_near.json`)

-- 2. BigQuery Smart Contract Function Call Volume Across Core DeFi & Intents Contracts
SELECT
  block_date,
  receipt_receiver_account_id AS contract_account_id,
  COUNT(1) AS function_call_count
FROM `bigquery-public-data.crypto_near_mainnet_us.action_receipt_actions`
WHERE block_date BETWEEN '2026-10-27' AND '2026-11-02'
  AND action_kind = 'FUNCTION_CALL'
  AND receipt_receiver_account_id IN (
    'intents.near', 'contract.main.burrow.near', 'meta-pool.near', 'linear-protocol.near', 'v2.ref-finance.near'
  )
GROUP BY block_date, contract_account_id
ORDER BY block_date ASC, function_call_count DESC;

// 1. Mainnet JSON-RPC Validator Query (Snapshot at Block 222,861,199, Epoch 4931, 2026-11-03T11:03:07Z)
curl -s -X POST https://rpc.mainnet.near.org -H "Content-Type: application/json" -d '{
  "jsonrpc": "2.0", "id": 1, "method": "validators", "params": [null]
}'
// Active accounts: 375 (100 block producers + 275 chunk-only producers; minimum seat price: 11,000.00 NEAR)
// Active stake: 593,276,081.48 NEAR (45.27% of 1,310,627,218.40 NEAR supply; 54.73% supply not in active stake)
// Re-verify locally: python scripts/recalculate_nakamoto.py