NEAR Hackathon 2026, Investment Thesis track

Can NEAR’s Intents business grow into its dilution?

The long-term case for NEAR rests on Intents.

Victor Song and Tharun Ekambaram

Our thesis

NEAR Intents led its market over the past year, but NEAR’s price asks for far more than its fees deliver. The NEAR those fees send to NEAR’s revenue wallets equals, at most, about a sixth of net new supply.

For the fees alone to carry the price NEAR had on 2026-11-13, they would have to grow faster each year to 2031 than cross-chain volume grew over any period in the data. Owning NEAR at that price is a bet on a bigger cut of those fees, or on value beyond them.

Read our paper or see it as slides.

Where it stands, on data to 2026-11-13. In grey: where it stood on 2026-11-04, the cutoff.

  • 15.81%NEAR reaching its revenue wallets, as a share of net new supply30 days to 2026-11-04
  • 79.8%Revenue growth the price assumes, a year to 2031was 84.9%
  • 1.6×Take NEAR would need, as a multiple of Intents’ whole gross feewas 2.5×
  • 62.2%NEAR’s dilution paid for in 2031, base casewas 44.6%

Today, read live in the browser. In grey: 2026-11-13.

  • Growth the price assumes…was 79.8% a year
  • NEAR market cap…was $4.48B
  • Intents revenue, 30 days…was $1.8M
  • NEAR’s take, 30 days…was 4.75 bp
  • Buyback wallet…2.187M NEAR at the freeze

The view and figures above and the first two tabs are exploratory: we built them after freezing our predictions, which are scored as written in the track record. Every chart and every committed number rebuilds offline with one command (the steps); only the Today values are fetched live. Nothing here is investment advice.

The investment case

The NEAR that Intents sends to NEAR’s revenue wallets is small next to what the price assumes. Over 30 days it equalled 15.81% of net new supply, and only 4.53 points of that trace to public fee collectors. For those fees alone to carry NEAR’s price, they would have to grow 84.9% a year to 2031. With the market growing at last year’s pace and Intents at its best share, that would take 2.5× Intents’ whole gross fee. In the base case the fees pay for 44.6% of NEAR’s dilution in 2031.

Figure 1Exploratory#

Verifiable value capture: 4.53% to 15.81% of net issuance

The value-capture ladder: NEAR delivered to the revenue wallets as a share of net issuance Panel A: one bar on a 0 to 100 percent axis, filled to 15.81 percent. Panel B, zoomed to 0 to 20 percent: a stacked bar of the same total split into public fee collectors 4.53, escrow unshields 11.25 and one other source 0.03, and the buyback wallet alone at 11.00, a subset. A. Share of net issuance matched, % (full scale: 100% is all of net issuance) 0% 25% 50% 75% 100% NEAR delivered to the three revenue wallets Three revenue wallets: 15.81% of net issuance 15.81% B. Zoom: the same data on a 0 to 20% axis Public fee collectors: 4.53% Escrow unshields, fee stream unattested: 11.25% One other recurring source: 0.03% 0% 5% 10% 15% 20% All three revenue wallets, by how the NEAR arrived Public fee collectors: 4.53% Escrow unshields: 11.25% One other recurring source: 0.03% 15.81% Of which the buyback wallet alone (a subset of the three) Buyback wallet alone: 11.00% 11.00%
The value-capture ladder: NEAR delivered to the revenue wallets as a share of net issuance Panel A: one bar on a 0 to 100 percent axis, filled to 15.81 percent. Panel B, zoomed to 0 to 20 percent: a stacked bar of the same total split into public fee collectors 4.53, escrow unshields 11.25 and one other source 0.03, and the buyback wallet alone at 11.00, a subset. A. Share of net issuance matched, % (full scale: 100% is all of net issuance) 0% 25% 50% 75% 100% NEAR delivered to the three revenue wallets Three revenue wallets: 15.81% of net issuance 15.81% B. Zoom: the same data on a 0 to 20% axis Public fee collectors: 4.53% Escrow unshields, fee stream unattested: 11.25% One other recurring source: 0.03% 0% 5% 10% 15% 20% All three revenue wallets, by how the NEAR arrived Public fee collectors: 4.53% Escrow unshields: 11.25% One other recurring source: 0.03% 15.81% Of which the buyback wallet alone (a subset of the three) Buyback wallet alone: 11.00% 11.00%
Window: the 30 days 2026-10-06 to 2026-11-04 (UTC). Unit: percent of net issuance. Panel B is a zoom of Panel A.
Three-wallet total
418.8K NEAR
Share of DefiLlama's reported Intents revenue, same days
100.9%
Net issuance
88,295 NEAR a day
Notes and sources

NEAR delivered to NEAR’s three Intents revenue wallets equalled 15.81% of net issuance; only 4.53 points trace to public fee collectors and 11.25 arrive as unshields from the Confidential Intents escrow, fee stream unattested.

What it shows: How much of NEAR’s net issuance (88,295 NEAR a day over the 30 days 2026-10-06 to 2026-11-04) was matched by NEAR delivered to the three revenue wallets, split by how it arrived: 4.53% from two recurring public fee collectors and 11.25% released from the Confidential Intents escrow, plus 0.03% from one other source.

What it does not show: Which fee stream pays for the escrow releases: the NEAR verifiably arrived, but the public chain cannot split the 11.25 points between the two candidate NEAR-side streams that fit, so, if those three are all of NEAR’s Intents revenue wallets, measured value capture is a range, 4.53% to 15.81% of issuance.

  • The two candidate readings are near.com’s fees and the Confidential Infrastructure Fee. A per-stream attestation by NEAR would turn the range into one number. Nothing here alleges misconduct. This is consistent with a privacy feature working as documented, and the question is auditability.
  • The rungs are not nested: collectors, escrow and one other source add up to all three wallets, and the buyback-wallet rung is a subset of the total.
  • Not all of the collector rung is public settlement. Of its 4.53 points, 0.56 were fees paid by single-use accounts the escrow had funded (exploratory, every transfer into the collectors classified by sender), so 11.81 points passed through the escrow in all, and counting only publicly settled swaps the floor is 3.97%. By the last day, 96.0% of collector A’s fee value came from escrow-funded accounts.
  • The total matches DefiLlama: 418.8K NEAR is 100.9% of its reported Intents revenue for the same days. DefiLlama’s adapter takes the same three wallets from NEAR’s own Dune query, so it is the same count: it checks our pricing and wallet list and gives no independent check of the wallets. Even the top of the range covers about a sixth of issuance, and the buyback wallet holds its NEAR: none of it has been burned.
  • No valuation is made here. The range is the finding: 15.81% is what reached the three wallets and 4.53% is what is traced to public fee collectors. None of this feeds the rating rule.

Source:

Query

Re-check any delivery or funding transfer from the chain with no key: python3 -m pipeline.fetch_escrow verify --sample 60. The BigQuery job that traced the funding hops from 2026-10-06 is recorded in data/MANIFEST.json (bqjob_r275b038b73d7c093_000001a1af3708a8_1); its SQL is not committed in sql/, so the per-delivery table data/raw/escrow/deliveries.csv and python3 -m pipeline.fetch_escrow verify are the re-checkable evidence.

sql/buyback_withdraw_sources.sql 1,162 bytes

-- Which intents.near accounts deliver native NEAR to NEAR's revenue wallets (dip4 native_withdraw
-- events), 2026-10-06..11-04, per day, source account and wallet. Recurring sources are fee
-- collectors; single-use sources are fresh accounts that receive NEAR unshielded from the Confidential Intents
-- treasury (PRIVATE_TREASURY_ACCOUNT_ID 51e8f94d...7cbe, docs.near-intents.org) and withdraw it.
SELECT o.block_date AS day,
       JSON_VALUE(d, '$.account_id') AS src,
       JSON_VALUE(d, '$.receiver_id') AS wallet,
       COUNT(*) AS n,
       CAST(SUM(CAST(JSON_VALUE(d, '$.amount') AS BIGNUMERIC)) / 1e24 AS STRING) AS near
FROM `bigquery-public-data.crypto_near_mainnet_us.execution_outcomes` o, UNNEST(o.logs.list) l,
  UNNEST(JSON_QUERY_ARRAY(SUBSTR(l.element, 12), '$.data')) d
WHERE o.block_date BETWEEN '2026-10-06' AND '2026-11-04'
  AND o.executor_account_id = 'intents.near'
  AND l.element LIKE 'EVENT_JSON:%native_withdraw%'
  AND JSON_VALUE(d, '$.receiver_id') IN ('buybacks.multisignature.near', 'fefundsadmin.sputnik-dao.near',
                                         '1csfundsadmin.sputnik-dao.near')
GROUP BY 1, 2, 3
ORDER BY 1, 2, 3

sql/collector_inflow_funders.sql 2,990 bytes

-- Exploratory (written 2026-11-12, after the freeze). Who funded the fees that reached NEAR's two fee collectors
-- (collector A 5880ad2b..., collector B 143f2bb4..., see sql/collector_inflows.sql), 2026-10-06..11-04.
-- Every dip4 transfer into A or B is classified by its sender (account_id):
--   escrow_direct  sender is the Confidential Intents treasury (PRIVATE_TREASURY_ACCOUNT_ID 51e8f94d...7cbe)
--   escrow_funded  sender received a dip4 transfer from that treasury between 2026-09-22 and the transfer's block
--   public_swap    otherwise, and the same receipt emits a dip4 token_diff for the sender (a public swap intent)
--   other          none of the above
-- Per day, collector, class and token: summed raw amounts, transfer count, distinct senders. Summed over class,
-- the rows equal data/raw/bq/collector_inflows.json.
WITH ev AS (
  SELECT o.block_date AS day, o.block_height AS h, o.receipt_id AS rid,
         l.element AS el
  FROM `bigquery-public-data.crypto_near_mainnet_us.execution_outcomes` o, UNNEST(o.logs.list) l
  WHERE o.block_date BETWEEN '2026-09-22' AND '2026-11-04'
    AND o.executor_account_id = 'intents.near'
    AND l.element LIKE 'EVENT_JSON:{"standard":"dip4"%'
    AND (l.element LIKE '%"event":"transfer"%' OR l.element LIKE '%"event":"token_diff"%')
),
rows_ AS (
  SELECT day, h, rid,
         REGEXP_EXTRACT(el, r'"event":"([a-z_]+)"') AS event,
         JSON_VALUE(d, '$.account_id') AS sender, JSON_VALUE(d, '$.receiver_id') AS receiver,
         JSON_QUERY(d, '$.tokens') AS tokens
  FROM ev, UNNEST(JSON_QUERY_ARRAY(SUBSTR(el, 12), '$.data')) d
),
funded AS (  -- first escrow funding of each account
  SELECT receiver AS acct, MIN(h) AS first_h
  FROM rows_ WHERE event = 'transfer' AND sender = '51e8f94d77b5e90dc9852ca6113771e11e8382ce69473a75e313e41665de7cbe' GROUP BY receiver
),
diffs AS (SELECT DISTINCT rid, sender FROM rows_ WHERE event = 'token_diff'),
inflow AS (
  SELECT r.day, r.receiver AS collector, r.sender, r.tokens,
         CASE WHEN r.sender = '51e8f94d77b5e90dc9852ca6113771e11e8382ce69473a75e313e41665de7cbe' THEN 'escrow_direct'
              WHEN f.first_h IS NOT NULL AND f.first_h <= r.h THEN 'escrow_funded'
              WHEN dd.rid IS NOT NULL THEN 'public_swap'
              ELSE 'other' END AS class
  FROM rows_ r
  LEFT JOIN funded f ON f.acct = r.sender
  LEFT JOIN diffs dd ON dd.rid = r.rid AND dd.sender = r.sender
  WHERE r.event = 'transfer' AND r.day >= '2026-10-06'
    AND r.receiver IN ('5880ad2b362620fadf759cbceb1cd5737ce8c6ed7fb8e9942881e6731f9247dd',
                       '143f2bb439575c286f4f585163f0e5fb4e464f8ce57ec06ae80741407d3cfb31')
)
SELECT day, collector, class, REGEXP_EXTRACT(kv, r'^"([^"]+)"') AS token,
       CAST(SUM(CAST(REGEXP_EXTRACT(kv, r':"([0-9]+)"$') AS BIGNUMERIC)) AS STRING) AS amount,
       COUNT(*) AS n, COUNT(DISTINCT sender) AS senders
FROM inflow, UNNEST(REGEXP_EXTRACT_ALL(tokens, r'"[^"]+":"[0-9]+"')) AS kv
GROUP BY 1, 2, 3, 4
ORDER BY 1, 2, 3, 4

sql/collector_funder_checks.sql 4,260 bytes

-- Exploratory (written 2026-11-12, after the freeze). Who funded the fees that reached NEAR's two fee collectors
-- (collector A 5880ad2b..., collector B 143f2bb4..., see sql/collector_inflows.sql), 2026-10-06..11-04.
-- Every dip4 transfer into A or B is classified by its sender (account_id):
--   escrow_direct  sender is the Confidential Intents treasury (PRIVATE_TREASURY_ACCOUNT_ID 51e8f94d...7cbe)
--   escrow_funded  sender received a dip4 transfer from that treasury between 2026-09-22 and the transfer's block
--   public_swap    otherwise, and the same receipt emits a dip4 token_diff for the sender (a public swap intent)
--   other          none of the above
-- Checks of that classification, per period (post = from 2026-10-27), collector (first character) and class:
--   n_with_diff           transfers whose receipt carries a token_diff for the sender
--   n_sender_single_tx    transfers whose sender sent exactly one transfer to A or B in the window
--   n_sender_single_day   ... whose sender sent to A or B on one day only
--   n_funded_once         ... whose sender received exactly one transfer from the treasury since 2026-09-22
--   n_no_other_inflow     ... whose sender received no dip4 transfer from any other account since 2026-09-22
--   lag_blocks_q          quartiles of blocks from the sender's first treasury funding to the transfer
WITH ev AS (
  SELECT o.block_date AS day, o.block_height AS h, o.receipt_id AS rid,
         l.element AS el
  FROM `bigquery-public-data.crypto_near_mainnet_us.execution_outcomes` o, UNNEST(o.logs.list) l
  WHERE o.block_date BETWEEN '2026-09-22' AND '2026-11-04'
    AND o.executor_account_id = 'intents.near'
    AND l.element LIKE 'EVENT_JSON:{"standard":"dip4"%'
    AND (l.element LIKE '%"event":"transfer"%' OR l.element LIKE '%"event":"token_diff"%')
),
rows_ AS (
  SELECT day, h, rid,
         REGEXP_EXTRACT(el, r'"event":"([a-z_]+)"') AS event,
         JSON_VALUE(d, '$.account_id') AS sender, JSON_VALUE(d, '$.receiver_id') AS receiver,
         JSON_QUERY(d, '$.tokens') AS tokens
  FROM ev, UNNEST(JSON_QUERY_ARRAY(SUBSTR(el, 12), '$.data')) d
),
funded AS (  -- first escrow funding of each account
  SELECT receiver AS acct, MIN(h) AS first_h
  FROM rows_ WHERE event = 'transfer' AND sender = '51e8f94d77b5e90dc9852ca6113771e11e8382ce69473a75e313e41665de7cbe' GROUP BY receiver
),
diffs AS (SELECT DISTINCT rid, sender FROM rows_ WHERE event = 'token_diff'),
inflow AS (
  SELECT r.day, r.h, r.receiver AS collector, r.sender, r.tokens, f.first_h, dd.rid IS NOT NULL AS has_diff,
         CASE WHEN r.sender = '51e8f94d77b5e90dc9852ca6113771e11e8382ce69473a75e313e41665de7cbe' THEN 'escrow_direct'
              WHEN f.first_h IS NOT NULL AND f.first_h <= r.h THEN 'escrow_funded'
              WHEN dd.rid IS NOT NULL THEN 'public_swap'
              ELSE 'other' END AS class
  FROM rows_ r
  LEFT JOIN funded f ON f.acct = r.sender
  LEFT JOIN diffs dd ON dd.rid = r.rid AND dd.sender = r.sender
  WHERE r.event = 'transfer' AND r.day >= '2026-10-06'
    AND r.receiver IN ('5880ad2b362620fadf759cbceb1cd5737ce8c6ed7fb8e9942881e6731f9247dd',
                       '143f2bb439575c286f4f585163f0e5fb4e464f8ce57ec06ae80741407d3cfb31')
)

, s AS (SELECT sender, COUNT(*) AS n_tx, COUNT(DISTINCT day) AS n_days FROM inflow GROUP BY sender),
fo AS (SELECT receiver AS acct, COUNT(*) AS n_fund FROM rows_ WHERE event='transfer'
       AND sender='51e8f94d77b5e90dc9852ca6113771e11e8382ce69473a75e313e41665de7cbe' GROUP BY receiver),
oth AS (SELECT receiver AS acct, COUNT(*) AS n_in_other FROM rows_ WHERE event='transfer'
       AND sender!='51e8f94d77b5e90dc9852ca6113771e11e8382ce69473a75e313e41665de7cbe' GROUP BY receiver)
SELECT i.day >= '2026-10-27' AS post, SUBSTR(i.collector,1,1) AS coll, i.class,
  COUNT(*) AS n, COUNTIF(i.has_diff) AS n_with_diff, COUNT(DISTINCT i.sender) AS senders,
  COUNTIF(s.n_tx = 1) AS n_sender_single_tx, COUNTIF(s.n_days = 1) AS n_sender_single_day,
  COUNTIF(fo.n_fund = 1) AS n_funded_once, COUNTIF(oth.n_in_other IS NULL) AS n_no_other_inflow,
  APPROX_QUANTILES(i.h - i.first_h, 4) AS lag_blocks_q
FROM inflow i JOIN s USING (sender) LEFT JOIN fo ON fo.acct=i.sender LEFT JOIN oth ON oth.acct=i.sender
GROUP BY 1,2,3 ORDER BY 1,2,3
Data

A table wider than the screen scrolls sideways.

Plotted values, 30 days to the as-of date
Rung % of net issuance How the NEAR arrived
All three revenue wallets 15.81 sum of the collector, escrow and other-source rows below
Of which the buyback wallet alone 11.00 a subset of the total, overlapping the rows below
Traceable to two recurring public fee collectors 4.53 fee collectors A and B
… of which fees from publicly settled swaps 3.97 the fee payer swapped publicly in the same receipt
… of which fees paid from escrow-funded single-use accounts 0.56 the escrow funded the payer moments before; all at collector A
Released from the Confidential Intents escrow 11.25 fee stream unattested
One other recurring source 0.03 recurring, unnamed
Net issuance, NEAR a day (denominator) 88,295 two archival total_supply reads, matched to the window
Figure 2Exploratory#

Growth the price assumes: 84.9% a year to 2031

Growth in captured revenue that NEAR's price assumes, against the growth the market and the rating rule show Bars from zero, percent a year: the price assumes 84.9 at the base assumptions and 54.0 at the most generous in the grid; the rating rule needs 33.2; the peer set's volume grew 13.4 last year and 47.1 a year over four, and fell a little a year over two; without NEAR Intents it fell last year and grew 15.4 a year over four. Growth a year to 2031, % What the price assumes What the rating rule needs What the venues did 0 25 50 75 100 What the price assumes: base assumptions 84.9% a year What the price assumes: the most generous assumptions in the grid 54.0% a year What the rating rule needs to cover dilution (G_req) 33.2% a year Peer set, with Intents: a year over four years 47.1% a year Peer set, with Intents: last year 13.4% a year Peer set, with Intents: a year over two years -1.9% a year The other venues: a year over four years 15.4% a year The other venues: last year -53.4% a year
Growth in captured revenue that NEAR's price assumes, against the growth the market and the rating rule show Bars from zero, percent a year: the price assumes 84.9 at the base assumptions and 54.0 at the most generous in the grid; the rating rule needs 33.2; the peer set's volume grew 13.4 last year and 47.1 a year over four, and fell a little a year over two; without NEAR Intents it fell last year and grew 15.4 a year over four. Growth a year to 2031, % What the price assumes What the rating rule needs What the venues did 0 25 50 75 100 What the price assumes: base assumptions 84.9% a year What the price assumes: the most generous assumptions in the grid 54.0% a year What the rating rule needs to cover dilution (G_req) 33.2% a year Peer set, with Intents: a year over four years 47.1% a year Peer set, with Intents: last year 13.4% a year Peer set, with Intents: a year over two years -1.9% a year The other venues: a year over four years 15.4% a year The other venues: last year -53.4% a year
Market cap $4.82B on 2026-11-05. Captured revenue: the 90 days to 2026-11-04, annualised.
Captured revenue now, a year
$19.6M
Needed by 2031 (base)
$424.0M
That is
21.6× today
Market cap ÷ revenue now
245.0×
Notes and sources

For NEAR’s price to rise 15% a year to 2031-11-04 and its market cap then to be 25 times its captured revenue, captured revenue must grow from $19.6M a year to $424.0M, 84.9% a year (54.0% to 131.7% across the grid), if Intents carried the price alone. The cross-chain venues tracked here grew 13.4% last year, all of it Intents’ own growth (×9.0): without Intents the venues’ volume changed by -53.4%. Over four years the set grew 47.1% a year, 15.4% without Intents.

What it shows: A reverse DCF: the growth in captured Intents revenue that today’s market cap implies, for a required return and a revenue multiple in 2031 (both assumptions, shown as a grid), with supply growth on the rating rule’s own path, against what the cross-chain swap market has done.

What it does not show: A valuation of NEAR as a whole. NEAR’s market cap also prices the L1 (its fees, which burn, staking and any monetary premium); here all of it is set against Intents’ captured revenue, so the growth shown is what Intents would need if it carried the price alone.

Growth in captured revenue a year to 2031 that today’s market cap assumes, %
Required return 10× revenue in 2031 25× revenue in 2031 50× revenue in 2031
10% a year 112.4% 76.9% 54.0%
15% a year 122.1% 84.9% 61.0%
20% a year 131.7% 92.9% 68.0%
  • The required return is on NEAR’s price. Supply grows and the buybacks burn nothing, so for the price to rise at that rate the market cap must grow faster by the supply factor, 1.094× by 2031; a holder who stakes also receives part of the new supply.
  • For comparison, THORChain’s market cap is 9.8× its gross fees and Chainflip’s 1.8× (see the peer card). The grid’s multiples are on captured revenue; the peers’ multiples on what reaches their token holders would be higher and are not computed here.
  • Last year’s growth of the set is all Intents’ growth, and part of it is DefiLlama’s change on 2026-09-01 in what it counts as Intents volume (docs/leg-count.md): as a measure of the market it is generous to NEAR.
  • The market’s growth depends on the window: 76.9% a year over three years starts at the low of $9.6B; the annual volumes were $11.3B, $9.6B, $55.1B, $46.7B and $53.0B (oldest first). The two-year rate is negative and is drawn at zero.
  • G_obs, the rule’s observed growth in captured revenue (619.0% a year), is left off the axis: it comes from a step in the share of fees captured, while gross fees and volume grew far less.
  • Supply grows 1.094× to 2031-11-04 with HSP-029. Market: THORChain, Chainflip, Maya and NEAR Intents (DefiLlama, reported basis), full years to the as-of date.
Query
Model
python3 -m pipeline.compute (calls pipeline.investment_case.investment_case); offline, standard library
Metrics
ic_* in data/metrics.json
Data

A table wider than the screen scrolls sideways.

Growth in captured revenue a year to 2031 that today’s market cap assumes, %
Required return 10× revenue in 2031 25× revenue in 2031 50× revenue in 2031
10% a year 112.4% 76.9% 54.0%
15% a year 122.1% 84.9% 61.0%
20% a year 131.7% 92.9% 68.0%
Figure 3Exploratory#

Take NEAR would need: 2.5× Intents’ whole gross fee

What would have to multiply by 2031 for captured revenue to reach what the price assumes Panel A: bars from zero, multiples: captured revenue must multiply by 21.6; the market at its last-year pace gives 1.87, Intents' share at its twelve-month high 1.27, leaving 9.1 for the take rate. Panel B: bars from zero, basis points: NEAR's take today 4.13, Intents' gross fee 15.2, the take the price needs 37.4. A. Multiples by 2031 0 5 10 15 20 25 Captured revenue must multiply by 21.6× The market, at its last-year pace 1.87× Intents' share, at its twelve-month high 1.27× Left for NEAR's take rate 9.1× B. Take rate, basis points of volume 0 10 20 30 40 NEAR's captured take today 4.13 bp Intents' whole gross fee today 15.2 bp Take the price needs 37.4 bp
What would have to multiply by 2031 for captured revenue to reach what the price assumes Panel A: bars from zero, multiples: captured revenue must multiply by 21.6; the market at its last-year pace gives 1.87, Intents' share at its twelve-month high 1.27, leaving 9.1 for the take rate. Panel B: bars from zero, basis points: NEAR's take today 4.13, Intents' gross fee 15.2, the take the price needs 37.4. A. Multiples by 2031 0 5 10 15 20 25 Captured revenue must multiply by 21.6× The market, at its last-year pace 1.87× Intents' share, at its twelve-month high 1.27× Left for NEAR's take rate 9.1× B. Take rate, basis points of volume 0 10 20 30 40 NEAR's captured take today 4.13 bp Intents' whole gross fee today 15.2 bp Take the price needs 37.4 bp
Base case: 15% required return, 25× revenue in 2031. Take and fee: the 90 days to 2026-11-04.
Take needed ÷ whole gross fee
2.5×
Market growth needed at the whole fee
35.7% a year
Market growth, last year
13.4%
Notes and sources

Captured revenue = cross-chain swap volume × Intents’ share × NEAR’s take. To multiply by 21.6 by 2031, with the market growing at its last-year pace (×1.87) and Intents’ share at its twelve-month high (×1.27), NEAR’s take would have to rise ×9.1, from 4.13 bp to 37.4 bp of volume: 2.5 times the whole 15.2 bp gross fee Intents charges today. Even if NEAR kept the whole gross fee, the market would have to grow 35.7% a year.

What it shows: The required multiple from the reverse DCF (base assumptions), split into its three factors: the growth of the cross-chain swap market, Intents’ share of it, and the share of volume NEAR captures as revenue, each at a value from the data, and what is left for the take rate.

What it does not show: That the take rate cannot rise: fees are a policy choice. It shows how far the current fee structure is from what the price implies, if the market grows as it has.

  • Intents’ share of the peer set over the 90 days was 61.7%; its twelve-month high was 78.6% (2026-06) and its low 48.5% (2026-04).
  • Each factor is on DefiLlama’s reported volume, which counts both legs of some swaps and, from 2026-09-01, more of Intents’ volume (docs/leg-count.md). Only the full product, the revenue, is unaffected. Last year’s market growth is all Intents’ and partly that change, so it is generous to NEAR, and the take needed is, if anything, understated.
  • Take and gross fee are DefiLlama revenue and fees ÷ volume, on the reported basis.
Query
Model
python3 -m pipeline.compute (calls pipeline.investment_case.investment_case); offline, standard library
Metrics
ic_* in data/metrics.json
Data

A table wider than the screen scrolls sideways.

Plotted values
Factor Value
Required multiple of captured revenue 21.6×
Market, last-year pace for five years 1.87×
Share, twelve-month high ÷ 90 days 1.27×
Left for the take rate 9.1×
Take today, bp 4.13
Gross fee today, bp 15.2
Take needed, bp 37.4
Figure 4Exploratory#

Dilution paid for in 2031: 3.5% bear, 44.6% base, 277.5% bull

Bear, base and bull: coverage of NEAR's dilution on 2031-11-04, and which input moves it most Panel A: bars from zero, percent: coverage on 2031-11-04 is 3.5 in the bear case, 44.6 in the base case and 277.5 in the bull case, against a line at 100. Panel B: for each input, the base coverage with that input at its low and high value. A. Coverage on 2031-11-04, % 0 100 200 300 Bear case 3.5% Base case 44.6% Bull case 277.5% 100%: covers all dilution B. Base coverage with one input moved, % (each bar spans low to high) 0 50 100 150 200 Market growth: two-year to four-year pace 21.6% to 163.8% NEAR's price: 365-day high to low 27.8% to 169.8% Take rate: lowest to highest month 14.7% to 59.3% Intents' share: twelve-month low to high 35.1% to 56.8% HSP-029: not in force to in force 27.5% to 44.6% base 44.6%
Bear, base and bull: coverage of NEAR's dilution on 2031-11-04, and which input moves it most Panel A: bars from zero, percent: coverage on 2031-11-04 is 3.5 in the bear case, 44.6 in the base case and 277.5 in the bull case, against a line at 100. Panel B: for each input, the base coverage with that input at its low and high value. A. Coverage on 2031-11-04, % 0 100 200 300 Bear case 3.5% Base case 44.6% Bull case 277.5% 100%: covers all dilution B. Base coverage with one input moved, % (each bar spans low to high) 0 50 100 150 200 Market growth: two-year to four-year pace 21.6% to 163.8% NEAR's price: 365-day high to low 27.8% to 169.8% Take rate: lowest to highest month 14.7% to 59.3% Intents' share: twelve-month low to high 35.1% to 56.8% HSP-029: not in force to in force 27.5% to 44.6% base 44.6%
Price held at $3.67, the rule’s. Where each case’s inputs come from is under Notes and sources.
Notes and sources

With every input at a value from the data and the price held flat, captured revenue on 2031-11-04 would pay for 3.5% (bear), 44.6% (base) or 277.5% (bull) of the dollar value of NEAR’s dilution. The bull case’s $228.6M a year is 53.9% of the $424.0M the price would assume at 15% and 25×; at the three-year market pace it would be 136.0%. Market growth and NEAR’s price move coverage most: from 21.6% to 163.8% and from 27.8% to 169.8%.

What it shows: Three futures for captured revenue (market growth × Intents’ share × NEAR’s take), each input at a value from the data, run against the rating rule’s supply path at its constant (flat) price; then the base case with one input at a time at its low and high value. Coverage is what captured revenue would pay for: not all of it reaches the buyback wallet, and none of it is burned.

What it does not show: Probabilities: the scenarios are not weighted (the Monte Carlo card gives a distribution). Nor a new fee stream, a partner change or a regime the data have not seen.

  • Bear: market at its two-year pace, share at its twelve-month low (2026-04), take at its lowest month since the fee switch (2026-04), no HSP-029. Base: last-year market growth and the last 90 days’ share and take, with HSP-029. Bull: four-year market pace, twelve-month-high share (2026-06), highest month’s take (2026-10), with HSP-029.
  • Coverage moves in inverse proportion to NEAR’s price, because each dollar of revenue buys back less NEAR at a higher price: the 365-day range, $0.96 to $5.89, moves the base case from 27.8% to 169.8%.
  • Which window anchors each case was chosen after the annual volumes, monthly shares and monthly take rates were computed (PREREG-ADDENDUM.md, 2026-11-14 entries); the card on what the price assumes lists every window, so a reader can substitute another.
  • The bull case grows the whole peer set at its four-year pace and also lifts Intents’ share, so it counts some of Intents’ share gains twice. Its revenue growth, 63.4% a year, falls short of what the price would assume at 25× and exceeds it only at 50× (54.0% at 10% a year, 61.0% at 15%).
  • At today’s market cap, NEAR would trade at 131.1× its 2031 captured revenue in the base case and 21.1× in the bull case.
Query
Model
python3 -m pipeline.compute (calls pipeline.investment_case.investment_case); offline, standard library
Metrics
ic_* in data/metrics.json
Data

A table wider than the screen scrolls sideways.

The three scenarios, from the data
Bear Base Bull
Market growth a year, % -1.9 13.4 47.1
Intents' share, % 48.5 61.7 78.6
NEAR's take, bp 1.36 4.13 5.49
HSP-029 in force no yes yes
Captured revenue in 2031, $M a year 4.6 36.7 228.6
Captured revenue growth a year, % -25.1 13.4 63.4
Coverage of dilution on 2031-11-04, % 3.5 44.6 277.5
Today's market cap ÷ 2031 revenue, × 1,041.1 131.1 21.1
Share of the revenue the price assumes, % 1.1 8.7 53.9
Figure 5Exploratory#

Signposts: the take rate and market growth are far from what the price needs

Signposts: how far today's values are from the lines that would favour the upside Bars from zero, percent of each line: 100 means today's value is at the line. Today as a share of the line, % 0 25 50 75 100 125 Coverage of dilution (P3, M1) 71.0% Captured revenue, 90 days (P2) 81.0% Intents' share of the peer set (P1) 113.0% Market growth against G_req 40.0% NEAR's take against what the price needs 11.0% Staking outflow against H1a's line 8.0% at the line
Signposts: how far today's values are from the lines that would favour the upside Bars from zero, percent of each line: 100 means today's value is at the line. Today as a share of the line, % 0 25 50 75 100 125 Coverage of dilution (P3, M1) 71.0% Captured revenue, 90 days (P2) 81.0% Intents' share of the peer set (P1) 113.0% Market growth against G_req 40.0% NEAR's take against what the price needs 11.0% Staking outflow against H1a's line 8.0% at the line
Today means the data to 2026-11-04. Lines: PREREG.md, the addendum, the cards above.
Notes and sources

Of the lines that would favour the upside, Intents’ share is past its own (113.0% of P1’s line), revenue and coverage are close (81.0% and 71.0%), and the two that carry the price are far: market growth is 40.0% of G_req and NEAR’s take 11.0% of what the price needs. In the scoring week, though, Intents was 37.2% of the peer set’s volume (F4).

What it shows: The values a reader should watch, each against the line that would favour the upside: the pre-registered P1 to P3, the model’s M1, the rating rule’s G_req, the take the price needs, and H1a’s line.

What it does not show: A score: P1 to P3 and M1 to M4 resolve on their own dates, from the data, and are scored as written.

  • For staking the line is H1a’s line (net staking outflow under half of staking rewards) divided by today’s ratio, so a full bar would mean stakers are no longer net sellers of their rewards.
Query
Model
python3 -m pipeline.compute (calls pipeline.investment_case.investment_case); offline, standard library
Metrics
ic_* in data/metrics.json
Data

A table wider than the screen scrolls sideways.

Signposts, with today's values and the lines
Signpost Today Line that favours the upside When
Coverage of dilution (P3’s quantity, 90 days) 17.8% at least 25% (P3, frozen; M1, exploratory, dated after the freeze) 2027-11-04
Captured revenue, 90 days $4.84M at least $6.0M (P2, frozen) 2027-05-04
Intents’ share of the peer set, 365 days 62.1% at least 55% (P1, frozen) 2027-05-04
Intents’ share of the peer set, scoring week 2026-11-06 to 2026-11-13 37.2% at least 50% (F4, frozen) scored: did not come true
Cross-chain swap volume, growth a year 13.4% 33.2% (G_req, if share and take stay where they are) each year
NEAR’s captured take, 90 days 4.13 bp 37.4 bp (what the price would need, at last year’s market pace and Intents’ twelve-month-high share) each month
Net staking outflow ÷ staking rewards (H1a) 6.56× under 0.5× (H1a’s line) each quarter
HSP-029’s issuance cut not yet in force in force (a lower inflation cap) timelock ends 2026-11-16
A per-stream attestation of the escrow releases none published by NEAR (collapses the ladder’s range) any time
Figure 6Exploratory#

Monte Carlo: 31.8% of paths pay for all dilution by 2031, 3.3% without one month

Projected coverage of NEAR's dilution by captured Intents revenue, 2026 to 2031, and the chance of reaching set lines Panel A: on a logarithmic axis, shaded percentile bands of coverage over 10,000 simulated paths, starting at 16.6% and ending with a median of 38.2% on 2031-11-04; reference lines at 100% and 25%. Panel B: bars from zero, the share of paths that reach each line. A. Coverage: 90-day captured revenue ÷ USD value of net new NEAR (log axis) Measured (P3's quantity) Middle half of paths Eight paths in ten Median path 1% 10% 100% 1,000% 2026-11 2027-11 2028-11 2029-11 2030-11 2031-11 100%: revenue covers all dilution 25%: P3's line 38.2% p90 590% p10 2.4% today B. Share of simulated paths that reach the line, % Main run Sensitivity Frozen probability (PREREG.md) 0 25 50 75 100 Reaches P3's line by 2027-11-04: model, and P3 as frozen model 39.6% P3, frozen in PREREG.md 35.0% Covers all dilution by 2027-11 3.9% Covers all dilution by 2028-11 15.9% Covers all dilution by 2031-11-04 (the rating rule's date) 31.8% Same, without HSP-029's cut 24.5% Same, at half today's take rate 21.7% Same, at twice today's take rate 44.3% Same, if NEAR's price keeps its last-year trend 0.9% Same, without the month that spans DefiLlama's counting change 3.3%
Projected coverage of NEAR's dilution by captured Intents revenue, 2026 to 2031, and the chance of reaching set lines Panel A: on a logarithmic axis, shaded percentile bands of coverage over 10,000 simulated paths, starting at 16.6% and ending with a median of 38.2% on 2031-11-04; reference lines at 100% and 25%. Panel B: bars from zero, the share of paths that reach each line. A. Coverage: 90-day captured revenue ÷ USD value of net new NEAR (log axis) Measured (P3's quantity) Middle half of paths Eight paths in ten Median path 1% 10% 100% 1,000% 2026-11 2028-11 2030-11 100%: revenue covers all dilution 25%: P3's line 38.2% today B. Share of simulated paths that reach the line, % Main run Sensitivity Frozen probability (PREREG.md) 0 25 50 75 100 Reaches P3's line by 2027-11-04: model, and P3 as frozen model 39.6% P3, frozen in PREREG.md 35.0% Covers all dilution by 2027-11 3.9% Covers all dilution by 2028-11 15.9% Covers all dilution by 2031-11-04 (the rating rule's date) 31.8% Same, without HSP-029's cut 24.5% Same, at half today's take rate 21.7% Same, at twice today's take rate 44.3% Same, if NEAR's price keeps its last-year trend 0.9% Same, without the month that spans DefiLlama's counting change 3.3%
Model: pipeline/model.py, a fixed seed, 60 model months from 2026-11-04. Unit: percent. Panel A’s axis is logarithmic.
Coverage today
16.6%
Median, 2031-11-04
38.2%
All dilution covered by 2031
31.8% of paths
Take rate held at
4.13 bp
Notes and sources

Captured Intents revenue covers 16.6% of the USD value of NEAR’s net new supply today. Over 10,000 paths that replay the volume and price changes of 11 months of data (price drift removed), the median reaches 19.9% by 2027-11, 26.6% by 2028-11 and 38.2% by 2031-11-04, and 31.8% of paths cover all of it by then (24.5% without HSP-029). If the price keeps its last-year trend, that falls to 0.9%; without the 2026-08 to 2026-09 month, which spans DefiLlama’s change in what it counts, to 3.3%. The bands are as wide as the data make them, so the thesis does not rest on these probabilities.

What it shows: The frozen rating rule’s question (does captured revenue reach the USD value of net new supply by 2031-11-04?) with a distribution in place of one price and one growth rate: 10,000 paths, each month drawing one of the 11 monthly changes in Intents volume and NEAR’s mean price (2025-12 to 2026-10) together, against the rule’s own supply path.

What it does not show: A forecast of NEAR’s price or a valuation. Eleven months of data cannot pin a five-year trend: the bands are as wide as the data make them, the take rate is held where it is, and no new fee stream, partner change or regime is modelled.

  • The volume drift comes from one month: the 2026-08 to 2026-09 change spans DefiLlama’s 2026-09-01 change in what it counts as Intents volume. Without that month volume changed by -4.5% a month, the 2031 median is 1.5% and 3.3% of paths cover all dilution. The forecasts M1 to M4 were dated with the month in and are scored as dated; the thesis does not rest on them (PREREG-ADDENDUM.md, 2026-11-14 entries).
  • Volume and price move together in the data: the correlation of their monthly log changes is 0.54, so each month’s two changes are drawn together.
  • The price drift is removed because NEAR’s mean price rose 7.4% a month on average over those months; replaying that for five years would assume the trend continues. With it, the 2031 median is 0.6%: a higher price means each dollar of revenue buys back less NEAR.
  • Volume keeps its sample drift, 0.8% a month. The take rate is captured revenue ÷ volume over the last 90 days, 4.13 bp, held fixed; coverage moves in proportion to it.
  • P3 (frozen in PREREG.md with probability 35.0%) asks whether coverage is at least 25% on 2027-11-04. The model, built after the freeze, gives 39.6%; P3 is scored on the data alone.
  • Coverage today here is computed in USD at one price, as the rating rule does; the ladder’s 15.81%-of-issuance figure counts NEAR as it arrived, so the two differ slightly.
  • In Panel A, values below the axis floor are drawn at the floor. The model feeds nothing the rating rule computes.
Query
Model
python3 -m pipeline.compute (calls pipeline.model.forward); offline, standard library, fixed seed
Series
fwd_fan in data/series.json
Data

A table wider than the screen scrolls sideways.

Panel A: plotted percentiles, every third model month
Month 10th pct, % 25th pct, % 50th pct, % 75th pct, % 90th pct, %
2026-11-04 16.61 16.61 16.61 16.61 16.61
2027-02-03 10.50 13.07 16.74 21.54 26.04
2027-05-06 7.86 11.44 17.24 25.86 36.77
2027-08-05 6.79 10.82 18.69 31.16 49.12
2027-11-04 5.92 10.67 19.87 36.56 63.20
2028-02-04 5.38 10.30 21.02 42.29 78.46
2028-05-05 5.11 10.43 22.67 49.09 96.76
2028-08-04 4.81 10.54 24.71 56.22 120.74
2028-11-03 4.56 10.82 26.65 65.43 146.45
2029-02-03 4.28 10.80 28.68 74.60 182.08
2029-05-05 4.19 11.02 30.91 85.83 212.24
2029-08-04 3.91 10.86 31.24 92.31 238.83
2029-11-04 3.62 10.25 31.40 96.07 269.27
2030-02-03 3.37 10.09 32.41 104.92 298.12
2030-05-05 3.17 9.81 32.95 109.33 341.66
2030-08-05 2.96 9.39 33.30 116.76 366.11
2030-11-04 2.84 9.52 34.07 124.73 420.29
2031-02-03 2.75 9.32 35.37 130.57 470.93
2031-05-06 2.58 9.10 36.36 139.09 502.40
2031-08-05 2.46 8.91 37.65 147.06 543.04
2031-11-04 2.39 8.90 38.23 156.16 590.35

The case carried to the latest full day

The charts above stop at 2026-11-04, the pre-registered cutoff. The same code on DefiLlama, CoinGecko and Nearblocks data fetched on 2026-11-14 runs to 2026-11-13, and the conclusion stands: the price still assumes faster growth than any window in the data, and NEAR would still need more than Intents’ whole gross fee. The gap narrowed because NEAR’s price fell and revenue rose. Intents’ share of the peer set fell too, as THORChain’s volume rose (37.6% of the set over 30 days).

The case at the cutoff and at the update
Figure 2026-11-04 2026-11-13
Growth the price assumes, a year to 2031 84.9% 79.8%
Take NEAR would need, as a multiple of Intents’ whole gross fee 2.5× 1.6×
Base case: NEAR’s dilution paid for in 2031 44.6% 62.2%
Bull case: share of the revenue the price assumes 53.9% 65.9%
Coverage of dilution today (P3’s quantity, 90 days) 17.8% 18.2%
Captured revenue, 90 days at an annual rate $19.6M $21.2M
NEAR’s captured take, 90 days 4.13 bp 4.23 bp
Intents’ share of the peer set, 30 days 55.7% 45.8%
Intents’ share of the peer set, 90 days 61.7% 57.5%
Intents’ share of the peer set, 365 days 62.1% 60.3%
Peer-set volume, growth over the last year 13.4% 17.7%
NEAR market cap $4.82B $4.48B
NEAR’s market cap ÷ Intents’ gross fees, 365 days 89.2× 82.5×
When the ladder was developed

The headline ladder was developed alongside the pre-registered tests: a first split of the buyback wallet’s inflows into two collectors and single-use accounts funded from one account was committed on 2026-11-06 03:00 UTC, the ladder’s code and escrow dataset on 2026-11-06 23:19 UTC, before the H1b and H1c results (2026-11-06 23:23 UTC) and the H1a-as-written result (2026-11-06 23:49 UTC) were committed, and it became the thesis headline on 2026-11-07 00:21 UTC (addendum, 2026-11-08 02:03 UTC entry, item 1).

Supporting evidence

Intents leads its market, but most of its fees go to others, NEAR’s supply keeps growing and usage is down. This is context for the case, also exploratory: picked after the predictions were frozen. None of it is a test, and none of it feeds or changes a hypothesis, threshold, probability or the rating rule.

Market and peers

Intents had 55.7% of its peer set’s reported volume over 30 days and 62.1% over a year. NEAR’s market cap is 89.2× the gross fees Intents charged in a year; THORChain’s is 9.8× its own and Chainflip’s 1.8×.

Figure 7Exploratory#

Intents’ share of its peer set: 55.7% over 30 days, 62.1% over 365 days

NEAR Intents' share of the peer set's reported volume, by month A line from zero to 100 percent over 24 months. The latest point, 2026-11, is 47.2 percent, covering part of the month. A reference line marks 50 percent. NEAR Intents' share of Intents + THORChain + Chainflip + Maya volume, % The last point covers 1-4 November only. 0% 25% 50% 75% 100% 2025-02 2025-05 2025-08 2025-11 2026-02 2026-05 2026-08 2026-11 50% (the F4 bar) 47.2%
NEAR Intents' share of the peer set's reported volume, by month A line from zero to 100 percent over 24 months. The latest point, 2026-11, is 47.2 percent, covering part of the month. A reference line marks 50 percent. NEAR Intents' share of Intents + THORChain + Chainflip + Maya volume, % The last point covers 1-4 November only. 0% 25% 50% 75% 100% 2025-05 2025-11 2026-05 2026-11 50% (the F4 bar) 47.2%
Window: 2024-12 to 2026-11 (UTC), by calendar month. Unit: percent of reported volume.
Intents share, 30 days
55.7%
Intents share, 365 days
62.1%
30 days, net (halved) basis
38.6%
Notes and sources

NEAR Intents is 55.7% of its cross-chain peer set by reported volume over 30 days and 62.1% over 365 days.

What it shows: NEAR Intents’ share of the combined reported volume of Intents, THORChain, Chainflip and Maya (DefiLlama), by calendar month from 2024-12 to 2026-11; the monthly peak was 78.6% in 2026-06.

What it does not show: Volume is not the token: only 3.5% of 1Click volume has NEAR on one side, and a share of volume says nothing about revenue.

  • Reported Intents volume counts both legs of public swaps (measured), plus, from 2026-09-01, confidential-treasury flow at about one leg (measured; what that flow represents is inferred), which on the solver pairs is swap volume counted at close to both legs; DefiLlama’s adapter states no methodology, and this comes from a sum of intents.near settlement on five days and the solver pairs on three (exploratory, docs/leg-count.md, docs/confidential-flow.md). On one-sided volume the 30-day share is 39.7% to 41.2%, near the halved basis, 38.6%. Only Intents is restated.
  • The last month covers 1-4 November only. Forward test F4 asks whether the share over 2026-11-06 to 2026-11-13 is at least 50% on the reported basis; this chart gives context for that test.

Source:

Query
Endpoint
GET https://api.llama.fi/summary/dexs/<slug>?dataType=dailyVolume, slug in near-intents, thorchain-dex, chainflip-amm, maya-protocol
Fetcher
python3 -m pipeline.fetch_keyless (no key), function fetch_llama()
Monthly shares
pipeline/compute.py, series peer_share_monthly in data/series.json
Data

A table wider than the screen scrolls sideways.

Monthly share of the peer set's reported volume
Month NEAR Intents, % THORChain, % Chainflip, % Maya, %
2024-12 0.1 95.5 4.4 0.0
2025-01 0.1 95.1 4.7 0.0
2025-02 0.2 95.9 3.9 0.0
2025-03 0.5 93.2 6.3 0.0
2025-04 1.9 84.0 14.1 0.0
2025-05 2.6 90.6 6.9 0.0
2025-06 6.0 84.4 9.6 0.0
2025-07 9.9 77.0 13.1 0.0
2025-08 13.4 66.4 19.5 0.6
2025-09 24.3 51.1 22.7 1.9
2025-10 44.5 37.9 16.0 1.5
2025-11 66.8 20.2 10.7 2.3
2025-12 50.2 36.2 12.2 1.4
2026-01 63.7 25.6 9.4 1.3
2026-02 61.0 23.5 12.3 3.1
2026-03 63.8 25.5 9.3 1.4
2026-04 48.5 40.9 8.6 1.9
2026-05 68.6 12.3 17.0 2.1
2026-06 78.6 3.5 11.5 6.4
2026-07 65.3 23.7 9.5 1.5
2026-08 72.0 15.9 11.3 0.8
2026-09 61.7 31.5 6.8 0.0
2026-10 58.3 23.4 10.6 7.7
2026-11 47.2 28.4 22.7 1.7
Peer set, reported basis, to the as-of date
Venue Volume, 30 days, USD billion Volume, 365 days, USD billion Share, 30 days, %
NEAR Intents 4.0 32.9 55.7
THORChain 1.8 13.1 25.1
Chainflip 0.85 5.6 11.8
Maya 0.53 1.3 7.3
Figure 8Exploratory#

Market cap ÷ gross fees: NEAR 89.2×, THORChain 9.8×, Chainflip 1.8×

Market cap per dollar of fees: NEAR against the cross-chain swap venues with a listed token Bars from zero, multiples: NEAR's market cap is 89.2 times Intents' gross fees over 365 days and 245.0 times its captured revenue at the last 90 days' rate; THORChain's is 9.8 times its fees and Chainflip's 1.8. Market cap ÷ annual fees or revenue, × 0 50 100 150 200 250 NEAR ÷ captured revenue 245.0× NEAR ÷ Intents' gross fees 89.2× THORChain (RUNE) ÷ fees 9.8× Chainflip (FLIP) ÷ fees 1.8×
Market cap per dollar of fees: NEAR against the cross-chain swap venues with a listed token Bars from zero, multiples: NEAR's market cap is 89.2 times Intents' gross fees over 365 days and 245.0 times its captured revenue at the last 90 days' rate; THORChain's is 9.8 times its fees and Chainflip's 1.8. Market cap ÷ annual fees or revenue, × 0 50 100 150 200 250 NEAR ÷ captured revenue 245.0× NEAR ÷ Intents' gross fees 89.2× THORChain (RUNE) ÷ fees 9.8× Chainflip (FLIP) ÷ fees 1.8×
Market caps: 2026-11-05 23:00 UTC (NEAR $4.82B, 22:50). Fees: the 365 days to 2026-11-04.
Notes and sources

At the same hour, NEAR’s market cap was 89.2 times the gross fees NEAR Intents charged over 365 days and 245.0 times its captured revenue at the last 90 days’ rate; THORChain’s (RUNE) was 9.8 times its fees and Chainflip’s (FLIP) 1.8 times.

What it shows: What the market pays per dollar of fees for the cross-chain swap venues in the peer set that have a listed token, against NEAR, on DefiLlama’s fee series and CoinGecko’s market caps at one hour.

What it does not show: Like-for-like value. NEAR’s market cap prices the whole L1, of which Intents is one part; the peers’ multiples are on gross fees, most of which do not reach their tokens (DefiLlama counts only the small share of THORChain’s swap fees burned as RUNE as holders’ revenue). Maya Protocol is left out: its token (CACAO) is not listed on CoinGecko.

  • The peer market caps come from a fetch made on 2026-11-14 (python3 -m pipeline.fetch_peer_caps); only the hourly point nearest NEAR’s committed snapshot is used.
Query
Endpoint
GET https://api.coingecko.com/api/v3/coins/{near,thorchain,chainflip}/market_chart?vs_currency=usd&days=30
Fetcher
python3 -m pipeline.fetch_peer_caps (no key)
Data

A table wider than the screen scrolls sideways.

Plotted values (NEAR's market cap is in the caption)
Token Market cap, $M Fees, 365 days, $M Market cap ÷ fees, ×
NEAR (Intents' gross fees) 4.82B 54.01 89.2
THORChain (RUNE) 198.0 20.21 9.8
Chainflip (FLIP) 28.3 15.39 1.8

Revenue and the take rate

NEAR captured $2.19M in October, 5.49 bp of Intents’ reported volume. Its explicit fee inside 1Click rose from 1.83 bp to 4.08 bp over the window. From September the escrow supplied more than half of the buyback wallet’s NEAR (53.0% that month).

Figure 9Exploratory#

Captured revenue: $2.19M in October, 5.49 bp of volume

Captured Intents revenue and take rate, by month Panel A: columns from zero, captured revenue in USD million by month. Panel B: a line, captured revenue in basis points of DefiLlama's reported volume. 2026-10 is the peak at 5.49 basis points. A. Captured revenue per month, USD million 0 1 2 3 2025-02 2025-05 2025-08 2025-11: $0.768M captured revenue 2025-11 2025-12: $0.177M captured revenue 2026-01: $0.359M captured revenue 2026-02: $0.663M captured revenue 2026-02 2026-03: $0.563M captured revenue 2026-04: $0.259M captured revenue 2026-05: $0.62M captured revenue 2026-05 2026-06: $0.619M captured revenue 2026-07: $0.505M captured revenue 2026-08: $0.723M captured revenue 2026-08 2026-09: $1.84M captured revenue 2026-10: $2.19M captured revenue $2.19M 2026-11: $0.154M captured revenue 2026-11 B. Captured revenue ÷ DefiLlama reported volume, basis points 0 2 4 6 2025-02 2025-05 2025-08 2025-11 2026-02 2026-05 2026-08 2026-11 5.49 bp 2.96 bp
Captured Intents revenue and take rate, by month Panel A: columns from zero, captured revenue in USD million by month. Panel B: a line, captured revenue in basis points of DefiLlama's reported volume. 2026-10 is the peak at 5.49 basis points. A. Captured revenue per month, USD million 0 1 2 3 2025-05 2025-11: $0.768M captured revenue 2025-11 2025-12: $0.177M captured revenue 2026-01: $0.359M captured revenue 2026-02: $0.663M captured revenue 2026-03: $0.563M captured revenue 2026-04: $0.259M captured revenue 2026-05: $0.62M captured revenue 2026-05 2026-06: $0.619M captured revenue 2026-07: $0.505M captured revenue 2026-08: $0.723M captured revenue 2026-09: $1.84M captured revenue 2026-10: $2.19M captured revenue $2.19M 2026-11: $0.154M captured revenue 2026-11 B. Captured revenue ÷ DefiLlama reported volume, basis points 0 2 4 6 2025-05 2025-11 2026-05 2026-11 5.49 bp 2.96 bp
Window: 2024-12 to 2026-11 (UTC), by calendar month; the last month covers 1-4 November only.
Captured revenue, last 30 days
$1.99M
Captured take, last 30 days
4.98 bp
Captured share of gross fees, 30 days
32.5%
Notes and sources

Captured Intents revenue was $2.19M in October 2026, 5.49 bp of reported volume, up from 3.83 bp in September.

What it shows: Monthly captured revenue (DefiLlama dailyRevenue, which counts NEAR delivered to NEAR’s revenue wallets) and captured revenue as basis points of DefiLlama’s reported Intents volume.

What it does not show: Fees accrued: DefiLlama’s revenue is NEAR delivered to the wallets, so a month’s figure depends on when deliveries land, and the chart does not say which fee stream paid.

  • Revenue before the 2026-02-23 fee switch counts as captured, as DefiLlama labels it. Reported volume was $3.99B in October. The volume is what DefiLlama reports: both legs of public swaps, and from 2026-09-01 also the confidential flow, counted at close to both legs (exploratory, docs/confidential-flow.md; its adapter states no methodology). So it steps up on 2026-09-01 (see the take chart above), and months before September are on the old definition. On one-sided volume the last 30 days’ captured take is 8.97 to 9.55 bp.
  • The last month covers 1-4 November only. Forward test F3 asks whether the captured take over 2026-11-06 to 2026-11-13 is below 4.0 bp; this chart gives context for that test.

Source:

Query
Volume
GET https://api.llama.fi/summary/dexs/near-intents?dataType=dailyVolume
Revenue
GET https://api.llama.fi/summary/fees/near-intents?dataType=dailyRevenue
Gross fees
GET https://api.llama.fi/summary/fees/near-intents?dataType=dailyFees
Fetcher
python3 -m pipeline.fetch_keyless (no key), function fetch_llama()
Monthly sums
pipeline/compute.py, series intents_monthly in data/series.json
Data

A table wider than the screen scrolls sideways.

Monthly values
Month Reported volume, USD billion Captured revenue, USD million Captured take, bp Gross fees take, bp
2024-12 0.0 0.0 0.0 0.0
2025-01 0.01 0.0 0.0 0.0
2025-02 0.01 0.0 0.0 0.0
2025-03 0.02 0.0 0.0 0.0
2025-04 0.05 0.0 0.0 0.0
2025-05 0.09 0.0 0.0 0.0
2025-06 0.18 0.0 0.0 5.2
2025-07 0.24 0.0 0.0 9.2
2025-08 0.33 0.0 0.0 12.7
2025-09 0.48 0.0 0.0 14.7
2025-10 1.72 0.0 0.0 14.5
2025-11 3.66 0.768 2.1 21.2
2025-12 2.01 0.177 0.88 20.5
2026-01 2.72 0.359 1.32 16.2
2026-02 2.38 0.663 2.79 17.4
2026-03 2.08 0.563 2.71 17.3
2026-04 1.9 0.259 1.36 16.9
2026-05 2.0 0.62 3.1 15.0
2026-06 2.35 0.619 2.63 13.2
2026-07 2.21 0.505 2.29 14.8
2026-08 2.78 0.723 2.6 13.8
2026-09 4.8 1.84 3.83 15.3
2026-10 3.99 2.19 5.49 16.0
2026-11 0.52 0.154 2.96 14.1
Figure 10Exploratory#

NEAR’s explicit 1Click fee: up from 1.83 bp to 4.08 bp of volume

NEAR's take and partners' take in three 30-day blocks, basis points of volume Grouped columns from zero in basis points for three 30-day blocks. Explicit buyback fee: 1.83, 2.84, 4.08. Partner fees: 32.5, 43.7, 40.3. Captured revenue on DefiLlama's basis: 2.89, 4.25, 4.98. Basis points of volume (1 bp = 0.01%) NEAR's explicit buyback fee, bp of 1Click volume Partner fees, bp of 1Click volume Captured ÷ DefiLlama volume, bp (other basis) 0 10 20 30 40 50 Aug 7 – Sep 5: NEAR's explicit buyback fee, bp of 1Click volume 1.83 1.83 Aug 7 – Sep 5: Partner fees, bp of 1Click volume 32.5 32.5 Aug 7 – Sep 5: Captured ÷ DefiLlama volume, bp (other basis) 2.89 2.89 Aug 7 – Sep 5 Sep 6 – Oct 5: NEAR's explicit buyback fee, bp of 1Click volume 2.84 2.84 Sep 6 – Oct 5: Partner fees, bp of 1Click volume 43.7 43.7 Sep 6 – Oct 5: Captured ÷ DefiLlama volume, bp (other basis) 4.25 4.25 Sep 6 – Oct 5 Oct 6 – Nov 4: NEAR's explicit buyback fee, bp of 1Click volume 4.08 4.08 Oct 6 – Nov 4: Partner fees, bp of 1Click volume 40.3 40.3 Oct 6 – Nov 4: Captured ÷ DefiLlama volume, bp (other basis) 4.98 4.98 Oct 6 – Nov 4
NEAR's take and partners' take in three 30-day blocks, basis points of volume Grouped columns from zero in basis points for three 30-day blocks. Explicit buyback fee: 1.83, 2.84, 4.08. Partner fees: 32.5, 43.7, 40.3. Captured revenue on DefiLlama's basis: 2.89, 4.25, 4.98. Basis points of volume (1 bp = 0.01%) NEAR's explicit buyback fee, bp of 1Click volume Partner fees, bp of 1Click volume Captured ÷ DefiLlama volume, bp (other basis) 0 10 20 30 40 50 Aug 7 – Sep 5: NEAR's explicit buyback fee, bp of 1Click volume 1.83 1.83 Aug 7 – Sep 5: Partner fees, bp of 1Click volume 32.5 32.5 Aug 7 – Sep 5: Captured ÷ DefiLlama volume, bp (other basis) 2.89 2.89 Aug 7 – Sep 5 Sep 6 – Oct 5: NEAR's explicit buyback fee, bp of 1Click volume 2.84 2.84 Sep 6 – Oct 5: Partner fees, bp of 1Click volume 43.7 43.7 Sep 6 – Oct 5: Captured ÷ DefiLlama volume, bp (other basis) 4.25 4.25 Sep 6 – Oct 5 Oct 6 – Nov 4: NEAR's explicit buyback fee, bp of 1Click volume 4.08 4.08 Oct 6 – Nov 4: Partner fees, bp of 1Click volume 40.3 40.3 Oct 6 – Nov 4: Captured ÷ DefiLlama volume, bp (other basis) 4.98 4.98 Oct 6 – Nov 4
Windows: 2026-08-07 to 2026-11-04 in three 30-day blocks (UTC). Unit: basis points.
Notes and sources

NEAR’s explicit fee inside 1Click rose from 1.83 bp of volume (Aug 7 – Sep 5) to 4.08 bp (Oct 6 – Nov 4), mostly because more volume carries a buyback fee entry; partner fees were 40.3 bp in the last block.

What it shows: NEAR’s explicit buyback fee, partner fees and, on a different basis, captured revenue, in basis points of volume, over three 30-day blocks of 1Click swaps from the NEAR Intents Explorer API.

What it does not show: The period since the 2026-02-23 fee switch (this covers 90 days), and a like-for-like comparison of the captured-revenue bars, because DefiLlama’s volume series steps up on 2026-09-01.

  • NEAR’s explicit take rose mainly because more volume carries a buyback fee entry (23.6% of volume in the first block, 43.0% in the last); SwapKit’s share barely moved: it stayed between 35.6% and 38.2%.
  • 1Click’s share of DefiLlama’s volume falls from 86.2% in the week before 2026-09-01 to 60.8% in the week from that day, with no matching change in 1Click’s own volume (both shares are on the halved basis used elsewhere on this page; on DefiLlama’s reported basis they would be half as large). That is consistent with DefiLlama counting more of Intents’ volume from that date, and a later sum of intents.near settlement shows it: from 2026-09-01 the series adds confidential-treasury flow at about one leg (exploratory, docs/leg-count.md). If so, the first block’s 2.89 bp is overstated and the true rise is, if anything, larger.
  • Partner numbers rest on one key-gated source, the Explorer API.
  • The grey bars use a different denominator and are not like-for-like with the other two.

Source:

Query
1Click swaps
GET https://explorer.near-intents.org/api/v0/transactions?statuses=SUCCESS (per-day cursor pull)
Fetcher
python3 -m pipeline.fetch_explorer 2026-08-07 2026-11-04 (needs NEAR_INTENTS_EXPLORER_JWT; about 1h45m per 30 days)
DefiLlama
GET https://api.llama.fi/summary/dexs/near-intents?dataType=dailyVolume and GET https://api.llama.fi/summary/fees/near-intents?dataType=dailyRevenue
Fetcher
python3 -m pipeline.fetch_keyless (no key)
Arithmetic
pipeline/compute.py, function take_over_time()
Data

A table wider than the screen scrolls sideways.

Plotted values and the context behind them
Block Explicit buyback fee, bp Partner fees, bp Share of volume with a buyback fee entry, % SwapKit share of volume, % Captured revenue ÷ reported volume (DefiLlama), bp 1Click volume, USD million
Aug 7 – Sep 5 (2026-08-07..2026-09-05) 1.83 32.5 23.6 35.6 2.89 1,269
Sep 6 – Oct 5 (2026-09-06..2026-10-05) 2.84 43.7 39.0 37.9 4.25 1,442
Oct 6 – Nov 4 (2026-10-06..2026-11-04) 4.08 40.3 43.0 38.2 4.98 1,104
Figure 11Exploratory#

Escrow share of the buyback wallet’s NEAR: 28.6% in August, 53.0% in September

Share of the buyback wallet's NEAR that arrived through the Confidential Intents escrow, by month Columns from zero in percent, one per month from July to November 2026: Jul 2026 17.5, Aug 2026 28.6, Sep 2026 53.0, Oct 2026 57.4, Nov 2026 58.5. Escrow unshields as % of NEAR delivered to buybacks.multisignature.near 0% 25% 50% 75% 100% Jul 2026: 17.5% of NEAR delivered to the buyback wallet came through the escrow 17.5% Jul (from 07-07) Aug 2026: 28.6% of NEAR delivered to the buyback wallet came through the escrow 28.6% Aug Sep 2026: 53.0% of NEAR delivered to the buyback wallet came through the escrow 53.0% Sep Oct 2026: 57.4% of NEAR delivered to the buyback wallet came through the escrow 57.4% Oct Nov 2026: 58.5% of NEAR delivered to the buyback wallet came through the escrow 58.5% Nov (to 11-04) funding hop attributed from samples funding hop traced per single-use delivery from 2026-10-06 October includes 2026-10-01 to 2026-10-05, attributed from samples.
Share of the buyback wallet's NEAR that arrived through the Confidential Intents escrow, by month Columns from zero in percent, one per month from July to November 2026: Jul 2026 17.5, Aug 2026 28.6, Sep 2026 53.0, Oct 2026 57.4, Nov 2026 58.5. Escrow unshields as % of NEAR delivered to buybacks.multisignature.near 0% 25% 50% 75% 100% Jul 2026: 17.5% of NEAR delivered to the buyback wallet came through the escrow 17.5% Jul (from 07-07) Aug 2026: 28.6% of NEAR delivered to the buyback wallet came through the escrow 28.6% Aug Sep 2026: 53.0% of NEAR delivered to the buyback wallet came through the escrow 53.0% Sep Oct 2026: 57.4% of NEAR delivered to the buyback wallet came through the escrow 57.4% Oct Nov 2026: 58.5% of NEAR delivered to the buyback wallet came through the escrow 58.5% Nov (to 11-04) funding hop attributed from samples funding hop traced per single-use delivery from 2026-10-06 October includes 2026-10-01 to 2026-10-05, attributed from samples.
Window: 2026-07-07 to 2026-11-04 (UTC), by calendar month. Unit: percent of NEAR delivered.
Single-use deliveries in the 30-day window
909
Funded by the escrow for the exact amount
909 (100.0%)
Escrow share, 30-day window
58.8%
Notes and sources

The escrow’s share of the buyback wallet’s NEAR stepped up once, at the end of August, and has been flat since: 17.5% in July and 28.6% in August, then 53.0% in September, 57.4% in October and 58.5% for 1-4 November.

What it shows: For each calendar month, the share of NEAR delivered to buybacks.multisignature.near that came from single-use accounts funded by the Confidential Intents escrow (unshields), apart from what the recurring fee collectors delivered.

What it does not show: Which fee stream the escrow NEAR comes from, which is unattested (the releases move day by day with confidential swap volume, docs/confidential-flow.md), and any share in USD terms: these are shares of NEAR delivered.

  • Before 2026-10-06 the funding of a single-use (escrow-path) delivery is mostly attributed from samples; from that date the funding hop of every single-use (escrow-path) delivery in the window is traced (every single-use delivery in the 30-day window, 909), so the earlier months are less firmly established. In the window, deliveries from the two recurring fee collectors and from the one other recurring source have no funding hop. July starts on 2026-07-07 and November covers 1-4 November only.
  • In the 30-day window all 909 single-use deliveries are recorded as funded by the escrow for the exact amount, to the yoctoNEAR (100.0%). It tallies two columns of the per-delivery table over the window’s single-use accounts, a set that the committed BigQuery output defines without them; the funding scan that filled the columns is not in this repository.
  • The re-read against the chain on 2026-11-08 (python3 -m pipeline.fetch_escrow verify --all, output in data/raw/escrow/verify_all.json): 3,587 of 3,597 rows pass every check, the other 10 differ in block height alone (one to three blocks off), and all 1,051 funding transfers pass, 909 of them in the window. The command therefore exits with an error status on these data.
  • The escrow is account 51e8f94d…7cbe, PRIVATE_TREASURY_ACCOUNT_ID in NEAR’s Confidential Intents docs, where it is called the Treasury.

Source:

Query

This SQL covers only 2026-10-06 to 2026-11-04. Its committed output, data/raw/bq/buyback_withdraw_sources.json, has the same NEAR per day and wallet as the per-delivery table the chart is drawn from, data/raw/escrow/deliveries.csv, over those days; it does not trace funding hops. Earlier deliveries, and the funding hops of the single-use deliveries, come from the sources that data/MANIFEST.json records for that table: intents.near native_withdraw deliveries to the 3 revenue wallets, 2026-07-07..11-04, with funding hops (BigQuery job bqjob_r275b038b73d7c093_000001a1af3708a8_1 for October; FastNEAR samples before). The monthly shares are computed in pipeline/compute.py, function escrow_ladder, from the per-delivery table. Re-check any delivery with python3 -m pipeline.fetch_escrow verify --sample 60.

sql/buyback_withdraw_sources.sql 1,162 bytes

-- Which intents.near accounts deliver native NEAR to NEAR's revenue wallets (dip4 native_withdraw
-- events), 2026-10-06..11-04, per day, source account and wallet. Recurring sources are fee
-- collectors; single-use sources are fresh accounts that receive NEAR unshielded from the Confidential Intents
-- treasury (PRIVATE_TREASURY_ACCOUNT_ID 51e8f94d...7cbe, docs.near-intents.org) and withdraw it.
SELECT o.block_date AS day,
       JSON_VALUE(d, '$.account_id') AS src,
       JSON_VALUE(d, '$.receiver_id') AS wallet,
       COUNT(*) AS n,
       CAST(SUM(CAST(JSON_VALUE(d, '$.amount') AS BIGNUMERIC)) / 1e24 AS STRING) AS near
FROM `bigquery-public-data.crypto_near_mainnet_us.execution_outcomes` o, UNNEST(o.logs.list) l,
  UNNEST(JSON_QUERY_ARRAY(SUBSTR(l.element, 12), '$.data')) d
WHERE o.block_date BETWEEN '2026-10-06' AND '2026-11-04'
  AND o.executor_account_id = 'intents.near'
  AND l.element LIKE 'EVENT_JSON:%native_withdraw%'
  AND JSON_VALUE(d, '$.receiver_id') IN ('buybacks.multisignature.near', 'fefundsadmin.sputnik-dao.near',
                                         '1csfundsadmin.sputnik-dao.near')
GROUP BY 1, 2, 3
ORDER BY 1, 2, 3
Data

A table wider than the screen scrolls sideways.

Plotted values
Month Escrow share of the buyback wallet's NEAR, % Note
Jul 2026 17.5 from 07-07
Aug 2026 28.6
Sep 2026 53.0
Oct 2026 57.4
Nov 2026 58.5

Who else gets paid

Partners’ listed fees were 1.44× to 2.22× NEAR’s whole captured revenue. SwapKit alone routed 38.2% of 1Click volume and paid NEAR $159 in explicit fees over 30 days.

Figure 12Exploratory#

SwapKit: 38.2% of 1Click volume, $159 in explicit fees to NEAR in 30 days

Who pays NEAR's explicit fees, and what SwapKit's exit could cost Panel A, bars from zero in percent: for SwapKit and the eight channels paying NEAR the most explicit buyback fees, the share of 1Click volume against the share of NEAR's explicit buyback fees. SwapKit has 38.2 percent of volume and 159 dollars of explicit fees. Panel B: share of captured revenue lost if SwapKit left, 2.0 percent on traceable streams, 43.0 as a ceiling and 73.7 as a wider ceiling. A. Share of 1Click volume and of NEAR's explicit buyback fees, 30 days, % Share of 1Click volume Share of NEAR's explicit buyback fees 0% 10% 20% 30% 40% 50% SwapKit (Ledger, Trust, Tangem and others) SwapKit share of 1Click volume: 38.2% 38.2% SwapKit explicit buyback fees: $159 $159 of explicit fees No referrer (default fee) No referrer (default fee): 18.7% of volume 18.7% No referrer (default fee): 45.8% of explicit fees 45.8% trustwallet trustwallet: 2.4% of volume 2.4% trustwallet: 12.0% of explicit fees 12.0% Unnamed integrator (e1a72603…) Unnamed integrator (e1a72603…): 0.4% of volume 0.4% Unnamed integrator (e1a72603…): 7.2% of explicit fees 7.2% lifi lifi: 10.0% of volume 10.0% lifi: 6.9% of explicit fees 6.9% arbie arbie: 1.4% of volume 1.4% arbie: 6.9% of explicit fees 6.9% rango rango: 5.8% of volume 5.8% rango: 5.8% of explicit fees 5.8% leodex leodex: 0.4% of volume 0.4% leodex: 1.9% of explicit fees 1.9% enot enot: 0.3% of volume 0.3% enot: 1.5% of explicit fees 1.5% B. If SwapKit stopped routing through 1Click: share of captured Intents revenue lost, % 0% 25% 50% 75% 100% Traceable streams: explicit fees plus quote-improvement share, pro rata Traceable: 2.0% 2.0% Ceiling: also all escrow NEAR unshielded to the buyback wallet Ceiling: 43.0% 43.0% Wider ceiling: also the escrow NEAR that reached fefundsadmin Wider ceiling: 73.7% 73.7%
Who pays NEAR's explicit fees, and what SwapKit's exit could cost Panel A, bars from zero in percent: for SwapKit and the eight channels paying NEAR the most explicit buyback fees, the share of 1Click volume against the share of NEAR's explicit buyback fees. SwapKit has 38.2 percent of volume and 159 dollars of explicit fees. Panel B: share of captured revenue lost if SwapKit left, 2.0 percent on traceable streams, 43.0 as a ceiling and 73.7 as a wider ceiling. A. Share of 1Click volume and of NEAR's explicit buyback fees, 30 days, % Share of 1Click volume Share of NEAR's explicit buyback fees 0% 10% 20% 30% 40% 50% SwapKit (Ledger, Trust, Tangem and others) SwapKit share of 1Click volume: 38.2% 38.2% SwapKit explicit buyback fees: $159 $159 of explicit fees No referrer (default fee) No referrer (default fee): 18.7% of volume 18.7% No referrer (default fee): 45.8% of explicit fees 45.8% trustwallet trustwallet: 2.4% of volume 2.4% trustwallet: 12.0% of explicit fees 12.0% Unnamed integrator (e1a72603…) Unnamed integrator (e1a72603…): 0.4% of volume 0.4% Unnamed integrator (e1a72603…): 7.2% of explicit fees 7.2% lifi lifi: 10.0% of volume 10.0% lifi: 6.9% of explicit fees 6.9% arbie arbie: 1.4% of volume 1.4% arbie: 6.9% of explicit fees 6.9% rango rango: 5.8% of volume 5.8% rango: 5.8% of explicit fees 5.8% leodex leodex: 0.4% of volume 0.4% leodex: 1.9% of explicit fees 1.9% enot enot: 0.3% of volume 0.3% enot: 1.5% of explicit fees 1.5% B. If SwapKit stopped routing through 1Click: share of captured Intents revenue lost, % 0% 25% 50% 75% 100% Traceable streams: explicit fees plus quote-improvement share, pro rata Traceable: 2.0% 2.0% Ceiling: also all escrow NEAR unshielded to the buyback wallet Ceiling: 43.0% 43.0% Wider ceiling: also the escrow NEAR that reached fefundsadmin Wider ceiling: 73.7% 73.7%
Window: the 30 days 2026-10-06 to 2026-11-04 (UTC). Unit: percent.
SwapKit share of 1Click volume
38.2%
SwapKit share of all Intents volume, halved basis
21.1%
Volume HHI, SwapKit as one channel / split
0.200 / 0.087
Explicit buyback fee HHI
0.244
Notes and sources

SwapKit routes 38.2% of 1Click volume but paid NEAR $159 in explicit fees over 30 days; if it left, NEAR would lose about 2.0% of captured revenue on the traceable streams. The ceiling is 43.0% if all the escrow NEAR delivered to the buyback wallet counts as SwapKit’s, and 73.7% if the escrow NEAR reaching the front-end fund is counted too.

What it shows: For SwapKit and for the channels that pay NEAR the most explicit buyback fees, each channel’s share of 1Click volume against its share of NEAR’s explicit buyback fees over the 30 days 2026-10-06 to 2026-11-04, and what NEAR would lose if SwapKit stopped routing through 1Click.

What it does not show: Most of the NEAR the buyback wallet receives cannot be traced to any channel on chain, so that part of the exposure is unknown and may be above zero: the ceilings count every escrow unshield as if it came from SwapKit, which neither candidate reading of that stream supports, and the ledger cannot tell 0% from about 22.4% for SwapKit (19.6% on the tighter reading).

  • 45.8% of NEAR’s explicit fees come from swaps with no referral, meaning integrators on the default fee; the top three channels account for 65.0%.
  • The pro-rata assumption (collector B’s quote improvement allocated to SwapKit by volume share) has support, since SwapKit swaps do pay collector B (9 of the 67 sampled), but its size is not measured. Fee mechanics come from a sample of 195 swaps.
  • SwapKit’s fee bar is to scale, just too short to see.

Source:

Query

sql/buyback_withdraw_sources.sql 1,162 bytes

-- Which intents.near accounts deliver native NEAR to NEAR's revenue wallets (dip4 native_withdraw
-- events), 2026-10-06..11-04, per day, source account and wallet. Recurring sources are fee
-- collectors; single-use sources are fresh accounts that receive NEAR unshielded from the Confidential Intents
-- treasury (PRIVATE_TREASURY_ACCOUNT_ID 51e8f94d...7cbe, docs.near-intents.org) and withdraw it.
SELECT o.block_date AS day,
       JSON_VALUE(d, '$.account_id') AS src,
       JSON_VALUE(d, '$.receiver_id') AS wallet,
       COUNT(*) AS n,
       CAST(SUM(CAST(JSON_VALUE(d, '$.amount') AS BIGNUMERIC)) / 1e24 AS STRING) AS near
FROM `bigquery-public-data.crypto_near_mainnet_us.execution_outcomes` o, UNNEST(o.logs.list) l,
  UNNEST(JSON_QUERY_ARRAY(SUBSTR(l.element, 12), '$.data')) d
WHERE o.block_date BETWEEN '2026-10-06' AND '2026-11-04'
  AND o.executor_account_id = 'intents.near'
  AND l.element LIKE 'EVENT_JSON:%native_withdraw%'
  AND JSON_VALUE(d, '$.receiver_id') IN ('buybacks.multisignature.near', 'fefundsadmin.sputnik-dao.near',
                                         '1csfundsadmin.sputnik-dao.near')
GROUP BY 1, 2, 3
ORDER BY 1, 2, 3

sql/collector_inflows.sql 1,688 bytes

-- Token inflows to the two intents.near accounts that withdraw NEAR to buybacks.multisignature.near
-- on a recurring basis (identified from native_withdraw events, 2026-10-06..11-04):
--   5880ad2b... ("collector A"): receives the explicit buyback appFee on each 1Click swap
--   143f2bb4... ("collector B"): receives a variable share consistent with quote-improvement sharing
-- Per day, collector and token: summed raw amounts (token base units) and transfer counts.
WITH c AS (
  SELECT * FROM UNNEST(['5880ad2b362620fadf759cbceb1cd5737ce8c6ed7fb8e9942881e6731f9247dd',
                        '143f2bb439575c286f4f585163f0e5fb4e464f8ce57ec06ae80741407d3cfb31']) AS acct
),
t AS (
  SELECT o.block_date AS day, JSON_VALUE(d, '$.receiver_id') AS collector, JSON_QUERY(d, '$.tokens') AS tokens
  FROM `bigquery-public-data.crypto_near_mainnet_us.execution_outcomes` o, UNNEST(o.logs.list) l,
    UNNEST(JSON_QUERY_ARRAY(SUBSTR(l.element, 12), '$.data')) d
  WHERE o.block_date BETWEEN '2026-10-06' AND '2026-11-04'
    AND o.executor_account_id = 'intents.near'
    AND l.element LIKE 'EVENT_JSON:{"standard":"dip4"%"event":"transfer"%'
    AND (l.element LIKE '%"receiver_id":"5880ad2b362620fadf759cbceb1cd5737ce8c6ed7fb8e9942881e6731f9247dd"%'
      OR l.element LIKE '%"receiver_id":"143f2bb439575c286f4f585163f0e5fb4e464f8ce57ec06ae80741407d3cfb31"%')
)
SELECT day, collector, REGEXP_EXTRACT(kv, r'^"([^"]+)"') AS token,
       CAST(SUM(CAST(REGEXP_EXTRACT(kv, r':"([0-9]+)"$') AS BIGNUMERIC)) AS STRING) AS amount,
       COUNT(*) AS n
FROM t, UNNEST(REGEXP_EXTRACT_ALL(tokens, r'"[^"]+":"[0-9]+"')) AS kv
WHERE collector IN (SELECT acct FROM c)
GROUP BY 1, 2, 3
ORDER BY 1, 2, 3

sql/revenue_wallet_inflows.sql 1,103 bytes

-- NEAR's Intents revenue wallets: native NEAR arriving from outside the wallet set, per day,
-- wallet and sender. Mirrors the `moves` CTE of DefiLlama's near-intents adapter (native part;
-- wNEAR inflows are checked separately). Window: the 30 days of the Explorer pull, 2026-10-06 to 2026-11-04 (a since-switch window scans ~890 GB).
WITH w AS (
  SELECT * FROM UNNEST(['fefundsadmin.sputnik-dao.near', '1csfundsadmin.sputnik-dao.near',
                        'buybacks.multisignature.near']) AS wallet
)
SELECT block_date AS day,
       receipt_receiver_account_id AS wallet,
       receipt_predecessor_account_id AS sender,
       ROUND(SUM(CAST(JSON_VALUE(args, '$.deposit') AS BIGNUMERIC) / 1e24), 4) AS near,
       COUNT(*) AS n
FROM `bigquery-public-data.crypto_near_mainnet_us.receipt_actions`
WHERE block_date BETWEEN '2026-10-06' AND '2026-11-04'
  AND action_kind = 'TRANSFER'
  AND receipt_receiver_account_id IN (SELECT wallet FROM w)
  AND receipt_predecessor_account_id NOT IN (SELECT wallet FROM w)
  AND receipt_predecessor_account_id != 'system'
GROUP BY 1, 2, 3
ORDER BY 1, 2, 3
1Click swaps by channel
GET https://explorer.near-intents.org/api/v0/transactions?statuses=SUCCESS (aggregated into data/raw/explorer/daily.json by pipeline/fetch_explorer.py)
Data

A table wider than the screen scrolls sideways.

Panel A: plotted values (SwapKit's fee column is its explicit fees in USD)
Channel Share of 1Click volume, % Share of NEAR's explicit buyback fees, %
SwapKit 38.2 $159
(none) 18.7 45.8
trustwallet 2.4 12.0
e1a72603-64b3-4be1-8265-8bae5970d396 0.4 7.2
lifi 10.0 6.9
arbie 1.4 6.9
rango 5.8 5.8
leodex 0.4 1.9
enot 0.3 1.5
Panel B: plotted values
If SwapKit stopped routing through 1Click Share of captured Intents revenue lost, %
Traceable streams 2.0
Ceiling (all escrow NEAR to the buyback wallet) 43.0
Wider ceiling (also the escrow NEAR to fefundsadmin) 73.7
Figure 13Exploratory#

Listed partner fees: 1.44× to 2.22× NEAR’s captured revenue

Partner fees listed by 1Click against NEAR's revenue, and which way 1Click moves NEAR Panel A, bars from zero in multiples of NEAR's entire captured revenue, with a reference line at 1: listed partner fees came to 1.75 times it at the wide lower bound, 1.81 at the tight lower bound and 2.22 at the upper. Panel B: 1Click swaps into NEAR 14.6 million dollars, out of NEAR 24.0 million. A. Partners' listed fees ÷ NEAR's entire captured revenue 0× 0.5× 1× 1.5× 2× 2.5× Wide lower bound: all unexplained NEAR in the buyback wallet counted as partner fees passed on Wide lower bound: 1.75× 1.75× Tight lower bound: only escrow unshields counted as passed on Tight lower bound: 1.81× 1.81× Upper: all listed partner fees, none passed on Upper: 2.22× 2.22× 1×: equal to NEAR's whole captured revenue B. 1Click swaps with NEAR on one side, USD million, 30 days 0 10 20 30 1Click swaps into NEAR Into NEAR: $14.6M $14.6M 1Click swaps out of NEAR Out of NEAR: $24.0M $24.0M
Partner fees listed by 1Click against NEAR's revenue, and which way 1Click moves NEAR Panel A, bars from zero in multiples of NEAR's entire captured revenue, with a reference line at 1: listed partner fees came to 1.75 times it at the wide lower bound, 1.81 at the tight lower bound and 2.22 at the upper. Panel B: 1Click swaps into NEAR 14.6 million dollars, out of NEAR 24.0 million. A. Partners' listed fees ÷ NEAR's entire captured revenue 0× 0.5× 1× 1.5× 2× 2.5× Wide lower bound: all unexplained NEAR in the buyback wallet counted as partner fees passed on Wide lower bound: 1.75× 1.75× Tight lower bound: only escrow unshields counted as passed on Tight lower bound: 1.81× 1.81× Upper: all listed partner fees, none passed on Upper: 2.22× 2.22× 1×: equal to NEAR's whole captured revenue B. 1Click swaps with NEAR on one side, USD million, 30 days 0 10 20 30 1Click swaps into NEAR Into NEAR: $14.6M $14.6M 1Click swaps out of NEAR Out of NEAR: $24.0M $24.0M
Window: the 30 days 2026-10-06 to 2026-11-04 (UTC). Blue: the bound the headline quotes.
Partner fees listed
$4,454.2K
NEAR's captured revenue
$2,009.7K
Net NEAR sold through 1Click
$9.4M
Share of 1Click volume with NEAR on one side
3.5%
Notes and sources

Listed partner fees were 1.44× to 2.22× NEAR’s entire captured revenue (1.75× is one reading, 1.81× on the tighter one), and 1Click was a net route out of NEAR: $24.0M out against $14.6M in over 30 days.

What it shows: The fees 1Click swaps listed for partners ($4,454.2K) as a multiple of NEAR’s entire captured Intents revenue ($2,009.7K), between 1.75× and 2.22× on the readings charted, and 1Click swap volume into and out of NEAR, over the 30 days 2026-10-06 to 2026-11-04.

What it does not show: The other half of Intents: 1Click is 55.2% of DefiLlama’s volume on the halved basis (49.7% to 52.9% on one-sided volume, taking confidential solver shields as one-sided confidential volume; exploratory), and near.com, direct solver flow and other integrations have a fee structure the Explorer API does not show, so we do not extrapolate.

  • The wide reading counts all the NEAR in the buyback wallet that the explicit fee entries do not explain as partner fees passed on to NEAR: the listed partner fees left after that are at least 1.75× NEAR’s revenue, and at most 22.4% of the fees on partner swaps with no buyback fee entry reached NEAR. The tight reading counts only the escrow unshields, reading collector B’s NEAR as quote improvement, a role that is inferred and unproven: 1.81× and 19.6%. Both leave out the escrow NEAR that reached the front-end fund, where the ledger cannot exclude a partner settlement. If that NEAR ($616.9K) may be partner money too, the floor is 1.44× and NEAR’s share of those fees at most 37.0% (exploratory; docs/second-review.md).
  • In the per-swap sample (195 swaps from 3 sampled hours) every non-zero partner fee entry was matched on chain by a payment of about the listed amount to an account other than NEAR’s two fee collectors, except 1 unmatched entry, in a swap whose tokens went into the Confidential Intents escrow, where the public chain shows no fee on that route. A further 10 SwapKit entries and 3 others list a zero rate, so nothing is owed on them and no amount can match. Who owns those receiving accounts is not shown, so the sample shows the listed amount leaving the swap in one piece; it does not show who keeps it. So no split comes out of a listed fee in that sample; whatever 1Click charges on top, and whether it forwards any of it to NEAR, is not visible.
  • 1Click swaps out of NEAR are not exchange deposits: H1b counts only labelled centralized-exchange accounts and does not see this non-custodial route. Only 3.5% of 1Click volume has NEAR on one side.
  • Partner numbers rest on one key-gated source, the Explorer API.

Source:

Query

The wNEAR query returned zero rows, but it reads ft_events, which appears not to record wrap.near transfers, so that zero is uninformative. The evidence that wNEAR inflows are negligible is the reconciliation: the native-only total is 100.9% of DefiLlama’s revenue.

sql/revenue_wallet_inflows.sql 1,103 bytes

-- NEAR's Intents revenue wallets: native NEAR arriving from outside the wallet set, per day,
-- wallet and sender. Mirrors the `moves` CTE of DefiLlama's near-intents adapter (native part;
-- wNEAR inflows are checked separately). Window: the 30 days of the Explorer pull, 2026-10-06 to 2026-11-04 (a since-switch window scans ~890 GB).
WITH w AS (
  SELECT * FROM UNNEST(['fefundsadmin.sputnik-dao.near', '1csfundsadmin.sputnik-dao.near',
                        'buybacks.multisignature.near']) AS wallet
)
SELECT block_date AS day,
       receipt_receiver_account_id AS wallet,
       receipt_predecessor_account_id AS sender,
       ROUND(SUM(CAST(JSON_VALUE(args, '$.deposit') AS BIGNUMERIC) / 1e24), 4) AS near,
       COUNT(*) AS n
FROM `bigquery-public-data.crypto_near_mainnet_us.receipt_actions`
WHERE block_date BETWEEN '2026-10-06' AND '2026-11-04'
  AND action_kind = 'TRANSFER'
  AND receipt_receiver_account_id IN (SELECT wallet FROM w)
  AND receipt_predecessor_account_id NOT IN (SELECT wallet FROM w)
  AND receipt_predecessor_account_id != 'system'
GROUP BY 1, 2, 3
ORDER BY 1, 2, 3

sql/revenue_wallet_wnear_inflows.sql 918 bytes

-- wNEAR (wrap.near) arriving at NEAR's Intents revenue wallets from outside the wallet set,
-- per day, wallet and counterparty. The token half of DefiLlama's `moves` CTE. Fee switch to 2026-11-04.
WITH w AS (
  SELECT * FROM UNNEST(['fefundsadmin.sputnik-dao.near', '1csfundsadmin.sputnik-dao.near',
                        'buybacks.multisignature.near']) AS wallet
)
SELECT block_date AS day, affected_account_id AS wallet, involved_account_id AS sender,
       ROUND(SUM(CAST(delta_amount AS BIGNUMERIC) / 1e24), 4) AS near, COUNT(*) AS n
FROM `bigquery-public-data.crypto_near_mainnet_us.ft_events`
WHERE block_date BETWEEN '2026-02-23' AND '2026-11-04'
  AND contract_account_id = 'wrap.near'
  AND affected_account_id IN (SELECT wallet FROM w)
  AND CAST(delta_amount AS BIGNUMERIC) > 0
  AND (involved_account_id IS NULL OR involved_account_id NOT IN (SELECT wallet FROM w))
GROUP BY 1, 2, 3
ORDER BY 1, 2, 3
Data

A table wider than the screen scrolls sideways.

Plotted values
Measure Value Unit
Partner fees listed on 1Click swaps 4,454.2 USD thousand
NEAR's captured revenue, three revenue wallets 2,009.7 USD thousand
Listed partner fees ÷ NEAR's revenue, wide lower bound 1.75 ×
Listed partner fees ÷ NEAR's revenue, tight lower bound 1.81 ×
Listed partner fees ÷ NEAR's revenue, upper 2.22 ×
1Click swaps into NEAR 14.6 USD million
1Click swaps out of NEAR 24.0 USD million
Net NEAR sold through 1Click 9.4 USD million

Supply and dilution

Supply grew 2.48% in a year, about 88.2K NEAR a day net. On the rating rule’s path it grows 9.4% more by 2031 if HSP-029’s cut takes effect and 13.1% if not.

Figure 14Exploratory#

Supply: up 2.48% in 365 days; net issuance 88.2K NEAR a day

NEAR supply at each month end, and net issuance per day over the last 90 days Panel A: a line of total supply at each month end, from 1,222.928 million to 1,310.833 million NEAR, on an axis that starts at 1,200 million. Panel B: columns from zero, daily net issuance in thousand NEAR over 90 days, with a reference line at the 30-day mean, 88.2 thousand. A. Total supply at each month end, million NEAR The vertical axis starts at 1,200M. 1200 1240 1280 1320 2024-11 2025-02 2025-05 2025-08 2025-11 2026-02 2026-05 2026-08 2026-11 1,310.833M B. Net issuance per day, thousand NEAR 30-day mean 88.2K 0 40 80 120 Aug 21 Sep 5 Sep 20 Oct 5 Oct 20 Nov 4
NEAR supply at each month end, and net issuance per day over the last 90 days Panel A: a line of total supply at each month end, from 1,222.928 million to 1,310.833 million NEAR, on an axis that starts at 1,200 million. Panel B: columns from zero, daily net issuance in thousand NEAR over 90 days, with a reference line at the 30-day mean, 88.2 thousand. A. Total supply at each month end, million NEAR The vertical axis starts at 1,200M. 1200 1240 1280 1320 2024-11 2025-05 2025-11 2026-05 2026-11 1,310.833M B. Net issuance per day, thousand NEAR 30-day mean 88.2K 0 40 80 120 Sep 5 Oct 5 Nov 4
Windows (UTC): month ends from 2024-11-30 (Panel A); the 90 days to 2026-11-04 (Panel B).
Net supply growth, 365 days
2.48%
Net issuance, 30-day mean
88.2K NEAR a day
Gross issuance, 90 days
8.0098M NEAR
Burn, 90 days
76.84K NEAR
Notes and sources

NEAR’s supply grew 2.48% over 365 days; net issuance ran at 88.2K NEAR a day over the last 30 days.

What it shows: Total NEAR supply at each month end and day-to-day net issuance (mint minus burn) over the 90 days 2026-08-07 to 2026-11-04; net issuance is the quantity the ladder is measured against.

What it does not show: Who receives the issuance, or what changes after HSP-029, an issuance cut whose on-chain timelock ends on 2026-11-16 by our own sum of the contract’s periods, after the deadline, and which also needs validator adoption.

  • In those 90 days 8.0098M NEAR were minted (read from 297 epoch-boundary block headers), 76.84K NEAR burned and the net supply change was 7.933M NEAR.
  • NEAR mints once per epoch, and a UTC day holds three or four epoch starts, so the daily bars come in two heights: the taller bars are the four-epoch days. Daily values are differences between Nearblocks total_supply values that this repo keeps to the nearest thousand NEAR, so each carries up to about a thousand NEAR of rounding. The ladder uses 88,295 NEAR a day from two archival reads, a slightly different denominator from the 88.2K here.
  • Forward test F2 asks whether the mean net increase over 2026-11-06 to 2026-11-13 is between 86.0K and 89.5K a day; this chart gives context for that test.
  • Panel A’s last point is the as-of date, 2026-11-04.

Source:

Query
Endpoint
GET https://api.nearblocks.io/v1/charts
Fetcher
python3 -m pipeline.fetch_keyless (no key), function fetch_nearblocks()
Series
pipeline/compute.py, series supply_daily in data/series.json
Data

A table wider than the screen scrolls sideways.

Panel A: plotted values
Month end Total supply, million NEAR
2024-11-30 1,222.928
2024-12-31 1,227.94
2025-01-31 1,233.037
2025-02-28 1,237.685
2025-03-31 1,242.781
2025-04-30 1,247.766
2025-05-31 1,253.02
2025-06-30 1,258.06
2025-07-31 1,263.288
2025-08-31 1,268.575
2025-09-30 1,273.704
2025-10-31 1,278.798
2025-11-30 1,281.315
2025-12-31 1,283.94
2026-01-31 1,286.599
2026-02-28 1,288.991
2026-03-31 1,291.661
2026-04-30 1,294.287
2026-05-31 1,297.015
2026-06-30 1,299.639
2026-07-31 1,302.36
2026-08-31 1,305.092
2026-09-30 1,307.742
2026-10-31 1,310.473
2026-11-04 1,310.833
Panel B: plotted values (each day's change from the day before)
Day Total supply, million NEAR Net issuance, thousand NEAR
2026-08-07 1,302.982 82.0
2026-08-08 1,303.062 80.0
2026-08-09 1,303.17 108.0
2026-08-10 1,303.25 80.0
2026-08-11 1,303.331 81.0
2026-08-12 1,303.413 82.0
2026-08-13 1,303.521 108.0
2026-08-14 1,303.601 80.0
2026-08-15 1,303.684 83.0
2026-08-16 1,303.765 81.0
2026-08-17 1,303.872 107.0
2026-08-18 1,303.953 81.0
2026-08-19 1,304.034 81.0
2026-08-20 1,304.141 107.0
2026-08-21 1,304.224 83.0
2026-08-22 1,304.306 82.0
2026-08-23 1,304.387 81.0
2026-08-24 1,304.494 107.0
2026-08-25 1,304.575 81.0
2026-08-26 1,304.655 80.0
2026-08-27 1,304.737 82.0
2026-08-28 1,304.846 109.0
2026-08-29 1,304.927 81.0
2026-08-30 1,305.009 82.0
2026-08-31 1,305.092 83.0
2026-09-01 1,305.201 109.0
2026-09-02 1,305.284 83.0
2026-09-03 1,305.368 84.0
2026-09-04 1,305.451 83.0
2026-09-05 1,305.533 82.0
2026-09-06 1,305.642 109.0
2026-09-07 1,305.724 82.0
2026-09-08 1,305.806 82.0
2026-09-09 1,305.888 82.0
2026-09-10 1,305.969 81.0
2026-09-11 1,306.079 110.0
2026-09-12 1,306.161 82.0
2026-09-13 1,306.243 82.0
2026-09-14 1,306.325 82.0
2026-09-15 1,306.434 109.0
2026-09-16 1,306.516 82.0
2026-09-17 1,306.597 81.0
2026-09-18 1,306.677 80.0
2026-09-19 1,306.785 108.0
2026-09-20 1,306.866 81.0
2026-09-21 1,306.946 80.0
2026-09-22 1,307.055 109.0
2026-09-23 1,307.136 81.0
2026-09-24 1,307.216 80.0
2026-09-25 1,307.295 79.0
2026-09-26 1,307.4 105.0
2026-09-27 1,307.478 78.0
2026-09-28 1,307.582 104.0
2026-09-29 1,307.662 80.0
2026-09-30 1,307.742 80.0
2026-10-01 1,307.821 79.0
2026-10-02 1,307.926 105.0
2026-10-03 1,308.004 78.0
2026-10-04 1,308.108 104.0
2026-10-05 1,308.187 79.0
2026-10-06 1,308.265 78.0
2026-10-07 1,308.37 105.0
2026-10-08 1,308.447 77.0
2026-10-09 1,308.552 105.0
2026-10-10 1,308.629 77.0
2026-10-11 1,308.705 76.0
2026-10-12 1,308.81 105.0
2026-10-13 1,308.888 78.0
2026-10-14 1,308.982 94.0
2026-10-15 1,309.058 76.0
2026-10-16 1,309.164 106.0
2026-10-17 1,309.243 79.0
2026-10-18 1,309.323 80.0
2026-10-19 1,309.429 106.0
2026-10-20 1,309.508 79.0
2026-10-21 1,309.588 80.0
2026-10-22 1,309.693 105.0
2026-10-23 1,309.771 78.0
2026-10-24 1,309.873 102.0
2026-10-25 1,309.95 77.0
2026-10-26 1,310.053 103.0
2026-10-27 1,310.137 84.0
2026-10-28 1,310.214 77.0
2026-10-29 1,310.318 104.0
2026-10-30 1,310.395 77.0
2026-10-31 1,310.473 78.0
2026-11-01 1,310.576 103.0
2026-11-02 1,310.653 77.0
2026-11-03 1,310.755 102.0
2026-11-04 1,310.833 78.0
Figure 15Exploratory#

Supply growth to 2031: 9.4% with HSP-029, 13.1% without

Projected NEAR supply to 2031-11-04, with and without HSP-029's issuance cut Two lines on an axis that does not start at zero: with HSP-029, supply reaches 1,434.09 million; without it, 1,482.79 million. Total supply, million NEAR The vertical axis starts at 1,300M. With HSP-029 (as G_req assumes) Without HSP-029 1300 1350 1400 1450 1500 2026-11 2027-11 2028-11 2029-11 2030-11 2031-11 1,482.79M 1,434.09M
Projected NEAR supply to 2031-11-04, with and without HSP-029's issuance cut Two lines on an axis that does not start at zero: with HSP-029, supply reaches 1,434.09 million; without it, 1,482.79 million. Total supply, million NEAR The vertical axis starts at 1,300M. With HSP-029 (as G_req assumes) Without HSP-029 1300 1350 1400 1450 1500 2026-11 2028-11 2030-11 1,482.79M 1,434.09M
Model: pipeline/model.py (supply_path), from 2026-11-04 to 2031-11-04. Unit: million NEAR.
Notes and sources

NEAR’s supply grows 9.4% by 2031-11-04 if HSP-029 takes effect and 13.1% if not.

What it shows: The supply path the frozen rating rule already uses for G_req (the realised share of the inflation cap and the post-v87 burn rate), run forward day by day, with HSP-029’s ramp to a lower inflation cap and without it. This is the dilution the coverage paths are measured against.

What it does not show: Whether HSP-029 is executed: its timelock ends on 2026-11-16, a Directors’ decision follows, and it needs validator adoption.

  • Supply starts at 1,310.83M NEAR, the archival header at the end of the supply window.
  • The model uses the same arithmetic as pipeline/h1a.py (g_req).

Source:

Query
Model
python3 -m pipeline.compute (pipeline.model.supply_path)
Series
fwd_supply in data/series.json
Data

A table wider than the screen scrolls sideways.

Plotted values, every third model month
Date With HSP-029, million NEAR Without HSP-029, million NEAR
2026-11-04 1,310.83 1,310.83
2027-02-03 1,318.91 1,318.91
2027-05-06 1,326.97 1,327.12
2027-08-05 1,334.62 1,335.29
2027-11-04 1,341.95 1,343.51
2028-02-04 1,349.01 1,351.88
2028-05-05 1,355.66 1,360.21
2028-08-04 1,361.96 1,368.59
2028-11-03 1,367.91 1,377.02
2029-02-03 1,373.56 1,385.60
2029-05-05 1,378.94 1,394.13
2029-08-04 1,384.34 1,402.73
2029-11-04 1,389.82 1,411.46
2030-02-03 1,395.26 1,420.16
2030-05-05 1,400.72 1,428.92
2030-08-05 1,406.27 1,437.82
2030-11-04 1,411.78 1,446.68
2031-02-03 1,417.31 1,455.60
2031-05-06 1,422.92 1,464.67
2031-08-05 1,428.50 1,473.70
2031-11-04 1,434.09 1,482.79

Network usage

Daily active accounts averaged 61.6K over 30 days, -77.1% on a year earlier. 98.5% of that fall is one wallet app’s Telegram accounts, and the number of contracts called each day did not fall.

Figure 16Exploratory#

Daily active accounts: 61.6K, -77.1% on a year earlier; 98.5% of the fall is one wallet app’s Telegram accounts

Daily transactions and daily active accounts on NEAR, from Nearblocks Panel A: a line of daily transactions in thousand, on an axis from zero, over the 400 days from 2025-10-01 to 2026-11-04. It stands at 4,169.8 thousand on 2026-03-31 and 1,063.4 thousand on 2026-04-02, where a dashed vertical line marks the largest one-day fall in the 365 days to 2026-11-04, and at 706.7 thousand on 2026-11-04. Panel B: a line of daily active accounts in thousand over the same days, with the same dashed line. It stands at 139.2 thousand on 2026-03-31, 137.2 thousand on 2026-04-02 and 79.2 thousand on 2026-11-04. A. Transactions per day, thousand 0 1,000 2,000 3,000 4,000 5,000 Oct 2025 Jan 2026 Apr 2026 Jul 2026 Oct 2026 step 2026-04-02 706.7K B. Active accounts per day, thousand 0 200 400 600 Oct 2025 Jan 2026 Apr 2026 Jul 2026 Oct 2026 step 2026-04-02 79.2K
Daily transactions and daily active accounts on NEAR, from Nearblocks Panel A: a line of daily transactions in thousand, on an axis from zero, over the 400 days from 2025-10-01 to 2026-11-04. It stands at 4,169.8 thousand on 2026-03-31 and 1,063.4 thousand on 2026-04-02, where a dashed vertical line marks the largest one-day fall in the 365 days to 2026-11-04, and at 706.7 thousand on 2026-11-04. Panel B: a line of daily active accounts in thousand over the same days, with the same dashed line. It stands at 139.2 thousand on 2026-03-31, 137.2 thousand on 2026-04-02 and 79.2 thousand on 2026-11-04. A. Transactions per day, thousand 0 1,000 2,000 3,000 4,000 5,000 Oct 2025 Apr 2026 Oct 2026 step 2026-04-02 706.7K B. Active accounts per day, thousand 0 200 400 600 Oct 2025 Apr 2026 Oct 2026 step 2026-04-02 79.2K
Window: 2025-10-01 to 2026-11-04 (UTC), one point per day. Unit: thousand a day. The dashed line is 2026-04-02.

Four daily counts, in thousands, on 2026-03-31 and then on 2026-04-02, the day of the fall:

Transactions
4,169.8 → 1,063.4
Active contracts
2,194.2 → 184.6
New accounts
137.1 → 20.7
Active accounts
139.2 → 137.2
Notes and sources

Daily active accounts averaged 61.6K over the 30 days to 2026-11-04, -77.1% on the same 30 days a year earlier; daily transactions are -84.8% on a year earlier, but most of that is one step on 2026-04-02, a single-day drop.

What it shows: Nearblocks’ counts of transactions (Panel A) and of active accounts (Panel B) on each day from 2025-10-01 to 2026-11-04, in thousands. A dashed line marks 2026-04-02, the largest one-day fall in daily transactions in the 365 days to 2026-11-04. The headline averages are the 30 days 2026-10-06 to 2026-11-04 against the same 30 days a year earlier.

What it does not show: Why the step happened. BigQuery (exploratory, docs/usage.md) reproduces both series exactly and shows who stopped: Sweat Economy’s signers, 98.7% of the step. Why they stopped is not in the data. That active accounts are people: this repository applies no sybil or bot filter to the counts. Contract usage: the Nearblocks active-contract count falls by an order of magnitude on the same days (see the table), so it is not used; the BigQuery count of contracts called has a median of 1,449 a day, against 1,461 a year earlier.

  • The transactions series falls in one step, from 4,169.8K to 1,063.4K between 2026-03-31 and 2026-04-02. Active contracts and new accounts fall with it, but active accounts barely move (139.2K to 137.2K): they fall gradually, with spikes this card does not explain, and show no single step. Since the step, the change is -18.9% for daily transactions and -52.1% for daily active accounts (the latest 30 days against the 30 days that start on 2026-04-02).
  • Both counts are lower than a year ago, but they fall differently. This card is not a pre-registered test, and it feeds neither the rating rule nor any pre-registered test.
  • The track brief names daily active accounts, transaction counts and contract usage. The BigQuery queries in sql/usage_*.sql (exploratory, run on 2026-11-13) reproduce the two Nearblocks series on all 395 days they cover, put 98.5% of the fall in active accounts in HOT Wallet’s .tg accounts, and count contracts called; docs/usage.md has the details.
  • The lines are single days and the headline figures 30-day averages, so their last points differ.

Source:

Query

The chart is drawn from the Nearblocks series named at the end of this block. The three BigQuery queries are the ones the track brief asks for (daily active accounts, transaction counts, contract usage). They were run on 2026-11-13, after the freeze (exploratory), and reproduce both Nearblocks series; docs/usage.md has what they found.

sql/usage_daily.sql 1,814 bytes

-- Exploratory (written 2026-11-13, after the freeze). The brief's usage queries: daily transactions, daily
-- active accounts and active contracts, from the NEAR BigQuery public dataset, 2025-10-06..2026-11-04.
-- Per block_date:
--   n_tx                 transactions (every row of `transactions`)
--   n_signers            distinct transaction signers (what a relayer signs counts once, for the relayer)
--   n_signers_implicit   ... of which 64-hex implicit accounts
--   n_receivers          distinct transaction receivers
--   top10_signer_tx      transactions signed by that day's ten most active signers
--   top1_signer          that day's most active signer, and top1_signer_tx its transactions
-- Contract usage and meta-transaction users are in sql/usage_receipts.sql (fewer days: that table is larger).
WITH t AS (
  SELECT block_date AS day, signer_account_id AS s, receiver_account_id AS r
  FROM `bigquery-public-data.crypto_near_mainnet_us.transactions`
  WHERE block_date BETWEEN '2025-10-06' AND '2026-11-04'
),
per_signer AS (
  SELECT day, s, COUNT(*) AS n,
         ROW_NUMBER() OVER (PARTITION BY day ORDER BY COUNT(*) DESC, s) AS rk
  FROM t GROUP BY day, s
),
top AS (
  SELECT day,
         SUM(IF(rk <= 10, n, 0)) AS top10_signer_tx,
         MAX(IF(rk = 1, s, NULL)) AS top1_signer,
         MAX(IF(rk = 1, n, NULL)) AS top1_signer_tx,
         COUNT(*) AS n_signers,
         COUNTIF(REGEXP_CONTAINS(s, r'^[0-9a-f]{64}$')) AS n_signers_implicit
  FROM per_signer GROUP BY day
),
base AS (
  SELECT day, COUNT(*) AS n_tx, COUNT(DISTINCT r) AS n_receivers FROM t GROUP BY day
)
SELECT CAST(b.day AS STRING) AS day, b.n_tx, top.n_signers, top.n_signers_implicit, b.n_receivers,
       top.top10_signer_tx, top.top1_signer, top.top1_signer_tx
FROM base b JOIN top USING (day)
ORDER BY day

sql/usage_receipts.sql 2,231 bytes

-- Exploratory (written 2026-11-13, after the freeze). Contract usage and meta-transaction users, from
-- receipt_actions, on three spans: the 30 days to 2026-11-04, the same 30 days a year earlier, and
-- 2026-03-25..04-08 around the step in Nearblocks' daily transaction count.
-- Per block_date:
--   n_fc_receipts        FUNCTION_CALL actions
--   n_contracts_called   distinct accounts that received a FUNCTION_CALL (active contracts)
--   n_contracts_called_by_tx_signer  ... counting only calls whose predecessor is the transaction signer
--                        (direct calls by a user, not cross-contract calls)
--   n_delegate_actions   DELEGATE_ACTION receipts (meta-transactions sent by a relayer)
--   n_delegate_senders   distinct accounts on whose behalf a relayer sent one (the receipt's receiver)
--   n_users              distinct signers of any action receipt with is_delegate_action false and
--                        predecessor = signer, plus the delegate senders (an upper bound on accounts
--                        that acted that day, relayed or not)
WITH a AS (
  SELECT block_date AS day, action_kind AS k, receipt_receiver_account_id AS r,
         receipt_predecessor_account_id AS p, signer_account_id AS s
  FROM `bigquery-public-data.crypto_near_mainnet_us.receipt_actions`
  WHERE block_date BETWEEN '2026-10-06' AND '2026-11-04'
     OR block_date BETWEEN '2025-10-06' AND '2025-11-04'
     OR block_date BETWEEN '2026-03-25' AND '2026-04-08'
),
users AS (
  SELECT day, s AS u FROM a WHERE p = s AND k != 'DELEGATE_ACTION'
  UNION DISTINCT
  SELECT day, r AS u FROM a WHERE k = 'DELEGATE_ACTION'
),
agg AS (
SELECT day,
       COUNTIF(k = 'FUNCTION_CALL') AS n_fc_receipts,
       COUNT(DISTINCT IF(k = 'FUNCTION_CALL', r, NULL)) AS n_contracts_called,
       COUNT(DISTINCT IF(k = 'FUNCTION_CALL' AND p = s, r, NULL)) AS n_contracts_called_by_tx_signer,
       COUNTIF(k = 'DELEGATE_ACTION') AS n_delegate_actions,
       COUNT(DISTINCT IF(k = 'DELEGATE_ACTION', r, NULL)) AS n_delegate_senders,
FROM a GROUP BY day
),
nu AS (SELECT day, COUNT(*) AS n_users FROM users GROUP BY day)
SELECT CAST(day AS STRING) AS day, agg.* EXCEPT (day), nu.n_users
FROM agg JOIN nu USING (day)
ORDER BY day

sql/usage_signer_groups.sql 1,701 bytes

-- Exploratory (written 2026-11-13, after the freeze). Who the daily transaction signers are, on the 30 days
-- to 2026-11-04, the same 30 days a year earlier, and 2026-03-30..04-03 around the step in the daily
-- transaction count. Signers are grouped by the last label of the account id (`.tg`, `.near`, `.sweat`, ...;
-- 64-hex implicit accounts as `implicit`, 0x-prefixed ones as `eth_implicit`), per day:
--   n_signers   distinct signers in the group, n_tx their transactions.
-- Also, for the five step days, the 15 signers with the most transactions (grp = 'top_signer:<account>').
WITH t AS (
  SELECT block_date AS day, signer_account_id AS s
  FROM `bigquery-public-data.crypto_near_mainnet_us.transactions`
  WHERE block_date BETWEEN '2026-10-06' AND '2026-11-04'
     OR block_date BETWEEN '2025-10-06' AND '2025-11-04'
     OR block_date BETWEEN '2026-03-30' AND '2026-04-03'
),
g AS (
  SELECT day, s,
    CASE WHEN REGEXP_CONTAINS(s, r'^[0-9a-f]{64}$') THEN 'implicit'
         WHEN STARTS_WITH(s, '0x') THEN 'eth_implicit'
         ELSE REGEXP_EXTRACT(s, r'\.([^.]+)$') END AS grp
  FROM t
),
by_group AS (
  SELECT CAST(day AS STRING) AS day, IFNULL(grp, '(no dot)') AS grp,
         COUNT(DISTINCT s) AS n_signers, COUNT(*) AS n_tx
  FROM g GROUP BY day, grp
),
top AS (
  SELECT CAST(day AS STRING) AS day, CONCAT('top_signer:', s) AS grp, 1 AS n_signers, n AS n_tx
  FROM (SELECT day, s, COUNT(*) AS n, ROW_NUMBER() OVER (PARTITION BY day ORDER BY COUNT(*) DESC, s) AS rk
        FROM t WHERE day BETWEEN '2026-03-30' AND '2026-04-03' GROUP BY day, s)
  WHERE rk <= 15
)
SELECT * FROM by_group WHERE n_signers >= 100 OR n_tx >= 10000
UNION ALL SELECT * FROM top
ORDER BY day, grp
Endpoint
GET https://api.nearblocks.io/v1/charts
Fetcher
python3 -m pipeline.fetch_keyless (no key), function fetch_nearblocks()
Step and series
pipeline/compute.py, function l1_usage(): the step day, the four counts on the two days, the change since the step, and series l1_daily in data/series.json
Averages
pipeline/compute.py, function build(): the 30-day averages and the year-on-year changes
Data

A table wider than the screen scrolls sideways.

The step: four daily counts on the two days (the change is computed from the two values shown)
Daily count On 2026-03-31, thousand On 2026-04-02, thousand Change from 2026-03-31 to 2026-04-02, %
Transactions 4,169.8 1,063.4 -74
Active contracts 2,194.2 184.6 -92
New accounts 137.1 20.7 -85
Active accounts 139.2 137.2 -1
Year on year, and since the step
Daily count Average of the latest 30 days, thousand a day Change on the same 30 days a year earlier, % Change on the 30 days that start on 2026-04-02, %
Transactions 685.0 -84.8 -18.9
Active accounts 61.6 -77.1 -52.1
Panels A and B: plotted values, 2025-10-01 to 2026-11-04
Day Transactions per day, thousand Active accounts per day, thousand
2025-10-01 4,632.7 288.2
2025-10-02 4,575.1 291.0
2025-10-03 4,514.4 279.0
2025-10-04 4,457.8 279.2
2025-10-05 4,467.1 285.3
2025-10-06 4,456.3 286.2
2025-10-07 4,612.9 284.8
2025-10-08 4,580.4 279.9
2025-10-09 4,780.0 282.3
2025-10-10 4,793.4 270.1
2025-10-11 4,848.2 271.6
2025-10-12 4,867.4 276.0
2025-10-13 4,767.3 274.1
2025-10-14 4,755.0 277.7
2025-10-15 4,564.8 275.6
2025-10-16 4,786.4 278.2
2025-10-17 4,388.8 273.3
2025-10-18 4,304.9 265.9
2025-10-19 4,379.5 274.6
2025-10-20 4,821.6 273.0
2025-10-21 4,592.5 270.0
2025-10-22 4,441.6 269.3
2025-10-23 4,379.4 266.8
2025-10-24 4,378.3 260.3
2025-10-25 4,307.5 257.7
2025-10-26 4,310.7 265.9
2025-10-27 4,460.2 274.4
2025-10-28 4,472.2 266.4
2025-10-29 4,460.4 269.2
2025-10-30 4,499.9 266.0
2025-10-31 4,325.5 253.9
2025-11-01 4,294.3 250.2
2025-11-02 4,327.6 249.9
2025-11-03 4,323.5 255.6
2025-11-04 4,324.1 250.4
2025-11-05 4,247.1 250.4
2025-11-06 4,068.1 251.0
2025-11-07 4,213.4 247.3
2025-11-08 4,262.1 247.6
2025-11-09 4,156.3 227.0
2025-11-10 4,355.8 264.2
2025-11-11 4,228.8 260.8
2025-11-12 4,337.8 257.1
2025-11-13 4,351.1 255.8
2025-11-14 4,363.3 246.7
2025-11-15 4,328.1 245.5
2025-11-16 4,284.8 246.1
2025-11-17 4,366.9 251.0
2025-11-18 4,266.0 230.7
2025-11-19 4,274.1 248.1
2025-11-20 4,457.1 245.7
2025-11-21 4,286.5 234.4
2025-11-22 4,333.0 233.1
2025-11-23 4,315.4 234.4
2025-11-24 4,222.7 240.2
2025-11-25 4,331.7 242.3
2025-11-26 3,828.0 191.4
2025-11-27 4,332.1 237.4
2025-11-28 4,413.5 230.5
2025-11-29 4,031.8 227.2
2025-11-30 4,107.4 231.1
2025-12-01 4,228.8 234.0
2025-12-02 4,081.7 229.5
2025-12-03 4,105.4 229.1
2025-12-04 4,216.8 235.4
2025-12-05 3,983.4 224.5
2025-12-06 3,861.4 219.2
2025-12-07 3,879.7 227.4
2025-12-08 3,919.1 227.2
2025-12-09 3,969.9 226.9
2025-12-10 3,937.0 221.3
2025-12-11 3,881.3 217.4
2025-12-12 3,748.3 210.9
2025-12-13 3,626.5 208.4
2025-12-14 3,780.2 208.1
2025-12-15 3,843.5 218.8
2025-12-16 3,870.3 220.9
2025-12-17 3,839.7 266.0
2025-12-18 4,026.9 366.7
2025-12-19 3,876.6 229.1
2025-12-20 3,836.8 310.4
2025-12-21 3,725.5 208.2
2025-12-22 3,824.4 265.5
2025-12-23 3,755.6 204.7
2025-12-24 3,760.1 206.2
2025-12-25 3,802.2 203.8
2025-12-26 3,649.0 203.1
2025-12-27 3,645.1 196.3
2025-12-28 3,604.3 203.6
2025-12-29 3,614.0 196.5
2025-12-30 3,608.4 199.5
2025-12-31 3,621.0 194.6
2026-01-01 3,506.6 186.6
2026-01-02 3,593.1 192.0
2026-01-03 3,520.7 190.5
2026-01-04 3,541.4 196.3
2026-01-05 3,647.2 203.5
2026-01-06 3,683.2 197.6
2026-01-07 3,623.5 194.3
2026-01-08 3,718.7 191.2
2026-01-09 3,594.3 182.0
2026-01-10 3,548.6 177.0
2026-01-11 3,412.2 170.3
2026-01-12 3,523.3 177.9
2026-01-13 2,826.8 179.2
2026-01-14 4,277.7 173.9
2026-01-15 3,440.6 168.5
2026-01-16 3,413.4 163.9
2026-01-17 3,392.1 166.5
2026-01-18 3,417.9 170.4
2026-01-19 3,511.4 178.1
2026-01-20 3,577.9 174.7
2026-01-21 3,494.2 170.9
2026-01-22 3,392.6 170.6
2026-01-23 3,372.7 170.5
2026-01-24 3,426.8 167.2
2026-01-25 3,448.6 165.2
2026-01-26 3,485.0 169.9
2026-01-27 3,467.7 174.3
2026-01-28 3,481.0 171.9
2026-01-29 3,430.4 174.6
2026-01-30 3,454.3 167.0
2026-01-31 3,457.2 171.9
2026-02-01 3,410.2 168.0
2026-02-02 3,391.1 172.3
2026-02-03 3,685.2 363.3
2026-02-04 3,595.3 301.6
2026-02-05 3,637.9 266.2
2026-02-06 3,562.7 258.3
2026-02-07 3,447.9 252.6
2026-02-08 3,441.5 251.4
2026-02-09 3,435.6 262.4
2026-02-10 3,534.9 379.7
2026-02-11 3,550.5 380.6
2026-02-12 3,520.0 377.6
2026-02-13 3,596.8 376.5
2026-02-14 3,489.9 333.1
2026-02-15 3,790.9 592.2
2026-02-16 3,568.9 426.1
2026-02-17 3,673.3 542.0
2026-02-18 3,227.7 504.6
2026-02-19 3,270.2 147.0
2026-02-20 3,251.9 143.4
2026-02-21 3,202.2 143.1
2026-02-22 3,249.6 144.9
2026-02-23 3,335.7 155.5
2026-02-24 3,219.7 158.8
2026-02-25 3,793.6 161.2
2026-02-26 3,840.6 156.9
2026-02-27 3,424.9 157.0
2026-02-28 3,532.4 150.9
2026-03-01 3,595.1 138.5
2026-03-02 3,664.5 142.2
2026-03-03 3,336.6 149.2
2026-03-04 3,325.3 151.9
2026-03-05 3,325.4 151.0
2026-03-06 3,306.8 148.9
2026-03-07 3,247.6 146.2
2026-03-08 3,315.5 144.9
2026-03-09 3,351.8 148.5
2026-03-10 3,332.9 150.7
2026-03-11 3,287.7 148.9
2026-03-12 3,335.5 156.1
2026-03-13 3,269.6 146.7
2026-03-14 3,169.6 144.2
2026-03-15 3,178.6 141.4
2026-03-16 3,290.5 146.0
2026-03-17 3,219.2 145.8
2026-03-18 3,237.8 142.2
2026-03-19 3,208.5 143.7
2026-03-20 3,145.2 137.3
2026-03-21 3,114.8 135.6
2026-03-22 3,106.9 137.2
2026-03-23 3,444.7 139.9
2026-03-24 3,891.5 140.1
2026-03-25 4,232.6 141.0
2026-03-26 3,915.2 138.3
2026-03-27 3,618.2 136.9
2026-03-28 4,563.4 133.8
2026-03-29 4,191.7 133.4
2026-03-30 3,464.9 138.6
2026-03-31 4,169.8 139.2
2026-04-01 3,758.7 139.0
2026-04-02 1,063.4 137.2
2026-04-03 907.9 131.9
2026-04-04 908.6 130.6
2026-04-05 896.3 129.2
2026-04-06 959.5 134.0
2026-04-07 957.2 132.2
2026-04-08 971.4 134.0
2026-04-09 972.9 133.1
2026-04-10 992.7 132.7
2026-04-11 960.7 131.8
2026-04-12 992.1 131.3
2026-04-13 895.9 139.2
2026-04-14 785.1 127.4
2026-04-15 763.1 133.3
2026-04-16 1,058.8 133.7
2026-04-17 729.4 131.0
2026-04-18 763.8 129.0
2026-04-19 803.0 127.5
2026-04-20 808.5 130.0
2026-04-21 805.1 129.7
2026-04-22 779.0 130.0
2026-04-23 752.0 126.2
2026-04-24 687.0 122.0
2026-04-25 622.1 122.4
2026-04-26 722.4 118.6
2026-04-27 713.2 124.4
2026-04-28 709.5 120.9
2026-04-29 932.6 123.2
2026-04-30 726.8 119.5
2026-05-01 704.4 119.1
2026-05-02 695.1 128.4
2026-05-03 726.6 126.4
2026-05-04 768.4 129.1
2026-05-05 761.1 133.2
2026-05-06 847.9 128.1
2026-05-07 783.7 124.9
2026-05-08 761.3 124.0
2026-05-09 740.5 120.3
2026-05-10 757.3 120.0
2026-05-11 757.8 124.8
2026-05-12 788.6 123.9
2026-05-13 790.5 122.4
2026-05-14 786.0 120.5
2026-05-15 751.4 107.0
2026-05-16 722.2 111.5
2026-05-17 726.9 116.0
2026-05-18 787.3 118.1
2026-05-19 779.1 118.6
2026-05-20 817.2 120.0
2026-05-21 836.8 116.3
2026-05-22 1,109.1 125.2
2026-05-23 879.6 122.6
2026-05-24 898.9 122.8
2026-05-25 898.7 126.1
2026-05-26 957.3 124.4
2026-05-27 831.6 118.2
2026-05-28 825.6 115.2
2026-05-29 864.4 115.8
2026-05-30 776.2 112.7
2026-05-31 761.4 113.6
2026-06-01 883.0 118.0
2026-06-02 971.9 118.4
2026-06-03 987.1 121.1
2026-06-04 1,020.6 119.0
2026-06-05 1,055.5 115.8
2026-06-06 830.4 111.3
2026-06-07 845.4 111.9
2026-06-08 876.6 123.8
2026-06-09 804.5 112.3
2026-06-10 804.2 114.6
2026-06-11 804.7 112.2
2026-06-12 789.3 111.9
2026-06-13 734.1 110.1
2026-06-14 756.8 110.0
2026-06-15 851.0 117.9
2026-06-16 804.2 114.1
2026-06-17 823.2 115.8
2026-06-18 801.7 111.5
2026-06-19 812.7 110.3
2026-06-20 719.9 106.4
2026-06-21 722.4 109.1
2026-06-22 757.3 112.0
2026-06-23 757.8 113.0
2026-06-24 768.2 110.3
2026-06-25 743.1 109.7
2026-06-26 736.1 106.4
2026-06-27 697.9 106.1
2026-06-28 711.4 105.9
2026-06-29 797.0 108.8
2026-06-30 747.0 107.7
2026-07-01 720.9 104.1
2026-07-02 747.9 105.8
2026-07-03 739.0 104.5
2026-07-04 753.8 103.8
2026-07-05 738.0 106.2
2026-07-06 796.7 106.8
2026-07-07 819.3 105.2
2026-07-08 873.7 105.2
2026-07-09 823.4 102.6
2026-07-10 770.8 102.4
2026-07-11 715.5 90.2
2026-07-12 694.1 89.9
2026-07-13 794.9 91.9
2026-07-14 757.9 92.4
2026-07-15 725.1 90.9
2026-07-16 724.9 89.0
2026-07-17 711.9 88.6
2026-07-18 672.5 87.0
2026-07-19 664.3 85.9
2026-07-20 755.0 88.7
2026-07-21 737.9 89.9
2026-07-22 718.5 89.7
2026-07-23 732.9 88.8
2026-07-24 712.6 85.3
2026-07-25 719.0 86.1
2026-07-26 706.8 85.7
2026-07-27 698.0 87.1
2026-07-28 703.2 86.4
2026-07-29 705.0 86.4
2026-07-30 733.3 85.5
2026-07-31 708.1 82.1
2026-08-01 681.8 82.2
2026-08-02 671.1 81.7
2026-08-03 690.7 85.2
2026-08-04 696.6 85.6
2026-08-05 671.6 84.1
2026-08-06 675.3 84.2
2026-08-07 656.1 82.3
2026-08-08 656.2 78.5
2026-08-09 637.9 80.4
2026-08-10 672.0 82.6
2026-08-11 660.2 82.8
2026-08-12 685.4 82.2
2026-08-13 664.8 82.6
2026-08-14 639.7 79.8
2026-08-15 584.7 79.8
2026-08-16 615.2 80.2
2026-08-17 669.2 80.6
2026-08-18 673.8 80.1
2026-08-19 733.4 80.9
2026-08-20 758.8 82.2
2026-08-21 786.1 81.7
2026-08-22 804.7 79.6
2026-08-23 726.2 79.4
2026-08-24 805.7 81.4
2026-08-25 719.6 79.5
2026-08-26 655.3 81.5
2026-08-27 681.3 81.5
2026-08-28 654.9 78.4
2026-08-29 594.1 76.9
2026-08-30 623.9 77.0
2026-08-31 684.9 77.8
2026-09-01 670.5 77.1
2026-09-02 659.6 77.1
2026-09-03 703.7 77.6
2026-09-04 735.5 76.0
2026-09-05 674.2 74.3
2026-09-06 763.2 74.7
2026-09-07 746.0 75.7
2026-09-08 704.3 71.8
2026-09-09 772.8 72.0
2026-09-10 728.7 71.2
2026-09-11 846.6 70.0
2026-09-12 652.0 67.2
2026-09-13 626.4 61.5
2026-09-14 706.6 50.0
2026-09-15 706.6 45.2
2026-09-16 777.1 42.5
2026-09-17 840.3 44.7
2026-09-18 973.4 63.0
2026-09-19 839.4 52.4
2026-09-20 846.0 57.5
2026-09-21 871.7 60.3
2026-09-22 972.0 57.8
2026-09-23 869.9 56.1
2026-09-24 741.3 54.0
2026-09-25 715.5 57.3
2026-09-26 603.1 54.1
2026-09-27 1,217.2 63.6
2026-09-28 1,129.8 61.8
2026-09-29 987.6 63.0
2026-09-30 923.5 58.7
2026-10-01 1,151.5 62.1
2026-10-02 868.0 118.1
2026-10-03 690.4 176.7
2026-10-04 839.5 177.2
2026-10-05 865.7 96.0
2026-10-06 909.8 124.8
2026-10-07 971.1 175.8
2026-10-08 1,014.9 82.4
2026-10-09 680.3 54.0
2026-10-10 850.3 56.9
2026-10-11 1,109.6 54.9
2026-10-12 712.6 59.2
2026-10-13 731.1 55.7
2026-10-14 767.8 58.6
2026-10-15 912.0 55.5
2026-10-16 658.4 54.9
2026-10-17 557.9 54.3
2026-10-18 569.7 51.8
2026-10-19 607.0 53.1
2026-10-20 618.0 52.1
2026-10-21 658.8 53.9
2026-10-22 547.3 51.4
2026-10-23 609.2 51.2
2026-10-24 635.4 50.2
2026-10-25 550.2 49.2
2026-10-26 573.8 49.6
2026-10-27 604.3 61.9
2026-10-28 520.1 49.3
2026-10-29 649.1 49.3
2026-10-30 691.4 47.3
2026-10-31 502.6 46.0
2026-11-01 509.3 46.5
2026-11-02 522.4 48.1
2026-11-03 597.2 72.3
2026-11-04 706.7 79.2

Track record: what we predicted, and what happened

We fixed three hypotheses, a rating rule and seven dated forecasts in the pre-registration before the first BigQuery result the repository records, so that the numbers could not be bent to fit a story afterwards. One hypothesis went against us: net staking outflow was 6.56× staking rewards, where we predicted under 0.5×. Two could not be settled, because only 20.0% of the top-100 receivers carry an exchange label, so the frozen rule gives no signal. Of the four one-week forecasts, 2 came true and 2 did not. Everything in this tab is pre-registered except the list headed “What the results changed”; later method choices are dated in the addendum.

The questions and the pre-registered answer

The pre-registered question: how much NEAR actually flows to exchanges, and how much of that do identified buyers absorb? (It makes no claim about which coins are sold.) The question the evidence can answer: how much of NEAR’s value capture can be verified?

What the pre-registered tests found: net staking outflow was 6.56× staking rewards over 90 days, where H1a (most staking rewards stay staked) predicted under 0.5×. Only 20.0% of the top-100 NEAR receivers carry an exchange label, so how much NEAR reaches exchanges (H1b: less than is minted) and how much of it identified buyers absorb (H1c: at least 25%) come out as ranges too wide to settle either way. So the frozen rating rule gives no buy or avoid signal, which carries no view on NEAR.

Exploratory, chosen after the freeze: over 30 days the NEAR that verifiably reached NEAR’s three Intents revenue wallets was 15.81% of net issuance, of which 4.53 points trace to public fee collectors, 11.25 arrived as releases from an escrow whose fee stream is unattested, and 0.03 came from one other source. So, if those three are all of NEAR’s Intents revenue wallets, the value capture that can be verified is a range. This is not a valuation and not advice. See the value-capture ladder.

Scorecard

  • H1a: most staking rewards stay staked

    6.56×

    Net staking outflow ÷ staking rewards over 90 days. H1a predicted under 0.5×.

    Figure 17
  • H1b: less NEAR reaches exchanges than is minted

    4.42M to 152.45M

    NEAR net into exchanges, against 8.0098M minted. Labels cover 20.0%; a point result needs 50%.

    Figure 18
  • H1c: identified buyers absorb a larger share

    33.48% and 0.97%

    Identified buying ÷ net exchange inflow at the lower and upper bound. H1c needs at least 25% at both bounds.

    Figure 19
  • Rating: the frozen rule

    No signal

    Revenue growth 619.0% a year against 33.2% required, but a buy also needs H1b confirmed, which the labels cannot settle. No view on NEAR.

    Figure 20
  • Forward tests F1 to F4

    2 came true, 2 did not

    0 could not be scored. Every result is published.

    Figure 21
When the tests were frozen

Frozen at commit 413d776 (2026-11-05 22:53:29 UTC), about two minutes before the first BigQuery result the repository records (2026-11-05 22:55:37 UTC in data/MANIFEST.json). Commit and manifest times are written by the author’s machine; one external record, GitHub’s activity log, dates the push of the freeze commit to 2026-11-05 22:53:33 UTC (PREREG-ADDENDUM.md, 2026-11-12 23:50 UTC entry, item 2). BigQuery job IDs, which embed their creation time, are recorded only for the H1b and H1c runs and one October escrow scan; the H1a queries have none. The table “What we had already seen” in PREREG.md lists the data already in hand at the freeze.

What the results changed

Our reading, written after the score (exploratory). The headline figures on the first screen already include the week the forecasts covered: they run to 2026-11-13.

  • Where we were right. The buyback wallet kept filling and net new supply ran at the pace we forecast (F1, F2). The case sets those two against each other.
  • Where we were wrong in NEAR’s favour. We expected NEAR’s take to fall back below 4.0 bp, and it did not (F3). The headline figures use the measured 4.23 bp.
  • Where we were wrong against it. We expected Intents to keep over half its peer set’s volume, and THORChain out-traded it (F4). The 30-day share is 45.8% in the update.
  • Supply. More NEAR left staking than rewards added (H1a): the NEAR outside the pools grew by 6.1× the net new supply. Whether it was sold, H1b leaves open.
  • Still open. Labels cover too few exchange addresses to settle H1b and H1c, so the frozen rule gives no signal and the view rests on the investment case.
  • Our odds. We gave the four one-week forecasts odds of 0.65 to 0.75, and two came true. Four is too few to re-fit, so the longer-dated odds stay as frozen.
Figure 17Pre-registered#

Net staking outflow: 6.56× staking rewards (H1a predicted under 0.5×)

Net staking outflow against staking rewards, 90 days Panel A, bars from zero in million NEAR: withdrawals 235.3, deposits 188.0, net outflow 47.3, staking rewards 7.2088. Panel B, lines: cumulative net outflow ends at 47.3 and cumulative rewards credited to pools at 7.04. A. 90-day totals, million NEAR 0 50 100 150 200 250 Withdrawals from staking pools by delegators Withdrawals: 235.3M NEAR 235.3M Deposits into staking pools by delegators Deposits: 188.0M NEAR 188.0M Net staking outflow (withdrawals minus deposits) Net outflow: 47.3M NEAR 47.3M Staking rewards (the pre-registered denominator) Staking rewards: 7.2088M NEAR 7.2088M H1a’s line: net outflow below 3.60M B. Running total since the first day, million NEAR (below zero: more went into the pools than out) Net outflow from pools (withdrawals minus deposits) Rewards credited to pools -25 0 25 50 75 100 Aug 7 Sep 6 Oct 6 Nov 4 47.3M 7.04M
Net staking outflow against staking rewards, 90 days Panel A, bars from zero in million NEAR: withdrawals 235.3, deposits 188.0, net outflow 47.3, staking rewards 7.2088. Panel B, lines: cumulative net outflow ends at 47.3 and cumulative rewards credited to pools at 7.04. A. 90-day totals, million NEAR 0 50 100 150 200 250 Withdrawals from staking pools by delegators Withdrawals: 235.3M NEAR 235.3M Deposits into staking pools by delegators Deposits: 188.0M NEAR 188.0M Net staking outflow (withdrawals minus deposits) Net outflow: 47.3M NEAR 47.3M Staking rewards (the pre-registered denominator) Staking rewards: 7.2088M NEAR 7.2088M H1a’s line: net outflow below 3.60M B. Running total since the first day, million NEAR (below zero: more went into the pools than out) Net outflow from pools (withdrawals minus deposits) Rewards credited to pools -25 0 25 50 75 100 Aug 7 Sep 6 Oct 6 Nov 4 47.3M 7.04M
Window: 90 days, 2026-08-07 to 2026-11-04 (UTC). Unit: million NEAR.
Net outflow ÷ staking rewards
6.56×
H1a predicted
under 0.5×
Same ratio, archival pool state
6.56×
Notes and sources

Net staking outflow was 6.56× staking rewards over 90 days, where H1a predicted under 0.5×.

What it shows: Over the 90 days 2026-08-07 to 2026-11-04, delegators withdrew 235.3M NEAR from staking pools and deposited 188.0M, a net outflow of 47.3M NEAR against 7.2088M NEAR of staking rewards (90% of the 8.0098M NEAR minted).

What it does not show: Whether rewards themselves stay staked: the ratio nets large principal flows in both directions, so it measures net principal churn. Nor who withdrew or where the NEAR went: NEAR is fungible, so nothing here says which coins were sold, and whether the NEAR reached exchanges is H1b, which the exchange labels cannot settle.

  • The 8.0098M NEAR minted is read from 297 epoch-boundary block headers. Panel B uses the 7.04M NEAR of rewards credited to pools in the daily series, so on that denominator the ratio is 6.71×; the pre-registered ratio is 6.56×.
  • With lst-pool.near, the only validator the pool-name filter misses in the validator sets sampled, added (post hoc; the test is not redefined), the ratio is 5.96×, still far over H1a’s line.

Source:

Query

sql/staking_flows_daily.sql 1,876 bytes

-- Daily NEAR flows into and out of staking pools, from account_changes (balances, not call args).
-- A pool's total = staked + nonstaked balance. Each change is attributed by update_reason:
--   validator_accounts_update  -> epoch staking rewards credited to the pool
--   action_receipt_gas_reward  -> 30% gas rebate to the pool contract (removed at protocol v87)
--   receipt_processing         -> deposits in minus withdrawals out (delegator flows) and the pool's own gas
-- Pools: *.poolv1.near and *.pool.near. Liquid-staking contracts (meta-pool.near, linear-protocol.near)
-- are excluded because they stake through these pools; including them would double count.
-- Window: 2026-08-07 .. 2026-11-04 (90 days, PREREG H1a); 2026-08-06 seeds the first delta.
WITH ch AS (
  SELECT block_date, affected_account_id AS acct, block_height, index_in_block, update_reason,
         (affected_account_staked_balance + affected_account_nonstaked_balance) / 1e24 AS total
  FROM `bigquery-public-data.crypto_near_mainnet_us.account_changes`
  WHERE block_date BETWEEN '2026-08-06' AND '2026-11-04'
    AND (affected_account_id LIKE '%.poolv1.near' OR affected_account_id LIKE '%.pool.near')
),
d AS (
  SELECT *, total - LAG(total) OVER (PARTITION BY acct ORDER BY block_height, index_in_block) AS delta
  FROM ch
)
SELECT block_date,
       ROUND(SUM(IF(update_reason = 'validator_accounts_update', delta, 0)), 3) AS rewards_near,
       ROUND(SUM(IF(update_reason = 'action_receipt_gas_reward', delta, 0)), 3) AS gas_rebate_near,
       ROUND(SUM(IF(update_reason = 'receipt_processing' AND delta > 0, delta, 0)), 3) AS inflow_near,
       ROUND(SUM(IF(update_reason = 'receipt_processing' AND delta < 0, -delta, 0)), 3) AS outflow_near,
       COUNT(DISTINCT acct) AS pools
FROM d
WHERE block_date >= '2026-08-07' AND delta IS NOT NULL
GROUP BY block_date
ORDER BY block_date

sql/staking_pool_totals_endpoints.sql 1,049 bytes

-- Sanity check for staking_flows_daily: total NEAR held by staking pools at the end of
-- 2026-08-06 and of 2026-11-04 (last balance change of each pool on that day).
-- Expected: end - start = rewards + gas rebate + inflow - outflow from staking_flows_daily.
WITH last_state AS (
  SELECT block_date, affected_account_id AS acct,
         (affected_account_staked_balance + affected_account_nonstaked_balance) / 1e24 AS total,
         affected_account_staked_balance / 1e24 AS staked,
         ROW_NUMBER() OVER (PARTITION BY block_date, affected_account_id
                            ORDER BY block_height DESC, index_in_block DESC) AS rn
  FROM `bigquery-public-data.crypto_near_mainnet_us.account_changes`
  WHERE block_date IN ('2026-08-06', '2026-11-04')
    AND (affected_account_id LIKE '%.poolv1.near' OR affected_account_id LIKE '%.pool.near')
)
SELECT block_date, COUNT(*) AS pools, ROUND(SUM(total), 0) AS pool_total_near, ROUND(SUM(staked), 0) AS pool_staked_near
FROM last_state WHERE rn = 1
GROUP BY block_date ORDER BY block_date
Data

A table wider than the screen scrolls sideways.

Panel A: 90-day totals in million NEAR
Panel A bar Million NEAR
Withdrawals from staking pools 235.3
Deposits into staking pools 188.0
Net staking outflow 47.3
Staking rewards (90% of gross issuance) 7.2088
H1a’s line (0.5 x staking rewards) 3.60
Daily pool flows in NEAR (Panel B), 2026-08-07 to 2026-11-04
Day Withdrawals Deposits Net outflow Rewards credited Cumulative net outflow Cumulative rewards
2026-08-07 777,676 2,008,465 -1,230,789 73,611 -1,230,789 73,611
2026-08-08 524,098 649,853 -125,754 72,653 -1,356,543 146,265
2026-08-09 394,732 480,840 -86,108 93,356 -1,442,651 239,621
2026-08-10 1,341,527 6,578,209 -5,236,682 73,088 -6,679,333 312,708
2026-08-11 347,659 842,898 -495,238 73,409 -7,174,571 386,117
2026-08-12 275,744 713,268 -437,524 73,225 -7,612,095 459,343
2026-08-13 1,126,459 1,148,997 -22,538 92,953 -7,634,633 552,296
2026-08-14 1,506,104 609,696 896,408 72,449 -6,738,225 624,745
2026-08-15 374,650 300,838 73,812 74,490 -6,664,413 699,236
2026-08-16 297,772 562,067 -264,295 66,752 -6,928,707 765,988
2026-08-17 330,479 433,340 -102,860 97,188 -7,031,567 863,176
2026-08-18 334,874 1,510,869 -1,175,995 73,423 -8,207,563 936,599
2026-08-19 133,136 236,976 -103,839 69,983 -8,311,402 1,006,582
2026-08-20 186,768 849,401 -662,633 94,160 -8,974,035 1,100,742
2026-08-21 679,397 1,063,028 -383,631 74,429 -9,357,666 1,175,170
2026-08-22 1,035,386 541,876 493,510 74,264 -8,864,156 1,249,434
2026-08-23 721,421 771,533 -50,112 72,954 -8,914,268 1,322,388
2026-08-24 700,093 1,086,493 -386,400 96,943 -9,300,668 1,419,331
2026-08-25 668,641 640,688 27,953 72,833 -9,272,715 1,492,164
2026-08-26 251,737 545,753 -294,016 66,234 -9,566,731 1,558,399
2026-08-27 615,861 1,134,898 -519,036 73,727 -10,085,767 1,632,126
2026-08-28 246,741 454,502 -207,761 97,823 -10,293,528 1,729,949
2026-08-29 711,873 679,966 31,907 70,272 -10,261,621 1,800,221
2026-08-30 432,402 244,541 187,861 74,053 -10,073,760 1,874,274
2026-08-31 400,046 2,599,526 -2,199,480 73,814 -12,273,239 1,948,088
2026-09-01 2,179,701 985,559 1,194,142 94,851 -11,079,098 2,042,939
2026-09-02 458,454 1,290,239 -831,785 74,475 -11,910,883 2,117,413
2026-09-03 484,454 449,238 35,216 75,317 -11,875,667 2,192,730
2026-09-04 1,148,772 322,425 826,347 74,633 -11,049,320 2,267,363
2026-09-05 1,103,055 478,503 624,551 72,371 -10,424,769 2,339,734
2026-09-06 947,056 1,216,761 -269,705 98,453 -10,694,473 2,438,187
2026-09-07 1,272,964 984,511 288,453 74,046 -10,406,020 2,512,233
2026-09-08 3,060,403 2,126,860 933,543 70,886 -9,472,478 2,583,119
2026-09-09 38,481,618 973,572 37,508,046 73,913 28,035,569 2,657,032
2026-09-10 597,955 584,446 13,508 73,511 28,049,077 2,730,543
2026-09-11 2,223,957 836,515 1,387,442 99,006 29,436,519 2,829,549
2026-09-12 900,715 3,221,483 -2,320,768 70,082 27,115,751 2,899,631
2026-09-13 844,412 882,506 -38,094 73,654 27,077,657 2,973,284
2026-09-14 3,393,466 3,089,523 303,943 73,315 27,381,600 3,046,599
2026-09-15 505,140 599,683 -94,544 98,129 27,287,057 3,144,728
2026-09-16 21,112,987 3,555,871 17,557,116 69,335 44,844,173 3,214,063
2026-09-17 2,573,863 2,008,025 565,838 68,937 45,410,010 3,283,000
2026-09-18 2,407,650 681,738 1,725,912 72,549 47,135,922 3,355,550
2026-09-19 4,476,952 1,184,838 3,292,114 96,387 50,428,036 3,451,937
2026-09-20 2,855,631 670,037 2,185,594 67,666 52,613,630 3,519,603
2026-09-21 4,443,489 1,390,823 3,052,667 72,499 55,666,297 3,592,102
2026-09-22 4,468,455 2,401,703 2,066,752 96,361 57,733,049 3,688,463
2026-09-23 8,940,126 1,655,350 7,284,775 61,139 65,017,824 3,749,603
2026-09-24 1,348,084 1,651,468 -303,383 72,140 64,714,441 3,821,743
2026-09-25 2,463,829 1,002,819 1,461,010 71,351 66,175,451 3,893,094
2026-09-26 1,884,106 663,169 1,220,937 94,346 67,396,388 3,987,440
2026-09-27 1,800,096 554,249 1,245,847 70,716 68,642,235 4,058,157
2026-09-28 13,064,514 1,679,693 11,384,821 94,566 80,027,057 4,152,723
2026-09-29 1,221,686 3,633,340 -2,411,654 71,554 77,615,403 4,224,277
2026-09-30 8,539,421 4,328,412 4,211,009 71,688 81,826,411 4,295,965
2026-10-01 1,918,570 10,272,156 -8,353,585 72,435 73,472,826 4,368,401
2026-10-02 2,943,582 2,998,637 -55,055 92,661 73,417,771 4,461,061
2026-10-03 1,789,496 805,186 984,310 70,146 74,402,081 4,531,208
2026-10-04 9,763,345 414,784 9,348,561 93,610 83,750,642 4,624,817
2026-10-05 1,815,441 1,120,343 695,098 70,336 84,445,740 4,695,153
2026-10-06 398,617 1,244,857 -846,241 70,278 83,599,499 4,765,431
2026-10-07 1,557,098 12,280,061 -10,722,962 94,288 72,876,537 4,859,719
2026-10-08 1,382,899 1,757,639 -374,740 70,430 72,501,797 4,930,148
2026-10-09 2,165,059 3,140,506 -975,447 93,373 71,526,350 5,023,521
2026-10-10 1,740,465 1,014,019 726,446 63,380 72,252,795 5,086,901
2026-10-11 407,853 838,581 -430,729 69,043 71,822,067 5,155,944
2026-10-12 1,303,358 470,204 833,154 94,250 72,655,220 5,250,194
2026-10-13 1,068,108 40,615,339 -39,547,231 70,633 33,107,989 5,320,827
2026-10-14 1,488,082 1,404,771 83,311 84,282 33,191,300 5,405,109
2026-10-15 1,359,143 1,566,493 -207,350 67,683 32,983,950 5,472,792
2026-10-16 2,289,583 3,737,957 -1,448,374 95,184 31,535,576 5,567,976
2026-10-17 1,237,699 896,361 341,338 68,545 31,876,914 5,636,520
2026-10-18 1,905,068 2,165,443 -260,375 71,261 31,616,539 5,707,781
2026-10-19 2,364,835 2,794,320 -429,485 95,123 31,187,054 5,802,904
2026-10-20 1,418,672 2,074,425 -655,753 71,689 30,531,301 5,874,593
2026-10-21 5,611,464 2,358,357 3,253,108 67,644 33,784,409 5,942,238
2026-10-22 1,056,393 537,556 518,838 94,201 34,303,246 6,036,438
2026-10-23 7,485,430 2,725,630 4,759,799 69,955 39,063,046 6,106,393
2026-10-24 585,206 1,396,901 -811,695 90,038 38,251,351 6,196,432
2026-10-25 1,805,298 632,082 1,173,216 69,268 39,424,567 6,265,700
2026-10-26 601,939 1,822,973 -1,221,034 89,134 38,203,533 6,354,834
2026-10-27 1,835,436 1,288,686 546,750 73,894 38,750,282 6,428,728
2026-10-28 1,474,493 651,170 823,323 65,923 39,573,605 6,494,651
2026-10-29 1,065,888 6,687,651 -5,621,764 93,132 33,951,841 6,587,783
2026-10-30 1,330,385 1,215,287 115,098 69,039 34,066,940 6,656,822
2026-10-31 579,257 643,102 -63,845 65,957 34,003,095 6,722,779
2026-11-01 2,291,812 188,351 2,103,461 92,353 36,106,556 6,815,132
2026-11-02 7,096,196 2,707,464 4,388,732 69,247 40,495,288 6,884,379
2026-11-03 846,020 582,093 263,927 85,931 40,759,215 6,970,310
2026-11-04 7,670,744 1,172,857 6,497,887 67,596 47,257,102 7,037,906
Figure 18Pre-registered#

Net exchange inflow: 4.42M to 152.45M NEAR (8.0098M minted)

Net exchange inflow as a range, and how much of the top 100 is labelled Panel A, bars from zero in million NEAR: lower bound 4.42, upper bound 152.45, tier 1 only 3.31, upper bound without sourced non-exchange accounts 190.71; a reference line marks gross issuance 8.0098. Panel B, bars from zero in percent: label coverage 20.0 against the required 50. A. Net exchange inflow, 90 days, million NEAR 0 50 100 150 200 Lower bound: unlabelled receivers count as 0% exchange-bound Lower bound: 4.42M NEAR 4.42M Upper bound: every unlabelled top-100 receiver counts as exchange-bound Upper bound: 152.45M NEAR 152.45M Side measure: cited tier-1 accounts only Tier 1 only: 3.31M NEAR 3.31M Side measure: upper bound without sourced non-exchange accounts Upper bound ex non-exchange: 190.71M NEAR 190.71M gross issuance 8.0098M (the H1b bar) B. Labelled share of the top-100 native-NEAR receivers, % 0% 25% 50% 75% 100% Tiers 1-3 by count (the pre-registered measure) Coverage by count: 20.0% 20.0% Tier 1 only, by count Tier 1 by count: 10.0% 10.0% Tiers 1-3, weighted by inflow Coverage by inflow: 24.6% 24.6% required for a point result: 50%
Net exchange inflow as a range, and how much of the top 100 is labelled Panel A, bars from zero in million NEAR: lower bound 4.42, upper bound 152.45, tier 1 only 3.31, upper bound without sourced non-exchange accounts 190.71; a reference line marks gross issuance 8.0098. Panel B, bars from zero in percent: label coverage 20.0 against the required 50. A. Net exchange inflow, 90 days, million NEAR 0 50 100 150 200 Lower bound: unlabelled receivers count as 0% exchange-bound Lower bound: 4.42M NEAR 4.42M Upper bound: every unlabelled top-100 receiver counts as exchange-bound Upper bound: 152.45M NEAR 152.45M Side measure: cited tier-1 accounts only Tier 1 only: 3.31M NEAR 3.31M Side measure: upper bound without sourced non-exchange accounts Upper bound ex non-exchange: 190.71M NEAR 190.71M gross issuance 8.0098M (the H1b bar) B. Labelled share of the top-100 native-NEAR receivers, % 0% 25% 50% 75% 100% Tiers 1-3 by count (the pre-registered measure) Coverage by count: 20.0% 20.0% Tier 1 only, by count Tier 1 by count: 10.0% 10.0% Tiers 1-3, weighted by inflow Coverage by inflow: 24.6% 24.6% required for a point result: 50%
Window: 90 days, 2026-08-07 to 2026-11-04 (UTC).
Notes and sources

Net exchange inflow lies between 4.42M and 152.45M NEAR, on either side of the 8.0098M NEAR minted, so the exchange labels cannot settle H1b.

What it shows: Net exchange inflow of NEAR (native plus wNEAR) into labelled exchange accounts over the 90 days 2026-08-07 to 2026-11-04, as a range: 4.42M NEAR if unlabelled receivers are not exchange-bound, 152.45M NEAR if every unlabelled top-100 receiver is.

What it does not show: That any of this NEAR was sold, or by whom (NEAR is fungible): it counts only labelled centralized-exchange accounts, so 1Click, a non-custodial route out of NEAR, is reported beside H1b and never inside it.

  • Only 20.0% of the top-100 native-NEAR receivers carry an exchange label (10.0% a cited one; the rest are labelled by our sweep rule), below the 50% the pre-registration requires, so H1b is confirmed only if it is true at both bounds. The lower bound is under gross issuance and the upper bound is far over it, so the labels cannot settle it.
  • The upper bound is mechanical: it treats every unlabelled top-100 receiver as an exchange, including accounts that are probably not.
  • The fourth bar of Panel A (190.71M) is longer than the upper bound (152.45M) although it leaves two accounts out: it is a side measure and does not tighten the bound. It drops the transfers between the sourced non-exchange accounts among the unlabelled top-100 receivers (here intents.near and a DAO account) and accounts outside the set, which is how pipeline/h1b.py approximates taking them out of the set counted as exchange-bound. More NEAR left the set through those transfers than entered it, so dropping them raises the total. The test uses only the lower and upper bounds.
  • Labels are snapshots dated 2026-11-06, so exchange addresses retired before then may be missing, which biases the lower bound down. No citable NEAR address was found for OKX, Coinbase, Kraken, Bybit, HTX, Crypto.com, Upbit or Bithumb.

Source:

Query

sql/h1b_a_native_flows.sql 13,184 bytes

The header comment of this file says “NOT run” because it was written before the run. The run record is the 2026-11-06 23:23 UTC entry of PREREG-ADDENDUM.md.

-- a_h1b_native_flows.sql  (lane h1b-exchange, phase 1a: written and dry-run only, NOT run)
-- PREREG H1b/H1c, native-NEAR leg, plus the top-100 receivers needed for labelled coverage.
-- ONE scan of receipt_actions serves every native leg: labelled flows, coverage list, the amount-based
-- sweep clustering (rules D1-D5, H1-H2 below) and the upper-bound set. CTE `t` is referenced several
-- times; BigQuery bills the referenced columns once (verified by dry run, see dryrun.md).
--
-- WINDOW (edit here only; literal dates because pipeline/bq_run.py passes raw SQL, no --parameter):
--   block_date BETWEEN '2026-08-07' AND '2026-11-04'   (90 days, PREREG "Hypotheses on flows")
--
-- Transfers: action_kind = 'TRANSFER', predecessor != 'system' (gas refunds and refunds of failed
-- transfers), self-transfers dropped. Amount = args.deposit (yocto -> NEAR). Clustering and the top-100
-- use TRANSFER only (same convention as sql/spike_top_receivers_7d.sql).
-- Side component, same bytes (args and action_kind are already read): FUNCTION_CALL attached deposits
-- (> 0) crossing a set boundary, reported with kind = 'fcall_deposit' and NOT mixed into kind =
-- 'transfer'. Reason: an exchange restaking via deposit_and_stake is a FunctionCall (invisible to the
-- transfer leg) while the matching pool withdrawal arrives as a Transfer (visible), which would bias
-- net inflow upward. Every flow row also carries cp = counterparty class (pool | intents | wrap | other);
-- cp=wrap marks near_deposit wraps (NEAR -> wNEAR at wrap.near), which are a change of form, not an exit.
--
-- Labelled sets, nested; every rule is fixed here before the query runs:
--   tier 1  named accounts from exchange_accounts.json (cited; generated block below).
--   tier 2  deposit-like accounts whose sweep destination is a tier-1 account. Deposit-like (D1-D5):
--           D1 inflow >= 1 NEAR; D2 0.9 <= outflow/inflow <= 1.5; D3 top destination >= 90% of outflow;
--           D4 <= 3 distinct destinations; D5 not itself tier 1.
--   tier 3  unlabelled hubs with fan-in >= 25 deposit-like accounts (H1) that send >= 80% of their
--           outflow to tier-1 accounts (H2), plus the deposit-like accounts sweeping into them.
--   tier 4  (upper bound only) top-100 receivers by gross inflow that are not in tiers 1-3.
--   Exchange name of a tier-2/3 account = exchange of the tier-1 account it (or its hub) sweeps to.
-- Level L set = tiers <= L. Net exchange inflow(L) = transfers from outside set(L) into set(L) minus
-- transfers from set(L) to outside. Transfers inside the set (deposit->hot sweeps, hot->cold,
-- exchange->exchange) cancel by construction.
--   lower bound (PREREG "0% of unlabelled is exchange-bound") = level 1, 2 or 3 (report all three)
--   upper bound (PREREG "100%")                                = level 4
--
-- Output: one table, column `leg`:
--   flow    day, lvl, direction (in|out), exchange, near, n, note='kind=<transfer|fcall_deposit>;cp=<pool|intents|wrap|other>'
--   top100  rk, account, tier, exchange, near=gross inflow, near2=gross outflow, n=in transfers,
--           n2=distinct senders, note=deposit_like|hub|NULL              (labelled coverage)
--   hub     account, n=fan-in of deposit-like accounts, near=swept in, near2=sent to tier 1,
--           tier, exchange (top 500 by swept)                            (clusters for review)
--   member  account, tier, exchange, near=inflow, near2=outflow (tiers 2-3; feeds b_*.sql lists)
--   qa      note=metric, near, n
WITH named AS (
  SELECT exchange, account FROM UNNEST([
    -- GENERATED from exchange_accounts.json (40 accounts, all with a cited source); do not hand-edit
    STRUCT('binance' AS exchange, '10da3e6516672e0317d9c20e0bf89018271b18c5e3b01ac7b246b2417636a57b' AS account),
    ('binance', '1fc0d96bc0304bfaa1672d2ee84bfeed86ed2db1bdccedab95fa9792a4438a24'),
    ('binance', '27ddc83845172d5ee380af7ba6bcc524145892ff0b91a6078e9ae6d26655e56a'),
    ('binance', '451913e633c72fb951effe076d3bd2977e3f08083dcf6c87fa89992b0d437c5c'),
    ('binance', '56203c5b21b828175fa9c1fd4161ecaca76de9a1f6008935eeb9b4d6dc821a22'),
    ('binance', '5c33c6218d47e00ef229f60da78d0897e1ee9665312550b8afd5f9c7bc6957d2'),
    ('binance', '7747991786f445efb658b69857eadc7a57b6b475beec26ed14da8bc35bb2b5b6'),
    ('binance', '7e6e17fcb8e8e6a22ecd47bbd1b58b1af3582b97bbfd4a8d974bb9c266fa282b'),
    ('binance', '9c484fa5d2d069569ba063fc555c34e621ccd88fdbb0295fc79bad232621c5c1'),
    ('binance', 'b8caf00f8f925cc7b3925def6db361974403082ac7e7710b8342e0b20ac496e9'),
    ('binance', 'bc2fa68aa5d9a0d4e75fbe5659369aa13e1bccf7cabf81ac5d007ae0e51fcac3'),
    ('binance', 'binance1.near'),
    ('binance', 'binancecold3.near'),
    ('binance', 'c6f10c6993a97c90e34ce60c5ea3ccb4915cf731daff0e7a2e5d93ebc879cc74'),
    ('binance', 'ce766fc85f14b52d177bb0620a3be19585783644282b16ff3cfe3f4f699ece03'),
    ('binance', 'd04204b6591fefb973a8ed60929f8211af89ee38020da9faf905acdc7a320063'),
    ('binance', 'e1074e251c7350b8a4480816fffd897b727011df579e04cc19f890fd48fd8830'),
    ('binance', 'e1a70d1d2b8df95e0742c5aa18eb9089d84d5365fead073ac77d4c115cf3e264'),
    ('binance', 'e37e1cf6cd9c8601881799e531c958cd0ca01c734a6349aa88a23489c4258d05'),
    ('bitfinex', '383e50ea1a754ed3acd0d59116f221add87adb82559f31ca6d377f058fe83375'),
    ('bitfinex', '965c8b57b7f36fe9a40ce6188d444ca78708e4d83843b108f7f53d0fe5332076'),
    ('bitget', '241754260760e04e3a90acf27b1c54296b81e52a3b21fab8347ae88066946092'),
    ('bitget', '454e9a19b4552d08132efb9db354f8cdb1ceb155d8c2c9806f6cb15d947187cf'),
    ('gate', '0d584a4cbbfd9a4878d816512894e65918e54fae13df39a6f520fc90caea2fb0'),
    ('gate', 'f857de8a2a882488235eda61d3f41c4a60591d7f8daec1299ec0f20426a4cc3f'),
    ('gate', 'e10e284823bc0728f1850486fd4ccd5546249140e96823ac09f96b30363cd251'),
    ('gate', 'bc02e51d5f4c03611ef28d8fdbdba01b237f5a870fad7670d0a17a1a14934b97'),
    ('kucoin', 'kucoinc.near'),
    ('kucoin', 'e589457354361489a89039b8be6737cbc2db4d13919b6ccf23889a60f3b0d8f3'),
    ('kucoin', '7b865db190b966fe6ea30d0e7cc44ce42c4ea4f159a4b0b937122f166fc3ae28'),
    ('mexc', 'dba256d942a6fbfef9c8d42a2960f89a1f6dcc1e8490c7531d89a470d1d00405'),
    ('swissborg', 'dc6b4c8821dbe652b763e3bfadfea548137b29b97408c8b411ad72acff94e63f'),
    ('swissborg', '1c0dc521827821f1695538ff9312df15f32837bbfe95bc937f9faaafd4125552'),
    ('swissborg', '9b23bfd45a028e7a28326007b221cf8bd8b288630dde5ca714a0524f4865db89'),
    ('swissborg', '034e29f9703726c1f7b955fa5f7b16f6293adec615f668a73bc3b3b0255392df'),
    ('swissborg', 'c298ef5c3754dbcb6c23b481b514641f91d46845a256be4fd6ad742d5f3c251c'),
    ('flipster', 'd09904357488c186e9105396dc32f1a1180bf9870a09c037b3282372e337e770'),
    ('gate_us', '679760352e80fca56d416fdbe8c9e060ed96a5a2c7b4bb5add51f99a08fd8afe'),
    ('gate_us', 'c2566b91e059eb97e2acaa57fe1647db65970fe43f50a7264483d717737f2348'),
    ('bitlo', '6ab1742337f2734a9da8bc75091c0a4558280adc951be7db04feb4c1cea0edc1')
  ])
),
t0 AS (
  SELECT block_date AS day, action_kind AS kind,
         receipt_predecessor_account_id AS sender,
         receipt_receiver_account_id AS receiver,
         args
  FROM `bigquery-public-data.crypto_near_mainnet_us.receipt_actions`
  WHERE block_date BETWEEN '2026-08-07' AND '2026-11-04'
    AND action_kind IN ('TRANSFER', 'FUNCTION_CALL')
    AND receipt_predecessor_account_id != 'system'
    AND receipt_predecessor_account_id != receipt_receiver_account_id
),
t AS (
  SELECT day, sender, receiver, CAST(JSON_VALUE(args, '$.deposit') AS BIGNUMERIC) / 1e24 AS near
  FROM t0 WHERE kind = 'TRANSFER'
),
e AS (SELECT sender, receiver, SUM(near) AS near, COUNT(*) AS n FROM t GROUP BY sender, receiver),
acct_in AS (
  SELECT receiver AS acct, SUM(near) AS in_near, SUM(n) AS in_n, COUNT(*) AS n_senders
  FROM e GROUP BY receiver
),
acct_out AS (
  SELECT sender AS acct, SUM(near) AS out_near, SUM(n) AS out_n, COUNT(*) AS n_dests,
         ARRAY_AGG(STRUCT(receiver AS dest, near AS near) ORDER BY near DESC LIMIT 1)[OFFSET(0)] AS top
  FROM e GROUP BY sender
),
dep AS (  -- deposit-like accounts, rules D1-D5
  SELECT o.acct, o.top.dest AS dest, i.in_near, o.out_near, i.n_senders
  FROM acct_out o JOIN acct_in i USING (acct)
  WHERE i.in_near >= 1
    AND o.out_near BETWEEN 0.9 * i.in_near AND 1.5 * i.in_near
    AND o.top.near >= 0.9 * o.out_near
    AND o.n_dests <= 3
    AND o.acct NOT IN (SELECT account FROM named)
),
hubs AS (
  SELECT dest AS hub, COUNT(*) AS n_dep, SUM(out_near) AS swept
  FROM dep GROUP BY dest
),
hub_to_named AS (
  SELECT e.sender AS hub, nm.exchange, SUM(e.near) AS near
  FROM e JOIN named nm ON e.receiver = nm.account
  WHERE e.sender IN (SELECT hub FROM hubs WHERE n_dep >= 25)
  GROUP BY e.sender, nm.exchange
),
hub_named AS (
  SELECT hub, SUM(near) AS to_named,
         ARRAY_AGG(STRUCT(exchange, near) ORDER BY near DESC LIMIT 1)[OFFSET(0)].exchange AS exchange
  FROM hub_to_named GROUP BY hub
),
hub3 AS (  -- tier-3 hubs, rules H1-H2
  SELECT h.hub, hn.exchange
  FROM hubs h JOIN hub_named hn USING (hub) JOIN acct_out o ON o.acct = h.hub
  WHERE h.n_dep >= 25
    AND h.hub NOT IN (SELECT account FROM named)
    AND hn.to_named >= 0.8 * o.out_near
),
mem_raw AS (
  SELECT account AS acct, 1 AS tier, exchange FROM named
  UNION ALL SELECT d.acct, 2, nm.exchange FROM dep d JOIN named nm ON d.dest = nm.account
  UNION ALL SELECT hub, 3, exchange FROM hub3
  UNION ALL SELECT d.acct, 3, h.exchange FROM dep d JOIN hub3 h ON d.dest = h.hub
),
mem AS (
  SELECT acct, MIN(tier) AS tier,
         ARRAY_AGG(exchange ORDER BY tier LIMIT 1)[OFFSET(0)] AS exchange
  FROM mem_raw GROUP BY acct
),
top100 AS (
  SELECT acct, in_near, in_n, n_senders, ROW_NUMBER() OVER (ORDER BY in_near DESC) AS rk
  FROM (SELECT * FROM acct_in ORDER BY in_near DESC LIMIT 100)
),
mem4 AS (
  SELECT acct, tier, exchange FROM mem
  UNION ALL
  SELECT p.acct, 4, CONCAT('top100:', p.acct) FROM top100 p LEFT JOIN mem m USING (acct) WHERE m.acct IS NULL
),
tf0 AS (  -- boundary candidates first (cheap join), then parse FunctionCall deposits only for those
  SELECT t0.day, LOWER(t0.kind) AS kind, t0.sender, t0.receiver, t0.args,
         s.tier AS s_tier, s.exchange AS s_ex, r.tier AS r_tier, r.exchange AS r_ex
  FROM t0
  LEFT JOIN mem4 s ON t0.sender = s.acct
  LEFT JOIN mem4 r ON t0.receiver = r.acct
  WHERE s.acct IS NOT NULL OR r.acct IS NOT NULL
),
tf AS (
  SELECT day, IF(kind = 'transfer', 'transfer', 'fcall_deposit') AS kind, near, s_tier, s_ex, r_tier, r_ex,
         CASE WHEN cp LIKE '%.poolv1.near' OR cp LIKE '%.pool.near' THEN 'pool'
              WHEN cp = 'intents.near' THEN 'intents'
              WHEN cp = 'wrap.near' THEN 'wrap' ELSE 'other' END AS cp_in,
         CASE WHEN cr LIKE '%.poolv1.near' OR cr LIKE '%.pool.near' THEN 'pool'
              WHEN cr = 'intents.near' THEN 'intents'
              WHEN cr = 'wrap.near' THEN 'wrap' ELSE 'other' END AS cp_out
  FROM (SELECT *, sender AS cp, receiver AS cr,
               CAST(JSON_VALUE(args, '$.deposit') AS BIGNUMERIC) / 1e24 AS near FROM tf0)
  WHERE near > 0
),
flow AS (
  SELECT day, lvl, 'in' AS direction, r_ex AS exchange, kind, cp_in AS cp, SUM(near) AS near, COUNT(*) AS n
  FROM tf, UNNEST([1, 2, 3, 4]) AS lvl
  WHERE r_tier <= lvl AND (s_tier IS NULL OR s_tier > lvl)
  GROUP BY day, lvl, r_ex, kind, cp_in
  UNION ALL
  SELECT day, lvl, 'out', s_ex, kind, cp_out, SUM(near), COUNT(*)
  FROM tf, UNNEST([1, 2, 3, 4]) AS lvl
  WHERE s_tier <= lvl AND (r_tier IS NULL OR r_tier > lvl)
  GROUP BY day, lvl, s_ex, kind, cp_out
)
SELECT 'flow' AS leg, day, lvl, CAST(NULL AS INT64) AS rk, CAST(NULL AS STRING) AS account,
       CAST(NULL AS INT64) AS tier, exchange, direction, ROUND(near, 6) AS near,
       CAST(NULL AS BIGNUMERIC) AS near2, n, CAST(NULL AS INT64) AS n2,
       CONCAT('kind=', kind, ';cp=', cp) AS note
FROM flow
UNION ALL
SELECT 'top100', NULL, NULL, p.rk, p.acct, m.tier, m.exchange, NULL, ROUND(p.in_near, 6),
       ROUND(o.out_near, 6), p.in_n, p.n_senders,
       CASE WHEN d.acct IS NOT NULL THEN CONCAT('deposit_like->', d.dest)
            WHEN hb.n_dep >= 25 THEN CONCAT('hub fan-in ', CAST(hb.n_dep AS STRING)) END
FROM top100 p LEFT JOIN mem m USING (acct) LEFT JOIN acct_out o USING (acct)
LEFT JOIN dep d USING (acct) LEFT JOIN hubs hb ON hb.hub = p.acct
UNION ALL
SELECT 'hub', NULL, NULL, NULL, h.hub, m.tier, COALESCE(m.exchange, hn.exchange), NULL,
       ROUND(h.swept, 6), ROUND(hn.to_named, 6), h.n_dep, NULL, NULL
FROM (SELECT * FROM hubs WHERE n_dep >= 25 ORDER BY swept DESC LIMIT 500) h
LEFT JOIN hub_named hn USING (hub) LEFT JOIN mem m ON m.acct = h.hub
UNION ALL
SELECT 'member', NULL, NULL, NULL, m.acct, m.tier, m.exchange, NULL, ROUND(i.in_near, 6),
       ROUND(o.out_near, 6), i.in_n, o.out_n, NULL
FROM mem m LEFT JOIN acct_in i USING (acct) LEFT JOIN acct_out o USING (acct)
WHERE m.tier IN (2, 3)
UNION ALL
SELECT 'qa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, ROUND(SUM(near), 6), NULL, COUNT(*),
       COUNTIF(near IS NULL), 'transfers_total (n2 = rows with unparsable deposit)'
FROM t
UNION ALL
SELECT 'qa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, ROUND(SUM(in_near), 6), NULL, COUNT(*), NULL,
       'deposit_like_accounts'
FROM dep

sql/h1b_b_wnear_logs.sql 821,680 bytes

The header comment of this file says “NOT run” because it was written before the run. The run record is the 2026-11-06 23:23 UTC entry of PREREG-ADDENDUM.md.

This file is 821,680 bytes because it inlines the account lists. The page shows it as stored, except that 7 very long lines are cut where marked; the full file is at the link above.

-- b_h1b_wnear_flows_logs.sql  (lane h1b-exchange, phase 1a: written and dry-run only, NOT run)
-- PREREG H1b/H1c wNEAR leg: wrap.near transfers into and out of the labelled exchange sets, from the
-- logs of wrap.near receipts in execution_outcomes (no receipt_actions, no args).
--
-- WINDOW (edit here only): block_date BETWEEN '2026-08-07' AND '2026-11-04'
--
-- IMPORTANT, checked 2026-11-06 by RPC (evidence/wrap_near_tx_6jxE7zxh_logs.json): wrap.near does NOT
-- emit NEP-297 EVENT_JSON logs. It emits the legacy near-contract-standards lines
--   "Transfer <yocto> from <sender> to <receiver>"   (ft_transfer, ft_transfer_call)
--   "Refund <yocto> from <receiver> to <sender>"     (ft_resolve_transfer; a reverse movement)
-- Both are parsed as a movement first-account -> second-account. EVENT_JSON nep141 ft_transfer lines
-- are also parsed, in case the contract is upgraded; each format is kept in its own `fmt` column so a
-- double emission would be visible rather than silently summed. Deposit/Withdraw (wrap/unwrap) lines
-- are ignored: they are not transfers between accounts. Receipts whose status contains FAIL are dropped
-- (status value spelling unverified; see notes.md).
--
-- Labelled sets: identical tiers to a_h1b_native_flows.sql. Tier 1 = named block below (from
-- exchange_accounts.json). Tiers 2-4 are pasted into `extra` from a_*.sql output (legs `member` and
-- `top100` with tier 4) before this query runs; bytes scanned do not depend on the list length.
-- Net wNEAR inflow(L) = movements from outside set(L) into it minus movements out of it.
--
-- Output, column `leg`: flow (day, lvl, direction, exchange, fmt, near, n) and qa (fmt, near, n).
WITH named AS (
  SELECT exchange, account FROM UNNEST([
    -- GENERATED from exchange_accounts.json (40 accounts, all with a cited source); do not hand-edit
    STRUCT('binance' AS exchange, '10da3e6516672e0317d9c20e0bf89018271b18c5e3b01ac7b246b2417636a57b' AS account),
    ('binance', '1fc0d96bc0304bfaa1672d2ee84bfeed86ed2db1bdccedab95fa9792a4438a24'),
    ('binance', '27ddc83845172d5ee380af7ba6bcc524145892ff0b91a6078e9ae6d26655e56a'),
    ('binance', '451913e633c72fb951effe076d3bd2977e3f08083dcf6c87fa89992b0d437c5c'),
    ('binance', '56203c5b21b828175fa9c1fd4161ecaca76de9a1f6008935eeb9b4d6dc821a22'),
    ('binance', '5c33c6218d47e00ef229f60da78d0897e1ee9665312550b8afd5f9c7bc6957d2'),
    ('binance', '7747991786f445efb658b69857eadc7a57b6b475beec26ed14da8bc35bb2b5b6'),
    ('binance', '7e6e17fcb8e8e6a22ecd47bbd1b58b1af3582b97bbfd4a8d974bb9c266fa282b'),
    ('binance', '9c484fa5d2d069569ba063fc555c34e621ccd88fdbb0295fc79bad232621c5c1'),
    ('binance', 'b8caf00f8f925cc7b3925def6db361974403082ac7e7710b8342e0b20ac496e9'),
    ('binance', 'bc2fa68aa5d9a0d4e75fbe5659369aa13e1bccf7cabf81ac5d007ae0e51fcac3'),
    ('binance', 'binance1.near'),
    ('binance', 'binancecold3.near'),
    ('binance', 'c6f10c6993a97c90e34ce60c5ea3ccb4915cf731daff0e7a2e5d93ebc879cc74'),
    ('binance', 'ce766fc85f14b52d177bb0620a3be19585783644282b16ff3cfe3f4f699ece03'),
    ('binance', 'd04204b6591fefb973a8ed60929f8211af89ee38020da9faf905acdc7a320063'),
    ('binance', 'e1074e251c7350b8a4480816fffd897b727011df579e04cc19f890fd48fd8830'),
    ('binance', 'e1a70d1d2b8df95e0742c5aa18eb9089d84d5365fead073ac77d4c115cf3e264'),
    ('binance', 'e37e1cf6cd9c8601881799e531c958cd0ca01c734a6349aa88a23489c4258d05'),
    ('bitfinex', '383e50ea1a754ed3acd0d59116f221add87adb82559f31ca6d377f058fe83375'),
    ('bitfinex', '965c8b57b7f36fe9a40ce6188d444ca78708e4d83843b108f7f53d0fe5332076'),
    ('bitget', '241754260760e04e3a90acf27b1c54296b81e52a3b21fab8347ae88066946092'),
    ('bitget', '454e9a19b4552d08132efb9db354f8cdb1ceb155d8c2c9806f6cb15d947187cf'),
    ('gate', '0d584a4cbbfd9a4878d816512894e65918e54fae13df39a6f520fc90caea2fb0'),
    ('gate', 'f857de8a2a882488235eda61d3f41c4a60591d7f8daec1299ec0f20426a4cc3f'),
    ('gate', 'e10e284823bc0728f1850486fd4ccd5546249140e96823ac09f96b30363cd251'),
    ('gate', 'bc02e51d5f4c03611ef28d8fdbdba01b237f5a870fad7670d0a17a1a14934b97'),
    ('kucoin', 'kucoinc.near'),
    ('kucoin', 'e589457354361489a89039b8be6737cbc2db4d13919b6ccf23889a60f3b0d8f3'),
    ('kucoin', '7b865db190b966fe6ea30d0e7cc44ce42c4ea4f159a4b0b937122f166fc3ae28'),
    ('mexc', 'dba256d942a6fbfef9c8d42a2960f89a1f6dcc1e8490c7531d89a470d1d00405'),
    ('swissborg', 'dc6b4c8821dbe652b763e3bfadfea548137b29b97408c8b411ad72acff94e63f'),
    ('swissborg', '1c0dc521827821f1695538ff9312df15f32837bbfe95bc937f9faaafd4125552'),
    ('swissborg', '9b23bfd45a028e7a28326007b221cf8bd8b288630dde5ca714a0524f4865db89'),
    ('swissborg', '034e29f9703726c1f7b955fa5f7b16f6293adec615f668a73bc3b3b0255392df'),
    ('swissborg', 'c298ef5c3754dbcb6c23b481b514641f91d46845a256be4fd6ad742d5f3c251c'),
    ('flipster', 'd09904357488c186e9105396dc32f1a1180bf9870a09c037b3282372e337e770'),
    ('gate_us', '679760352e80fca56d416fdbe8c9e060ed96a5a2c7b4bb5add51f99a08fd8afe'),
    ('gate_us', 'c2566b91e059eb97e2acaa57fe1647db65970fe43f50a7264483d717737f2348'),
    ('bitlo', '6ab1742337f2734a9da8bc75091c0a4558280adc951be7db04feb4c1cea0edc1')
  ])
),
extra AS (  -- GENERATED from a_h1b_native_flows.sql output before running (tiers 2, 3, 4)
  SELECT acct, 2 AS tier, 'binance' AS exchange FROM UNNEST(SPLIT('000d2f2a1b99d1aa1b9f21b50557d31b70edb450870228585835aa7a626b0a6c,001b49542d78e51a775140a1f736 [... 503,852 characters omitted on this line ...] fe84cc5265f31f50551850dada293a329e2e5e1bc02305413daecc7de7482d40', ',')) AS acct
  UNION ALL
  SELECT acct, 2 AS tier, 'bitfinex' AS exchange FROM UNNEST(SPLIT('0718e9895b09f99790e9074388ace6bd358296dad876e68da0a4924e0be86c9d,074d0e74eb31a8ba408e5890c69 [... 1,143 characters omitted on this line ...] ebfaeb321654cb024b1453e8fe5fd78d11c0a28aae137382a95a1893c3025453', ',')) AS acct
  UNION ALL
  SELECT acct, 2 AS tier, 'bitget' AS exchange FROM UNNEST(SPLIT('0008e8cb757ab9c83d6c37cc0739c48ca20d1e1c37951d486577aff5539b01f9,00374e4a5fe4653236697578e9515 [... 102,736 characters omitted on this line ...] fff0d3e88fe782117e06b780b41afc6a07d1b2b08ddb52facd861538cbaf9276', ',')) AS acct
  UNION ALL
  SELECT acct, 2 AS tier, 'gate' AS exchange FROM UNNEST(SPLIT('0011ae87e1f389ac14b05009c1ba70d64c5b7facd62c1e5bd77b11bfbbee70b1,0068b75d43842163f2aa522e6078957 [... 81,934 characters omitted on this line ...] fff72ef842b42a0b252e15b20efb3411e6fdd80b0fc58341062b60b0d80441d3', ',')) AS acct
  UNION ALL
  SELECT acct, 2 AS tier, 'gate_us' AS exchange FROM UNNEST(SPLIT('4701c00b410394005970f2da9b99f1627cfb53438a39ec9425ac3ff63786560e,8ec297bbc9484f058f72a00a366a30a029b40e89f4ee54dd8c138cc453399633', ',')) AS acct
  UNION ALL
  SELECT acct, 2 AS tier, 'kucoin' AS exchange FROM UNNEST(SPLIT('009a227dab6a137682f24d0f1da2f5468dbe8a89b0d4c703e1c492da08046a14,00c7fff7eb98fc660d84d2420f852 [... 72,901 characters omitted on this line ...] fff56b7d6cae37bb1f276f9291e7b1b1befaa9011917881772c813d3094df857', ',')) AS acct
  UNION ALL
  SELECT acct, 2 AS tier, 'swissborg' AS exchange FROM UNNEST(SPLIT('005f21bdaef70adc7e0a336d1ca474a9b98f566945bb1ff0260db2df3f42310e,058042c3b327eadf63fa26b59c [... 10,634 characters omitted on this line ...] f9b7dbf962c91d02cf5ff0913aaf037c2b6808545b719bf7337c7818f7872775', ',')) AS acct
  UNION ALL
  SELECT acct, 3 AS tier, 'binance' AS exchange FROM UNNEST(SPLIT('007500383c8196a15c747c53a217a0e1ab517cb42f7d70ab6cd07be9d030bce6,0076c0306f65312bc8c4ea7e0a22 [... 27,713 characters omitted on this line ...] ffb8bcf74698164228e61e6e7cd4c855d73ddc74154713af5bf0dbf0dafcb5cd', ',')) AS acct
  UNION ALL
  SELECT acct, tier, exchange FROM UNNEST(ARRAY<STRUCT<acct STRING, tier INT64, exchange STRING>>[
    ('52435fe912307fb3a088b8b8f3882781762fc1f0a404e8579c7fb1a964362c8d', 4, 'top100:52435fe912307fb3a088b8b8f3882781762fc1f0a404e8579c7fb1a964362c8d'),
    ('466222f1d229ca75ae9b4c82202e0e0b2fc3f6bdbdbac3704e8bf1808baa6093', 4, 'top100:466222f1d229ca75ae9b4c82202e0e0b2fc3f6bdbdbac3704e8bf1808baa6093'),
    ('2874f85cf17404b4c43ad4e869ff0c7ef16a2b3ddea6c01033fedc55ba6d4eac', 4, 'top100:2874f85cf17404b4c43ad4e869ff0c7ef16a2b3ddea6c01033fedc55ba6d4eac'),
    ('bridge-mng.near', 4, 'top100:bridge-mng.near'),
    ('d549d25ebc8dcd705ee1aac7d961fc31b07fa52e8d59ba56ddd788f09d6cec46', 4, 'top100:d549d25ebc8dcd705ee1aac7d961fc31b07fa52e8d59ba56ddd788f09d6cec46'),
    ('940ef3f4f1e2d72b2036c685e5db7ff38ea0f84cce9b1c538bb1db1bb6678950', 4, 'top100:940ef3f4f1e2d72b2036c685e5db7ff38ea0f84cce9b1c538bb1db1bb6678950'),
    ('intents.near', 4, 'top100:intents.near'),
    ('717f12dd9354b83dac4c80b60dbc15712baac97834d63ccf545c53db57d9eeb3', 4, 'top100:717f12dd9354b83dac4c80b60dbc15712baac97834d63ccf545c53db57d9eeb3'),
    ('ccb91e1db61e8d7e1d4ae3e043001140132959a86ee35a548b6563a46284a6ea', 4, 'top100:ccb91e1db61e8d7e1d4ae3e043001140132959a86ee35a548b6563a46284a6ea'),
    ('30d6205b89e02d2c34ade165ae9705f8d9e80d0e304061cb10b8e56c8e703f62', 4, 'top100:30d6205b89e02d2c34ade165ae9705f8d9e80d0e304061cb10b8e56c8e703f62'),
    ('nfendowment03.near', 4, 'top100:nfendowment03.near'),
    ('498eee3c286d618675185ca234c288dce8f30aa39676f38df2f556a0b074cc3d', 4, 'top100:498eee3c286d618675185ca234c288dce8f30aa39676f38df2f556a0b074cc3d'),
    ('7875aef71e16a1c4ec9855a4ad77c0b533d84ec340110f79b652c9b49d7444aa', 4, 'top100:7875aef71e16a1c4ec9855a4ad77c0b533d84ec340110f79b652c9b49d7444aa'),
    ('1e6ef8464ce09f96c6fc22583ead00fa0b65119128daa9732366d2a2e856e960', 4, 'top100:1e6ef8464ce09f96c6fc22583ead00fa0b65119128daa9732366d2a2e856e960'),
    ('f1bb20659f00960c4a54077f00ad4316b01eddc13d2050f6ebc190bb64492e6a', 4, 'top100:f1bb20659f00960c4a54077f00ad4316b01eddc13d2050f6ebc190bb64492e6a'),
    ('1244d552459d7230bdaf267c1d09a296282dc85251958434e670d9b9d561fac7', 4, 'top100:1244d552459d7230bdaf267c1d09a296282dc85251958434e670d9b9d561fac7'),
    ('42c3b82b53f233d0f044cb995451385d359297f94369b99215cf84d1c2b32ca4', 4, 'top100:42c3b82b53f233d0f044cb995451385d359297f94369b99215cf84d1c2b32ca4'),
    ('3e93b62aec7f1275a2eb6a0145d1d6406fd94f6c44f7fd705711f8139b5d25f9', 4, 'top100:3e93b62aec7f1275a2eb6a0145d1d6406fd94f6c44f7fd705711f8139b5d25f9'),
    ('29d0438761b61f5a9a6fb9d736f9c4a194d85e80535d04d80dda568eb8ed7603', 4, 'top100:29d0438761b61f5a9a6fb9d736f9c4a194d85e80535d04d80dda568eb8ed7603'),
    ('2b8cc04e26f38bcbd600a9a1e0991edb7040037eb82f3bf553978284c33f35d3', 4, 'top100:2b8cc04e26f38bcbd600a9a1e0991edb7040037eb82f3bf553978284c33f35d3'),
    ('d2f0f590b1077d6ea63c37fd5c558bd5d3c455ac78ced8e2a81395a24407c22a', 4, 'top100:d2f0f590b1077d6ea63c37fd5c558bd5d3c455ac78ced8e2a81395a24407c22a'),
    ('bf44259660eb5dd66a0a39b0addf94c5724359a38e5caa4acf7be7a832a1f8b8', 4, 'top100:bf44259660eb5dd66a0a39b0addf94c5724359a38e5caa4acf7be7a832a1f8b8'),
    ('opgran01.near', 4, 'top100:opgran01.near'),
    ('23ced4300a4bf282bf94a4fcd2b0af32ad291ef531f544f6d7d283e8ff1e684a', 4, 'top100:23ced4300a4bf282bf94a4fcd2b0af32ad291ef531f544f6d7d283e8ff1e684a'),
    ('5754ff26eaa951cd814f657c840059086da32ecd600efc58106028ed6b6b3559', 4, 'top100:5754ff26eaa951cd814f657c840059086da32ecd600efc58106028ed6b6b3559'),
    ('25ab96ddd0d9a8e0ab48b45c2ef7473a83c4ff7e49239b46613b3d688e024731', 4, 'top100:25ab96ddd0d9a8e0ab48b45c2ef7473a83c4ff7e49239b46613b3d688e024731'),
    ('meta-pool.near', 4, 'top100:meta-pool.near'),
    ('ae1b2d06cee9353fba5ce28827f4cccbbf6e0dc161dfc3b154f71c5902c3fcca', 4, 'top100:ae1b2d06cee9353fba5ce28827f4cccbbf6e0dc161dfc3b154f71c5902c3fcca'),
    ('e672fced9d9e5c3a0d9afbca6f50b957e29f11a3fd0004cc833bb26882c653e2', 4, 'top100:e672fced9d9e5c3a0d9afbca6f50b957e29f11a3fd0004cc833bb26882c653e2'),
    ('ac79b2cdc19e17428057d600bf11892d6b47cb709d6b383a03ec1bf637741958', 4, 'top100:ac79b2cdc19e17428057d600bf11892d6b47cb709d6b383a03ec1bf637741958'),
    ('f9cdfdf61274ce83833a82a05f261417f920f11110769113741d9c4c1acd2c96', 4, 'top100:f9cdfdf61274ce83833a82a05f261417f920f11110769113741d9c4c1acd2c96'),
    ('53aae097294e229eff16b742fd7af62ac6dbae6055fa49a35759c74abb537d0c', 4, 'top100:53aae097294e229eff16b742fd7af62ac6dbae6055fa49a35759c74abb537d0c'),
    ('60142764c4cd3239d7d6e1973e87073f9d25773af225a74b22f3f9c9761fe8a5', 4, 'top100:60142764c4cd3239d7d6e1973e87073f9d25773af225a74b22f3f9c9761fe8a5'),
    ('ec3ba010379f286553bb1ec59891f73b3aa67e1a7a890d394e36db5c6e4598fc', 4, 'top100:ec3ba010379f286553bb1ec59891f73b3aa67e1a7a890d394e36db5c6e4598fc'),
    ('3c5977c54569c420a6f4f9d5244c0cde7e0ccb0c5ca347924bc808610d6c77a0', 4, 'top100:3c5977c54569c420a6f4f9d5244c0cde7e0ccb0c5ca347924bc808610d6c77a0'),
    ('eb3fb6501f7247047e94503443dc5f650fe4502e953bc2e6bc3236844baae7c2', 4, 'top100:eb3fb6501f7247047e94503443dc5f650fe4502e953bc2e6bc3236844baae7c2'),
    ('1e74ab0a225c87cf49c5b031f29208195ba5b284fd0fefceaa9e283455686c02', 4, 'top100:1e74ab0a225c87cf49c5b031f29208195ba5b284fd0fefceaa9e283455686c02'),
    ('943ee8c1dd517f34bd8205fc6aecfc1286ee0d11bcd2e473d23f7a4d918748e0', 4, 'top100:943ee8c1dd517f34bd8205fc6aecfc1286ee0d11bcd2e473d23f7a4d918748e0'),
    ('4e6baf302947fe14135a83a63106bf0834e9247eef4aa76690ab4ac334938bfd', 4, 'top100:4e6baf302947fe14135a83a63106bf0834e9247eef4aa76690ab4ac334938bfd'),
    ('nfendowment03.sputnik-dao.near', 4, 'top100:nfendowment03.sputnik-dao.near'),
    ('03793fb37ffb46533e9b8ab6b9c7a1ebdd6d84f6ebc151b8f60ec1754bbcada6', 4, 'top100:03793fb37ffb46533e9b8ab6b9c7a1ebdd6d84f6ebc151b8f60ec1754bbcada6'),
    ('af09768659017107aad46477428f1ca3c267ff8b95d96bb1ab8a272f8df7c8f6', 4, 'top100:af09768659017107aad46477428f1ca3c267ff8b95d96bb1ab8a272f8df7c8f6'),
    ('linear-protocol.near', 4, 'top100:linear-protocol.near'),
    ('d9690f36c742a6b64a1fbd448a121b0e66bcef14c3115b56192766f2d4c3ba06', 4, 'top100:d9690f36c742a6b64a1fbd448a121b0e66bcef14c3115b56192766f2d4c3ba06'),
    ('41cb324d7992338a882038804cf193154d0001b4af1a096bdd36154c0af0ef00', 4, 'top100:41cb324d7992338a882038804cf193154d0001b4af1a096bdd36154c0af0ef00'),
    ('f9e0ff50970bfdee2a59e039f9da76f267bba161e1a9b11dd16a81e8ef702091', 4, 'top100:f9e0ff50970bfdee2a59e039f9da76f267bba161e1a9b11dd16a81e8ef702091'),
    ('2045ea024b1a72afdbe22ef1d95f1dc42ed0e7db3a906ce4319f723477c2dc5a', 4, 'top100:2045ea024b1a72afdbe22ef1d95f1dc42ed0e7db3a906ce4319f723477c2dc5a'),
    ('efd224256518a7cacd209867963276efed302a8e222c013c43f4b1bd369ae5af', 4, 'top100:efd224256518a7cacd209867963276efed302a8e222c013c43f4b1bd369ae5af'),
    ('7cc35ace7b7e8c5f2a23dbcfc0a99bebb4feb9914539d81fd79cdd1feddc9355', 4, 'top100:7cc35ace7b7e8c5f2a23dbcfc0a99bebb4feb9914539d81fd79cdd1feddc9355'),
    ('5b43682c64f3dce763b73d5f5d17a98fe9133d5d2a2dd7d6dc33e5d703c90cbe', 4, 'top100:5b43682c64f3dce763b73d5f5d17a98fe9133d5d2a2dd7d6dc33e5d703c90cbe'),
    ('8e2922ee58ed8f6c5533e1440529155c429f6089cc81ece428193950f05a0263', 4, 'top100:8e2922ee58ed8f6c5533e1440529155c429f6089cc81ece428193950f05a0263'),
    ('91c122a00982c51255ac646e5dc8a47f5a21990e9c4f6bd3d0b74c434d5c9ff1', 4, 'top100:91c122a00982c51255ac646e5dc8a47f5a21990e9c4f6bd3d0b74c434d5c9ff1'),
    ('ce87229986688b80997501765c2f92b8becd8905079f02871598d2cd4785d64c', 4, 'top100:ce87229986688b80997501765c2f92b8becd8905079f02871598d2cd4785d64c'),
    ('closemeat6237.near', 4, 'top100:closemeat6237.near'),
    ('3723636b73c0d56890c57173d45cfd8ea51ac6c6c79c65fcbf79053438cbc1b6', 4, 'top100:3723636b73c0d56890c57173d45cfd8ea51ac6c6c79c65fcbf79053438cbc1b6'),
    ('75b5de8d982c8b6b98013cd0f1cc7558b8705e5b1928c24936ff47bd87312ca5', 4, 'top100:75b5de8d982c8b6b98013cd0f1cc7558b8705e5b1928c24936ff47bd87312ca5'),
    ('c1833ea5a24a38fa80d50506083bca57205326d8dc08da69a954fc2616fd963c', 4, 'top100:c1833ea5a24a38fa80d50506083bca57205326d8dc08da69a954fc2616fd963c'),
    ('8412703ca30a3ba2add00fb3f1a99931d3a4e31957b887d9438400084832c3c6', 4, 'top100:8412703ca30a3ba2add00fb3f1a99931d3a4e31957b887d9438400084832c3c6'),
    ('903e98523d70dec00e17e153726047a330521ae1c3456f646629134109d0f17c', 4, 'top100:903e98523d70dec00e17e153726047a330521ae1c3456f646629134109d0f17c'),
    ('500dd4de0f75d593a611d0453c8103e30a144ee2131ec985475cd3277f24822b', 4, 'top100:500dd4de0f75d593a611d0453c8103e30a144ee2131ec985475cd3277f24822b'),
    ('e2c58668d0cf3e6f6b43402d5aaa4301aefc9eb12a85df2cb3052992cb029acd', 4, 'top100:e2c58668d0cf3e6f6b43402d5aaa4301aefc9eb12a85df2cb3052992cb029acd'),
    ('308ef8814937fbc72e740b845bcff5fb8c1bc2f5c6a4e7aea780f673bf627703', 4, 'top100:308ef8814937fbc72e740b845bcff5fb8c1bc2f5c6a4e7aea780f673bf627703'),
    ('dclv2.ref-labs.near', 4, 'top100:dclv2.ref-labs.near'),
    ('6e8d9a66c4f74784afc86337a2763873b4599070c7357a7504adb9f21e23cb59', 4, 'top100:6e8d9a66c4f74784afc86337a2763873b4599070c7357a7504adb9f21e23cb59'),
    ('c1ae626298ddaa0fd0cf7b3d416070bf491d7cc5b5fff978318e69f5e099fa13', 4, 'top100:c1ae626298ddaa0fd0cf7b3d416070bf491d7cc5b5fff978318e69f5e099fa13'),
    ('978b2d76a15b5692b47a05b956e285f914d81454c39c608df25af16eb2abc9b4', 4, 'top100:978b2d76a15b5692b47a05b956e285f914d81454c39c608df25af16eb2abc9b4'),
    ('98446b9dd40b9dd365be9d7def69e33b6a3cb790daa95a9b447d64bb3c65d780', 4, 'top100:98446b9dd40b9dd365be9d7def69e33b6a3cb790daa95a9b447d64bb3c65d780'),
    ('45658dff4dacc4d615651388e0b4afd09aa3f60231b722ecc6dbeb46f6ebba3b', 4, 'top100:45658dff4dacc4d615651388e0b4afd09aa3f60231b722ecc6dbeb46f6ebba3b'),
    ('0d96ffd2d1098549c33738d811eb39d08065ffcfa6ac19490b82c431e48db233', 4, 'top100:0d96ffd2d1098549c33738d811eb39d08065ffcfa6ac19490b82c431e48db233'),
    ('423df0a6640e9467769c55a573f15b9ee999dc8970048959c72890abf5cc3a8e', 4, 'top100:423df0a6640e9467769c55a573f15b9ee999dc8970048959c72890abf5cc3a8e'),
    ('1825fca81bb0324279647c943edb78dca118eeb4159adf84f2763e369bdd272e', 4, 'top100:1825fca81bb0324279647c943edb78dca118eeb4159adf84f2763e369bdd272e'),
    ('78e2bf41323b17f275e24f5ce40b6023b443b8aca99e19be5b8dfad570ea21e7', 4, 'top100:78e2bf41323b17f275e24f5ce40b6023b443b8aca99e19be5b8dfad570ea21e7'),
    ('lst-pool.near', 4, 'top100:lst-pool.near'),
    ('88cc2b61cf1f5a8c7508bbe36fbf38ec26e51e7f9b898f66bee1ef5a520fda5a', 4, 'top100:88cc2b61cf1f5a8c7508bbe36fbf38ec26e51e7f9b898f66bee1ef5a520fda5a'),
    ('2380ee9f038cbf102ee807ad476700519cdb05cfb5a39b2d628af6ff8bd5dfe0', 4, 'top100:2380ee9f038cbf102ee807ad476700519cdb05cfb5a39b2d628af6ff8bd5dfe0'),
    ('78f3f9138e7286bab3e69dbf3f8dd2470d410232073c010cdc9d44882b96f292', 4, 'top100:78f3f9138e7286bab3e69dbf3f8dd2470d410232073c010cdc9d44882b96f292'),
    ('c1f4caf77eb54ec89e2f03097cffbdd35fa4186465ebb4bf90960bf23bb6f2a3', 4, 'top100:c1f4caf77eb54ec89e2f03097cffbdd35fa4186465ebb4bf90960bf23bb6f2a3'),
    ('c7f30234b645491fcd2b70a27bfef7b8dba5743ed0feb4e1ca4de08239b7f1c1', 4, 'top100:c7f30234b645491fcd2b70a27bfef7b8dba5743ed0feb4e1ca4de08239b7f1c1'),
    ('bd3b50f1e07389496ba4bb01186dadadeaf2b72c5a68e793b7cbeefd78c9321a', 4, 'top100:bd3b50f1e07389496ba4bb01186dadadeaf2b72c5a68e793b7cbeefd78c9321a'),
    ('crux-solver.near', 4, 'top100:crux-solver.near')
  ])
),
mem AS (
  SELECT acct, MIN(tier) AS tier, ARRAY_AGG(exchange ORDER BY tier LIMIT 1)[OFFSET(0)] AS exchange
  FROM (SELECT account AS acct, 1 AS tier, exchange FROM named UNION ALL SELECT * FROM extra)
  GROUP BY acct
),
lg AS (
  SELECT o.block_date AS day, l.element AS log
  FROM `bigquery-public-data.crypto_near_mainnet_us.execution_outcomes` o, UNNEST(o.logs.list) l
  WHERE o.block_date BETWEEN '2026-08-07' AND '2026-11-04'
    AND o.executor_account_id = 'wrap.near'
    AND o.status NOT LIKE '%FAIL%'
    AND (STARTS_WITH(l.element, 'Transfer ') OR STARTS_WITH(l.element, 'Refund ')
         OR STARTS_WITH(l.element, 'EVENT_JSON:'))
),
mv AS (
  SELECT day, 'legacy' AS fmt,
         CAST(REGEXP_EXTRACT(log, r'^(?:Transfer|Refund) ([0-9]+) from ') AS BIGNUMERIC) / 1e24 AS near,
         REGEXP_EXTRACT(log, r' from (\S+) to ') AS sender,
         REGEXP_EXTRACT(log, r' to (\S+)$') AS receiver
  FROM lg
  WHERE REGEXP_CONTAINS(log, r'^(?:Transfer|Refund) [0-9]+ from \S+ to \S+$')
  UNION ALL
  SELECT day, 'event_json',
         CAST(JSON_VALUE(d, '$.amount') AS BIGNUMERIC) / 1e24,
         JSON_VALUE(d, '$.old_owner_id'), JSON_VALUE(d, '$.new_owner_id')
  FROM lg, UNNEST(JSON_QUERY_ARRAY(SUBSTR(log, 12), '$.data')) d
  WHERE STARTS_WITH(log, 'EVENT_JSON:')
    AND JSON_VALUE(SUBSTR(log, 12), '$.standard') = 'nep141'
    AND JSON_VALUE(SUBSTR(log, 12), '$.event') = 'ft_transfer'
),
tf AS (
  SELECT mv.day, mv.fmt, mv.near, s.tier AS s_tier, s.exchange AS s_ex, r.tier AS r_tier, r.exchange AS r_ex
  FROM mv
  LEFT JOIN mem s ON mv.sender = s.acct
  LEFT JOIN mem r ON mv.receiver = r.acct
  WHERE (s.acct IS NOT NULL OR r.acct IS NOT NULL) AND mv.sender != mv.receiver
),
flow AS (
  SELECT day, lvl, 'in' AS direction, r_ex AS exchange, fmt, SUM(near) AS near, COUNT(*) AS n
  FROM tf, UNNEST([1, 2, 3, 4]) AS lvl
  WHERE r_tier <= lvl AND (s_tier IS NULL OR s_tier > lvl)
  GROUP BY day, lvl, r_ex, fmt
  UNION ALL
  SELECT day, lvl, 'out', s_ex, fmt, SUM(near), COUNT(*)
  FROM tf, UNNEST([1, 2, 3, 4]) AS lvl
  WHERE s_tier <= lvl AND (r_tier IS NULL OR r_tier > lvl)
  GROUP BY day, lvl, s_ex, fmt
)
SELECT 'flow' AS leg, day, lvl, direction, exchange, fmt, ROUND(near, 6) AS near, n FROM flow
UNION ALL
SELECT 'qa', NULL, NULL, NULL, NULL, fmt, ROUND(SUM(near), 6), COUNT(*) FROM mv GROUP BY fmt

sql/h1b_c_sweep_clusters.sql 7,324 bytes

The header comment of this file says “NOT run” because it was written before the run. The run record is the 2026-11-06 23:23 UTC entry of PREREG-ADDENDUM.md.

-- c_h1b_sweep_clusters.sql  (lane h1b-exchange, phase 1a: written and dry-run only, NOT run)
-- Sweep-detection pass for the deposit-address clustering disclosed in PREREG-ADDENDUM.md
-- ("accounts that receive from many users and sweep to a single account").
-- COUNT-BASED and args-free, so it reads only block_date, action_kind and the two account columns
-- (~24 GB for 90 days instead of ~262 GB with args). It is a cheap preview to review cluster structure
-- and thresholds BEFORE a_h1b_native_flows.sql runs. a_*.sql re-derives the same clusters with
-- amount-based rules inside its own scan, so the labelled set used for H1b comes from a_*.sql only.
--
-- WINDOW (edit here only): block_date BETWEEN '2026-08-07' AND '2026-11-04'
--
-- Deposit-like (count version of a_*.sql D-rules):
--   C1 >= 1 incoming transfer; C2 >= 1 outgoing transfer; C3 >= 90% of outgoing transfers go to one
--   destination; C4 <= 3 distinct destinations; C5 not a named (tier-1) account.
-- Hub = that destination. "Many users" is applied at the cluster level: a hub with fan-in >= 25
-- deposit-like accounts (H1), whose deposit-like accounts together have many distinct senders.
-- A hub is exchange-linked if it is a named account, or (H2, count version) >= 80% of its outgoing
-- transfers go to named accounts.
--
-- Output, column `leg`:
--   hub        account, n=fan-in (deposit-like accounts), n2=distinct senders into those accounts,
--              n3=hub outgoing transfers, n4=of which to named accounts, exchange (named or via H2),
--              is_named; top 1000 hubs with fan-in >= 25, by fan-in
--   named      per named account: deposit-like fan-in (n), distinct senders behind it (n2)
--   qa         totals
WITH named AS (
  SELECT exchange, account FROM UNNEST([
    -- GENERATED from exchange_accounts.json (40 accounts, all with a cited source); do not hand-edit
    STRUCT('binance' AS exchange, '10da3e6516672e0317d9c20e0bf89018271b18c5e3b01ac7b246b2417636a57b' AS account),
    ('binance', '1fc0d96bc0304bfaa1672d2ee84bfeed86ed2db1bdccedab95fa9792a4438a24'),
    ('binance', '27ddc83845172d5ee380af7ba6bcc524145892ff0b91a6078e9ae6d26655e56a'),
    ('binance', '451913e633c72fb951effe076d3bd2977e3f08083dcf6c87fa89992b0d437c5c'),
    ('binance', '56203c5b21b828175fa9c1fd4161ecaca76de9a1f6008935eeb9b4d6dc821a22'),
    ('binance', '5c33c6218d47e00ef229f60da78d0897e1ee9665312550b8afd5f9c7bc6957d2'),
    ('binance', '7747991786f445efb658b69857eadc7a57b6b475beec26ed14da8bc35bb2b5b6'),
    ('binance', '7e6e17fcb8e8e6a22ecd47bbd1b58b1af3582b97bbfd4a8d974bb9c266fa282b'),
    ('binance', '9c484fa5d2d069569ba063fc555c34e621ccd88fdbb0295fc79bad232621c5c1'),
    ('binance', 'b8caf00f8f925cc7b3925def6db361974403082ac7e7710b8342e0b20ac496e9'),
    ('binance', 'bc2fa68aa5d9a0d4e75fbe5659369aa13e1bccf7cabf81ac5d007ae0e51fcac3'),
    ('binance', 'binance1.near'),
    ('binance', 'binancecold3.near'),
    ('binance', 'c6f10c6993a97c90e34ce60c5ea3ccb4915cf731daff0e7a2e5d93ebc879cc74'),
    ('binance', 'ce766fc85f14b52d177bb0620a3be19585783644282b16ff3cfe3f4f699ece03'),
    ('binance', 'd04204b6591fefb973a8ed60929f8211af89ee38020da9faf905acdc7a320063'),
    ('binance', 'e1074e251c7350b8a4480816fffd897b727011df579e04cc19f890fd48fd8830'),
    ('binance', 'e1a70d1d2b8df95e0742c5aa18eb9089d84d5365fead073ac77d4c115cf3e264'),
    ('binance', 'e37e1cf6cd9c8601881799e531c958cd0ca01c734a6349aa88a23489c4258d05'),
    ('bitfinex', '383e50ea1a754ed3acd0d59116f221add87adb82559f31ca6d377f058fe83375'),
    ('bitfinex', '965c8b57b7f36fe9a40ce6188d444ca78708e4d83843b108f7f53d0fe5332076'),
    ('bitget', '241754260760e04e3a90acf27b1c54296b81e52a3b21fab8347ae88066946092'),
    ('bitget', '454e9a19b4552d08132efb9db354f8cdb1ceb155d8c2c9806f6cb15d947187cf'),
    ('gate', '0d584a4cbbfd9a4878d816512894e65918e54fae13df39a6f520fc90caea2fb0'),
    ('gate', 'f857de8a2a882488235eda61d3f41c4a60591d7f8daec1299ec0f20426a4cc3f'),
    ('gate', 'e10e284823bc0728f1850486fd4ccd5546249140e96823ac09f96b30363cd251'),
    ('gate', 'bc02e51d5f4c03611ef28d8fdbdba01b237f5a870fad7670d0a17a1a14934b97'),
    ('kucoin', 'kucoinc.near'),
    ('kucoin', 'e589457354361489a89039b8be6737cbc2db4d13919b6ccf23889a60f3b0d8f3'),
    ('kucoin', '7b865db190b966fe6ea30d0e7cc44ce42c4ea4f159a4b0b937122f166fc3ae28'),
    ('mexc', 'dba256d942a6fbfef9c8d42a2960f89a1f6dcc1e8490c7531d89a470d1d00405'),
    ('swissborg', 'dc6b4c8821dbe652b763e3bfadfea548137b29b97408c8b411ad72acff94e63f'),
    ('swissborg', '1c0dc521827821f1695538ff9312df15f32837bbfe95bc937f9faaafd4125552'),
    ('swissborg', '9b23bfd45a028e7a28326007b221cf8bd8b288630dde5ca714a0524f4865db89'),
    ('swissborg', '034e29f9703726c1f7b955fa5f7b16f6293adec615f668a73bc3b3b0255392df'),
    ('swissborg', 'c298ef5c3754dbcb6c23b481b514641f91d46845a256be4fd6ad742d5f3c251c'),
    ('flipster', 'd09904357488c186e9105396dc32f1a1180bf9870a09c037b3282372e337e770'),
    ('gate_us', '679760352e80fca56d416fdbe8c9e060ed96a5a2c7b4bb5add51f99a08fd8afe'),
    ('gate_us', 'c2566b91e059eb97e2acaa57fe1647db65970fe43f50a7264483d717737f2348'),
    ('bitlo', '6ab1742337f2734a9da8bc75091c0a4558280adc951be7db04feb4c1cea0edc1')
  ])
),
t AS (
  SELECT receipt_predecessor_account_id AS sender, receipt_receiver_account_id AS receiver
  FROM `bigquery-public-data.crypto_near_mainnet_us.receipt_actions`
  WHERE block_date BETWEEN '2026-08-07' AND '2026-11-04'
    AND action_kind = 'TRANSFER'
    AND receipt_predecessor_account_id != 'system'
    AND receipt_predecessor_account_id != receipt_receiver_account_id
),
e AS (SELECT sender, receiver, COUNT(*) AS n FROM t GROUP BY sender, receiver),
acct_in AS (SELECT receiver AS acct, SUM(n) AS in_n, COUNT(*) AS n_senders FROM e GROUP BY receiver),
acct_out AS (
  SELECT sender AS acct, SUM(n) AS out_n, COUNT(*) AS n_dests,
         ARRAY_AGG(STRUCT(receiver AS dest, n AS n) ORDER BY n DESC LIMIT 1)[OFFSET(0)] AS top
  FROM e GROUP BY sender
),
dep AS (
  SELECT o.acct, o.top.dest AS dest, i.n_senders
  FROM acct_out o JOIN acct_in i USING (acct)
  WHERE i.in_n >= 1 AND o.out_n >= 1
    AND o.top.n >= 0.9 * o.out_n
    AND o.n_dests <= 3
    AND o.acct NOT IN (SELECT account FROM named)
),
hubs AS (
  SELECT dest AS hub, COUNT(*) AS n_dep, SUM(n_senders) AS dep_senders
  FROM dep GROUP BY dest
),
hub_to_named AS (
  SELECT e.sender AS hub, SUM(e.n) AS n_named,
         ARRAY_AGG(STRUCT(nm.exchange, e.n) ORDER BY e.n DESC LIMIT 1)[OFFSET(0)].exchange AS exchange
  FROM e JOIN named nm ON e.receiver = nm.account
  WHERE e.sender IN (SELECT hub FROM hubs WHERE n_dep >= 25)
  GROUP BY e.sender
)
SELECT 'hub' AS leg, h.hub AS account, h.n_dep AS n, h.dep_senders AS n2, o.out_n AS n3,
       hn.n_named AS n4, COALESCE(nm.exchange, hn.exchange) AS exchange, nm.account IS NOT NULL AS is_named
FROM (SELECT * FROM hubs WHERE n_dep >= 25 ORDER BY n_dep DESC LIMIT 1000) h
LEFT JOIN acct_out o ON o.acct = h.hub
LEFT JOIN hub_to_named hn USING (hub)
LEFT JOIN named nm ON nm.account = h.hub
UNION ALL
SELECT 'named', nm.account, COALESCE(h.n_dep, 0), h.dep_senders, NULL, NULL, nm.exchange, TRUE
FROM named nm LEFT JOIN hubs h ON h.hub = nm.account
UNION ALL
SELECT 'qa', 'deposit_like_accounts', COUNT(*), SUM(n_senders), NULL, NULL, NULL, NULL FROM dep
UNION ALL
SELECT 'qa', 'transfers_total', COUNT(*), NULL, NULL, NULL, NULL, NULL FROM t
Data

A table wider than the screen scrolls sideways.

Plotted values
Measure Value Unit
Net exchange inflow, lower bound 4.42 million NEAR
Net exchange inflow, upper bound 152.45 million NEAR
Side: tier 1 only 3.31 million NEAR
Side: upper bound without sourced non-exchange accounts 190.71 million NEAR
Gross issuance, 90 days (the H1b bar) 8.0098 million NEAR
Native NEAR, lower bound 4.42 million NEAR
Native NEAR, upper bound 135.52 million NEAR
Coverage, tiers 1-3 by count (primary) 20.0 %
Coverage, tier 1 by count 10.0 %
Coverage, tiers 1-3 by inflow 24.6 %
Coverage required for a point result 50 %
Figure 19Pre-registered#

Identified buying: 33.48% of exchange inflow at one bound, 0.97% at the other

Identified buying as a share of net exchange inflow, against the 25% bar Bars from zero in percent: identified buying is 33.48 percent of the lower bound of net exchange inflow and 0.97 percent of the upper bound; a reference line marks the 25 percent bar H1c needs at both bounds. Identified buying ÷ net exchange inflow, % 0% 10% 20% 30% 40% Identified buying ÷ lower bound of net exchange inflow Against the lower bound: 33.48% 33.48% Identified buying ÷ upper bound of net exchange inflow Against the upper bound: 0.97% 0.97% H1c’s bar: at least 25% at both bounds
Identified buying as a share of net exchange inflow, against the 25% bar Bars from zero in percent: identified buying is 33.48 percent of the lower bound of net exchange inflow and 0.97 percent of the upper bound; a reference line marks the 25 percent bar H1c needs at both bounds. Identified buying ÷ net exchange inflow, % 0% 10% 20% 30% 40% Identified buying ÷ lower bound of net exchange inflow Against the lower bound: 33.48% 33.48% Identified buying ÷ upper bound of net exchange inflow Against the upper bound: 0.97% 0.97% H1c’s bar: at least 25% at both bounds
Window: 90 days, 2026-08-07 to 2026-11-04 (UTC). Unit: percent.
Identified buying
1.48M NEAR
Lower bound of net inflow
4.42M NEAR
Upper bound of net inflow
152.45M NEAR
Notes and sources

The buyback wallet grew by 1.48M NEAR, 33.48% of the lower bound of net exchange inflow but 0.97% of the upper; H1c needs at least 25% at both bounds, so the labels cannot settle it either.

What it shows: Identified buying, the balance increase of buybacks.multisignature.near between the window’s end-point blocks (1.48M NEAR), as a share of the two net exchange inflow bounds from H1b.

What it does not show: That the buyback wallet’s NEAR came from exchanges: NEAR is fungible, so the ratio is a market-wide balance and traces no individual coins.

  • With label coverage below 50%, H1c is confirmed only if it reaches at least 25% at both bounds. It clears the bar against the lower bound and falls far short against the upper, so it stays unsettled; it inherits every limit of H1b, including the 20.0% label coverage.
  • The balance growth is the pre-registered numerator and all of it is used. 0.97M NEAR of it is delivery from intents.near in the committed escrow table; the other 0.511M NEAR (34.5%) is not, and a read of the chain on 2026-11-08 traces most of it to a DAO transfer from another NEAR revenue wallet (THESIS.md, Limits). It stays unsettled whichever numerator is used.
  • ETF and treasury-company holdings are not part of the test: PREREG.md says they would be reported where they can be measured, and none was measured. The buyback wallet holds its NEAR: none of it has been burned.

Source:

Query

The net exchange inflow bounds in the denominator come from these two BigQuery queries, the same text as in the Query block of the H1b chart; this chart adds one RPC read, below.

sql/h1b_a_native_flows.sql 13,184 bytes

The header comment of this file says “NOT run” because it was written before the run. The run record is the 2026-11-06 23:23 UTC entry of PREREG-ADDENDUM.md.

-- a_h1b_native_flows.sql  (lane h1b-exchange, phase 1a: written and dry-run only, NOT run)
-- PREREG H1b/H1c, native-NEAR leg, plus the top-100 receivers needed for labelled coverage.
-- ONE scan of receipt_actions serves every native leg: labelled flows, coverage list, the amount-based
-- sweep clustering (rules D1-D5, H1-H2 below) and the upper-bound set. CTE `t` is referenced several
-- times; BigQuery bills the referenced columns once (verified by dry run, see dryrun.md).
--
-- WINDOW (edit here only; literal dates because pipeline/bq_run.py passes raw SQL, no --parameter):
--   block_date BETWEEN '2026-08-07' AND '2026-11-04'   (90 days, PREREG "Hypotheses on flows")
--
-- Transfers: action_kind = 'TRANSFER', predecessor != 'system' (gas refunds and refunds of failed
-- transfers), self-transfers dropped. Amount = args.deposit (yocto -> NEAR). Clustering and the top-100
-- use TRANSFER only (same convention as sql/spike_top_receivers_7d.sql).
-- Side component, same bytes (args and action_kind are already read): FUNCTION_CALL attached deposits
-- (> 0) crossing a set boundary, reported with kind = 'fcall_deposit' and NOT mixed into kind =
-- 'transfer'. Reason: an exchange restaking via deposit_and_stake is a FunctionCall (invisible to the
-- transfer leg) while the matching pool withdrawal arrives as a Transfer (visible), which would bias
-- net inflow upward. Every flow row also carries cp = counterparty class (pool | intents | wrap | other);
-- cp=wrap marks near_deposit wraps (NEAR -> wNEAR at wrap.near), which are a change of form, not an exit.
--
-- Labelled sets, nested; every rule is fixed here before the query runs:
--   tier 1  named accounts from exchange_accounts.json (cited; generated block below).
--   tier 2  deposit-like accounts whose sweep destination is a tier-1 account. Deposit-like (D1-D5):
--           D1 inflow >= 1 NEAR; D2 0.9 <= outflow/inflow <= 1.5; D3 top destination >= 90% of outflow;
--           D4 <= 3 distinct destinations; D5 not itself tier 1.
--   tier 3  unlabelled hubs with fan-in >= 25 deposit-like accounts (H1) that send >= 80% of their
--           outflow to tier-1 accounts (H2), plus the deposit-like accounts sweeping into them.
--   tier 4  (upper bound only) top-100 receivers by gross inflow that are not in tiers 1-3.
--   Exchange name of a tier-2/3 account = exchange of the tier-1 account it (or its hub) sweeps to.
-- Level L set = tiers <= L. Net exchange inflow(L) = transfers from outside set(L) into set(L) minus
-- transfers from set(L) to outside. Transfers inside the set (deposit->hot sweeps, hot->cold,
-- exchange->exchange) cancel by construction.
--   lower bound (PREREG "0% of unlabelled is exchange-bound") = level 1, 2 or 3 (report all three)
--   upper bound (PREREG "100%")                                = level 4
--
-- Output: one table, column `leg`:
--   flow    day, lvl, direction (in|out), exchange, near, n, note='kind=<transfer|fcall_deposit>;cp=<pool|intents|wrap|other>'
--   top100  rk, account, tier, exchange, near=gross inflow, near2=gross outflow, n=in transfers,
--           n2=distinct senders, note=deposit_like|hub|NULL              (labelled coverage)
--   hub     account, n=fan-in of deposit-like accounts, near=swept in, near2=sent to tier 1,
--           tier, exchange (top 500 by swept)                            (clusters for review)
--   member  account, tier, exchange, near=inflow, near2=outflow (tiers 2-3; feeds b_*.sql lists)
--   qa      note=metric, near, n
WITH named AS (
  SELECT exchange, account FROM UNNEST([
    -- GENERATED from exchange_accounts.json (40 accounts, all with a cited source); do not hand-edit
    STRUCT('binance' AS exchange, '10da3e6516672e0317d9c20e0bf89018271b18c5e3b01ac7b246b2417636a57b' AS account),
    ('binance', '1fc0d96bc0304bfaa1672d2ee84bfeed86ed2db1bdccedab95fa9792a4438a24'),
    ('binance', '27ddc83845172d5ee380af7ba6bcc524145892ff0b91a6078e9ae6d26655e56a'),
    ('binance', '451913e633c72fb951effe076d3bd2977e3f08083dcf6c87fa89992b0d437c5c'),
    ('binance', '56203c5b21b828175fa9c1fd4161ecaca76de9a1f6008935eeb9b4d6dc821a22'),
    ('binance', '5c33c6218d47e00ef229f60da78d0897e1ee9665312550b8afd5f9c7bc6957d2'),
    ('binance', '7747991786f445efb658b69857eadc7a57b6b475beec26ed14da8bc35bb2b5b6'),
    ('binance', '7e6e17fcb8e8e6a22ecd47bbd1b58b1af3582b97bbfd4a8d974bb9c266fa282b'),
    ('binance', '9c484fa5d2d069569ba063fc555c34e621ccd88fdbb0295fc79bad232621c5c1'),
    ('binance', 'b8caf00f8f925cc7b3925def6db361974403082ac7e7710b8342e0b20ac496e9'),
    ('binance', 'bc2fa68aa5d9a0d4e75fbe5659369aa13e1bccf7cabf81ac5d007ae0e51fcac3'),
    ('binance', 'binance1.near'),
    ('binance', 'binancecold3.near'),
    ('binance', 'c6f10c6993a97c90e34ce60c5ea3ccb4915cf731daff0e7a2e5d93ebc879cc74'),
    ('binance', 'ce766fc85f14b52d177bb0620a3be19585783644282b16ff3cfe3f4f699ece03'),
    ('binance', 'd04204b6591fefb973a8ed60929f8211af89ee38020da9faf905acdc7a320063'),
    ('binance', 'e1074e251c7350b8a4480816fffd897b727011df579e04cc19f890fd48fd8830'),
    ('binance', 'e1a70d1d2b8df95e0742c5aa18eb9089d84d5365fead073ac77d4c115cf3e264'),
    ('binance', 'e37e1cf6cd9c8601881799e531c958cd0ca01c734a6349aa88a23489c4258d05'),
    ('bitfinex', '383e50ea1a754ed3acd0d59116f221add87adb82559f31ca6d377f058fe83375'),
    ('bitfinex', '965c8b57b7f36fe9a40ce6188d444ca78708e4d83843b108f7f53d0fe5332076'),
    ('bitget', '241754260760e04e3a90acf27b1c54296b81e52a3b21fab8347ae88066946092'),
    ('bitget', '454e9a19b4552d08132efb9db354f8cdb1ceb155d8c2c9806f6cb15d947187cf'),
    ('gate', '0d584a4cbbfd9a4878d816512894e65918e54fae13df39a6f520fc90caea2fb0'),
    ('gate', 'f857de8a2a882488235eda61d3f41c4a60591d7f8daec1299ec0f20426a4cc3f'),
    ('gate', 'e10e284823bc0728f1850486fd4ccd5546249140e96823ac09f96b30363cd251'),
    ('gate', 'bc02e51d5f4c03611ef28d8fdbdba01b237f5a870fad7670d0a17a1a14934b97'),
    ('kucoin', 'kucoinc.near'),
    ('kucoin', 'e589457354361489a89039b8be6737cbc2db4d13919b6ccf23889a60f3b0d8f3'),
    ('kucoin', '7b865db190b966fe6ea30d0e7cc44ce42c4ea4f159a4b0b937122f166fc3ae28'),
    ('mexc', 'dba256d942a6fbfef9c8d42a2960f89a1f6dcc1e8490c7531d89a470d1d00405'),
    ('swissborg', 'dc6b4c8821dbe652b763e3bfadfea548137b29b97408c8b411ad72acff94e63f'),
    ('swissborg', '1c0dc521827821f1695538ff9312df15f32837bbfe95bc937f9faaafd4125552'),
    ('swissborg', '9b23bfd45a028e7a28326007b221cf8bd8b288630dde5ca714a0524f4865db89'),
    ('swissborg', '034e29f9703726c1f7b955fa5f7b16f6293adec615f668a73bc3b3b0255392df'),
    ('swissborg', 'c298ef5c3754dbcb6c23b481b514641f91d46845a256be4fd6ad742d5f3c251c'),
    ('flipster', 'd09904357488c186e9105396dc32f1a1180bf9870a09c037b3282372e337e770'),
    ('gate_us', '679760352e80fca56d416fdbe8c9e060ed96a5a2c7b4bb5add51f99a08fd8afe'),
    ('gate_us', 'c2566b91e059eb97e2acaa57fe1647db65970fe43f50a7264483d717737f2348'),
    ('bitlo', '6ab1742337f2734a9da8bc75091c0a4558280adc951be7db04feb4c1cea0edc1')
  ])
),
t0 AS (
  SELECT block_date AS day, action_kind AS kind,
         receipt_predecessor_account_id AS sender,
         receipt_receiver_account_id AS receiver,
         args
  FROM `bigquery-public-data.crypto_near_mainnet_us.receipt_actions`
  WHERE block_date BETWEEN '2026-08-07' AND '2026-11-04'
    AND action_kind IN ('TRANSFER', 'FUNCTION_CALL')
    AND receipt_predecessor_account_id != 'system'
    AND receipt_predecessor_account_id != receipt_receiver_account_id
),
t AS (
  SELECT day, sender, receiver, CAST(JSON_VALUE(args, '$.deposit') AS BIGNUMERIC) / 1e24 AS near
  FROM t0 WHERE kind = 'TRANSFER'
),
e AS (SELECT sender, receiver, SUM(near) AS near, COUNT(*) AS n FROM t GROUP BY sender, receiver),
acct_in AS (
  SELECT receiver AS acct, SUM(near) AS in_near, SUM(n) AS in_n, COUNT(*) AS n_senders
  FROM e GROUP BY receiver
),
acct_out AS (
  SELECT sender AS acct, SUM(near) AS out_near, SUM(n) AS out_n, COUNT(*) AS n_dests,
         ARRAY_AGG(STRUCT(receiver AS dest, near AS near) ORDER BY near DESC LIMIT 1)[OFFSET(0)] AS top
  FROM e GROUP BY sender
),
dep AS (  -- deposit-like accounts, rules D1-D5
  SELECT o.acct, o.top.dest AS dest, i.in_near, o.out_near, i.n_senders
  FROM acct_out o JOIN acct_in i USING (acct)
  WHERE i.in_near >= 1
    AND o.out_near BETWEEN 0.9 * i.in_near AND 1.5 * i.in_near
    AND o.top.near >= 0.9 * o.out_near
    AND o.n_dests <= 3
    AND o.acct NOT IN (SELECT account FROM named)
),
hubs AS (
  SELECT dest AS hub, COUNT(*) AS n_dep, SUM(out_near) AS swept
  FROM dep GROUP BY dest
),
hub_to_named AS (
  SELECT e.sender AS hub, nm.exchange, SUM(e.near) AS near
  FROM e JOIN named nm ON e.receiver = nm.account
  WHERE e.sender IN (SELECT hub FROM hubs WHERE n_dep >= 25)
  GROUP BY e.sender, nm.exchange
),
hub_named AS (
  SELECT hub, SUM(near) AS to_named,
         ARRAY_AGG(STRUCT(exchange, near) ORDER BY near DESC LIMIT 1)[OFFSET(0)].exchange AS exchange
  FROM hub_to_named GROUP BY hub
),
hub3 AS (  -- tier-3 hubs, rules H1-H2
  SELECT h.hub, hn.exchange
  FROM hubs h JOIN hub_named hn USING (hub) JOIN acct_out o ON o.acct = h.hub
  WHERE h.n_dep >= 25
    AND h.hub NOT IN (SELECT account FROM named)
    AND hn.to_named >= 0.8 * o.out_near
),
mem_raw AS (
  SELECT account AS acct, 1 AS tier, exchange FROM named
  UNION ALL SELECT d.acct, 2, nm.exchange FROM dep d JOIN named nm ON d.dest = nm.account
  UNION ALL SELECT hub, 3, exchange FROM hub3
  UNION ALL SELECT d.acct, 3, h.exchange FROM dep d JOIN hub3 h ON d.dest = h.hub
),
mem AS (
  SELECT acct, MIN(tier) AS tier,
         ARRAY_AGG(exchange ORDER BY tier LIMIT 1)[OFFSET(0)] AS exchange
  FROM mem_raw GROUP BY acct
),
top100 AS (
  SELECT acct, in_near, in_n, n_senders, ROW_NUMBER() OVER (ORDER BY in_near DESC) AS rk
  FROM (SELECT * FROM acct_in ORDER BY in_near DESC LIMIT 100)
),
mem4 AS (
  SELECT acct, tier, exchange FROM mem
  UNION ALL
  SELECT p.acct, 4, CONCAT('top100:', p.acct) FROM top100 p LEFT JOIN mem m USING (acct) WHERE m.acct IS NULL
),
tf0 AS (  -- boundary candidates first (cheap join), then parse FunctionCall deposits only for those
  SELECT t0.day, LOWER(t0.kind) AS kind, t0.sender, t0.receiver, t0.args,
         s.tier AS s_tier, s.exchange AS s_ex, r.tier AS r_tier, r.exchange AS r_ex
  FROM t0
  LEFT JOIN mem4 s ON t0.sender = s.acct
  LEFT JOIN mem4 r ON t0.receiver = r.acct
  WHERE s.acct IS NOT NULL OR r.acct IS NOT NULL
),
tf AS (
  SELECT day, IF(kind = 'transfer', 'transfer', 'fcall_deposit') AS kind, near, s_tier, s_ex, r_tier, r_ex,
         CASE WHEN cp LIKE '%.poolv1.near' OR cp LIKE '%.pool.near' THEN 'pool'
              WHEN cp = 'intents.near' THEN 'intents'
              WHEN cp = 'wrap.near' THEN 'wrap' ELSE 'other' END AS cp_in,
         CASE WHEN cr LIKE '%.poolv1.near' OR cr LIKE '%.pool.near' THEN 'pool'
              WHEN cr = 'intents.near' THEN 'intents'
              WHEN cr = 'wrap.near' THEN 'wrap' ELSE 'other' END AS cp_out
  FROM (SELECT *, sender AS cp, receiver AS cr,
               CAST(JSON_VALUE(args, '$.deposit') AS BIGNUMERIC) / 1e24 AS near FROM tf0)
  WHERE near > 0
),
flow AS (
  SELECT day, lvl, 'in' AS direction, r_ex AS exchange, kind, cp_in AS cp, SUM(near) AS near, COUNT(*) AS n
  FROM tf, UNNEST([1, 2, 3, 4]) AS lvl
  WHERE r_tier <= lvl AND (s_tier IS NULL OR s_tier > lvl)
  GROUP BY day, lvl, r_ex, kind, cp_in
  UNION ALL
  SELECT day, lvl, 'out', s_ex, kind, cp_out, SUM(near), COUNT(*)
  FROM tf, UNNEST([1, 2, 3, 4]) AS lvl
  WHERE s_tier <= lvl AND (r_tier IS NULL OR r_tier > lvl)
  GROUP BY day, lvl, s_ex, kind, cp_out
)
SELECT 'flow' AS leg, day, lvl, CAST(NULL AS INT64) AS rk, CAST(NULL AS STRING) AS account,
       CAST(NULL AS INT64) AS tier, exchange, direction, ROUND(near, 6) AS near,
       CAST(NULL AS BIGNUMERIC) AS near2, n, CAST(NULL AS INT64) AS n2,
       CONCAT('kind=', kind, ';cp=', cp) AS note
FROM flow
UNION ALL
SELECT 'top100', NULL, NULL, p.rk, p.acct, m.tier, m.exchange, NULL, ROUND(p.in_near, 6),
       ROUND(o.out_near, 6), p.in_n, p.n_senders,
       CASE WHEN d.acct IS NOT NULL THEN CONCAT('deposit_like->', d.dest)
            WHEN hb.n_dep >= 25 THEN CONCAT('hub fan-in ', CAST(hb.n_dep AS STRING)) END
FROM top100 p LEFT JOIN mem m USING (acct) LEFT JOIN acct_out o USING (acct)
LEFT JOIN dep d USING (acct) LEFT JOIN hubs hb ON hb.hub = p.acct
UNION ALL
SELECT 'hub', NULL, NULL, NULL, h.hub, m.tier, COALESCE(m.exchange, hn.exchange), NULL,
       ROUND(h.swept, 6), ROUND(hn.to_named, 6), h.n_dep, NULL, NULL
FROM (SELECT * FROM hubs WHERE n_dep >= 25 ORDER BY swept DESC LIMIT 500) h
LEFT JOIN hub_named hn USING (hub) LEFT JOIN mem m ON m.acct = h.hub
UNION ALL
SELECT 'member', NULL, NULL, NULL, m.acct, m.tier, m.exchange, NULL, ROUND(i.in_near, 6),
       ROUND(o.out_near, 6), i.in_n, o.out_n, NULL
FROM mem m LEFT JOIN acct_in i USING (acct) LEFT JOIN acct_out o USING (acct)
WHERE m.tier IN (2, 3)
UNION ALL
SELECT 'qa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, ROUND(SUM(near), 6), NULL, COUNT(*),
       COUNTIF(near IS NULL), 'transfers_total (n2 = rows with unparsable deposit)'
FROM t
UNION ALL
SELECT 'qa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, ROUND(SUM(in_near), 6), NULL, COUNT(*), NULL,
       'deposit_like_accounts'
FROM dep

sql/h1b_b_wnear_logs.sql 821,680 bytes

The header comment of this file says “NOT run” because it was written before the run. The run record is the 2026-11-06 23:23 UTC entry of PREREG-ADDENDUM.md.

This file is 821,680 bytes because it inlines the account lists. The page shows it as stored, except that 7 very long lines are cut where marked; the full file is at the link above.

-- b_h1b_wnear_flows_logs.sql  (lane h1b-exchange, phase 1a: written and dry-run only, NOT run)
-- PREREG H1b/H1c wNEAR leg: wrap.near transfers into and out of the labelled exchange sets, from the
-- logs of wrap.near receipts in execution_outcomes (no receipt_actions, no args).
--
-- WINDOW (edit here only): block_date BETWEEN '2026-08-07' AND '2026-11-04'
--
-- IMPORTANT, checked 2026-11-06 by RPC (evidence/wrap_near_tx_6jxE7zxh_logs.json): wrap.near does NOT
-- emit NEP-297 EVENT_JSON logs. It emits the legacy near-contract-standards lines
--   "Transfer <yocto> from <sender> to <receiver>"   (ft_transfer, ft_transfer_call)
--   "Refund <yocto> from <receiver> to <sender>"     (ft_resolve_transfer; a reverse movement)
-- Both are parsed as a movement first-account -> second-account. EVENT_JSON nep141 ft_transfer lines
-- are also parsed, in case the contract is upgraded; each format is kept in its own `fmt` column so a
-- double emission would be visible rather than silently summed. Deposit/Withdraw (wrap/unwrap) lines
-- are ignored: they are not transfers between accounts. Receipts whose status contains FAIL are dropped
-- (status value spelling unverified; see notes.md).
--
-- Labelled sets: identical tiers to a_h1b_native_flows.sql. Tier 1 = named block below (from
-- exchange_accounts.json). Tiers 2-4 are pasted into `extra` from a_*.sql output (legs `member` and
-- `top100` with tier 4) before this query runs; bytes scanned do not depend on the list length.
-- Net wNEAR inflow(L) = movements from outside set(L) into it minus movements out of it.
--
-- Output, column `leg`: flow (day, lvl, direction, exchange, fmt, near, n) and qa (fmt, near, n).
WITH named AS (
  SELECT exchange, account FROM UNNEST([
    -- GENERATED from exchange_accounts.json (40 accounts, all with a cited source); do not hand-edit
    STRUCT('binance' AS exchange, '10da3e6516672e0317d9c20e0bf89018271b18c5e3b01ac7b246b2417636a57b' AS account),
    ('binance', '1fc0d96bc0304bfaa1672d2ee84bfeed86ed2db1bdccedab95fa9792a4438a24'),
    ('binance', '27ddc83845172d5ee380af7ba6bcc524145892ff0b91a6078e9ae6d26655e56a'),
    ('binance', '451913e633c72fb951effe076d3bd2977e3f08083dcf6c87fa89992b0d437c5c'),
    ('binance', '56203c5b21b828175fa9c1fd4161ecaca76de9a1f6008935eeb9b4d6dc821a22'),
    ('binance', '5c33c6218d47e00ef229f60da78d0897e1ee9665312550b8afd5f9c7bc6957d2'),
    ('binance', '7747991786f445efb658b69857eadc7a57b6b475beec26ed14da8bc35bb2b5b6'),
    ('binance', '7e6e17fcb8e8e6a22ecd47bbd1b58b1af3582b97bbfd4a8d974bb9c266fa282b'),
    ('binance', '9c484fa5d2d069569ba063fc555c34e621ccd88fdbb0295fc79bad232621c5c1'),
    ('binance', 'b8caf00f8f925cc7b3925def6db361974403082ac7e7710b8342e0b20ac496e9'),
    ('binance', 'bc2fa68aa5d9a0d4e75fbe5659369aa13e1bccf7cabf81ac5d007ae0e51fcac3'),
    ('binance', 'binance1.near'),
    ('binance', 'binancecold3.near'),
    ('binance', 'c6f10c6993a97c90e34ce60c5ea3ccb4915cf731daff0e7a2e5d93ebc879cc74'),
    ('binance', 'ce766fc85f14b52d177bb0620a3be19585783644282b16ff3cfe3f4f699ece03'),
    ('binance', 'd04204b6591fefb973a8ed60929f8211af89ee38020da9faf905acdc7a320063'),
    ('binance', 'e1074e251c7350b8a4480816fffd897b727011df579e04cc19f890fd48fd8830'),
    ('binance', 'e1a70d1d2b8df95e0742c5aa18eb9089d84d5365fead073ac77d4c115cf3e264'),
    ('binance', 'e37e1cf6cd9c8601881799e531c958cd0ca01c734a6349aa88a23489c4258d05'),
    ('bitfinex', '383e50ea1a754ed3acd0d59116f221add87adb82559f31ca6d377f058fe83375'),
    ('bitfinex', '965c8b57b7f36fe9a40ce6188d444ca78708e4d83843b108f7f53d0fe5332076'),
    ('bitget', '241754260760e04e3a90acf27b1c54296b81e52a3b21fab8347ae88066946092'),
    ('bitget', '454e9a19b4552d08132efb9db354f8cdb1ceb155d8c2c9806f6cb15d947187cf'),
    ('gate', '0d584a4cbbfd9a4878d816512894e65918e54fae13df39a6f520fc90caea2fb0'),
    ('gate', 'f857de8a2a882488235eda61d3f41c4a60591d7f8daec1299ec0f20426a4cc3f'),
    ('gate', 'e10e284823bc0728f1850486fd4ccd5546249140e96823ac09f96b30363cd251'),
    ('gate', 'bc02e51d5f4c03611ef28d8fdbdba01b237f5a870fad7670d0a17a1a14934b97'),
    ('kucoin', 'kucoinc.near'),
    ('kucoin', 'e589457354361489a89039b8be6737cbc2db4d13919b6ccf23889a60f3b0d8f3'),
    ('kucoin', '7b865db190b966fe6ea30d0e7cc44ce42c4ea4f159a4b0b937122f166fc3ae28'),
    ('mexc', 'dba256d942a6fbfef9c8d42a2960f89a1f6dcc1e8490c7531d89a470d1d00405'),
    ('swissborg', 'dc6b4c8821dbe652b763e3bfadfea548137b29b97408c8b411ad72acff94e63f'),
    ('swissborg', '1c0dc521827821f1695538ff9312df15f32837bbfe95bc937f9faaafd4125552'),
    ('swissborg', '9b23bfd45a028e7a28326007b221cf8bd8b288630dde5ca714a0524f4865db89'),
    ('swissborg', '034e29f9703726c1f7b955fa5f7b16f6293adec615f668a73bc3b3b0255392df'),
    ('swissborg', 'c298ef5c3754dbcb6c23b481b514641f91d46845a256be4fd6ad742d5f3c251c'),
    ('flipster', 'd09904357488c186e9105396dc32f1a1180bf9870a09c037b3282372e337e770'),
    ('gate_us', '679760352e80fca56d416fdbe8c9e060ed96a5a2c7b4bb5add51f99a08fd8afe'),
    ('gate_us', 'c2566b91e059eb97e2acaa57fe1647db65970fe43f50a7264483d717737f2348'),
    ('bitlo', '6ab1742337f2734a9da8bc75091c0a4558280adc951be7db04feb4c1cea0edc1')
  ])
),
extra AS (  -- GENERATED from a_h1b_native_flows.sql output before running (tiers 2, 3, 4)
  SELECT acct, 2 AS tier, 'binance' AS exchange FROM UNNEST(SPLIT('000d2f2a1b99d1aa1b9f21b50557d31b70edb450870228585835aa7a626b0a6c,001b49542d78e51a775140a1f736 [... 503,852 characters omitted on this line ...] fe84cc5265f31f50551850dada293a329e2e5e1bc02305413daecc7de7482d40', ',')) AS acct
  UNION ALL
  SELECT acct, 2 AS tier, 'bitfinex' AS exchange FROM UNNEST(SPLIT('0718e9895b09f99790e9074388ace6bd358296dad876e68da0a4924e0be86c9d,074d0e74eb31a8ba408e5890c69 [... 1,143 characters omitted on this line ...] ebfaeb321654cb024b1453e8fe5fd78d11c0a28aae137382a95a1893c3025453', ',')) AS acct
  UNION ALL
  SELECT acct, 2 AS tier, 'bitget' AS exchange FROM UNNEST(SPLIT('0008e8cb757ab9c83d6c37cc0739c48ca20d1e1c37951d486577aff5539b01f9,00374e4a5fe4653236697578e9515 [... 102,736 characters omitted on this line ...] fff0d3e88fe782117e06b780b41afc6a07d1b2b08ddb52facd861538cbaf9276', ',')) AS acct
  UNION ALL
  SELECT acct, 2 AS tier, 'gate' AS exchange FROM UNNEST(SPLIT('0011ae87e1f389ac14b05009c1ba70d64c5b7facd62c1e5bd77b11bfbbee70b1,0068b75d43842163f2aa522e6078957 [... 81,934 characters omitted on this line ...] fff72ef842b42a0b252e15b20efb3411e6fdd80b0fc58341062b60b0d80441d3', ',')) AS acct
  UNION ALL
  SELECT acct, 2 AS tier, 'gate_us' AS exchange FROM UNNEST(SPLIT('4701c00b410394005970f2da9b99f1627cfb53438a39ec9425ac3ff63786560e,8ec297bbc9484f058f72a00a366a30a029b40e89f4ee54dd8c138cc453399633', ',')) AS acct
  UNION ALL
  SELECT acct, 2 AS tier, 'kucoin' AS exchange FROM UNNEST(SPLIT('009a227dab6a137682f24d0f1da2f5468dbe8a89b0d4c703e1c492da08046a14,00c7fff7eb98fc660d84d2420f852 [... 72,901 characters omitted on this line ...] fff56b7d6cae37bb1f276f9291e7b1b1befaa9011917881772c813d3094df857', ',')) AS acct
  UNION ALL
  SELECT acct, 2 AS tier, 'swissborg' AS exchange FROM UNNEST(SPLIT('005f21bdaef70adc7e0a336d1ca474a9b98f566945bb1ff0260db2df3f42310e,058042c3b327eadf63fa26b59c [... 10,634 characters omitted on this line ...] f9b7dbf962c91d02cf5ff0913aaf037c2b6808545b719bf7337c7818f7872775', ',')) AS acct
  UNION ALL
  SELECT acct, 3 AS tier, 'binance' AS exchange FROM UNNEST(SPLIT('007500383c8196a15c747c53a217a0e1ab517cb42f7d70ab6cd07be9d030bce6,0076c0306f65312bc8c4ea7e0a22 [... 27,713 characters omitted on this line ...] ffb8bcf74698164228e61e6e7cd4c855d73ddc74154713af5bf0dbf0dafcb5cd', ',')) AS acct
  UNION ALL
  SELECT acct, tier, exchange FROM UNNEST(ARRAY<STRUCT<acct STRING, tier INT64, exchange STRING>>[
    ('52435fe912307fb3a088b8b8f3882781762fc1f0a404e8579c7fb1a964362c8d', 4, 'top100:52435fe912307fb3a088b8b8f3882781762fc1f0a404e8579c7fb1a964362c8d'),
    ('466222f1d229ca75ae9b4c82202e0e0b2fc3f6bdbdbac3704e8bf1808baa6093', 4, 'top100:466222f1d229ca75ae9b4c82202e0e0b2fc3f6bdbdbac3704e8bf1808baa6093'),
    ('2874f85cf17404b4c43ad4e869ff0c7ef16a2b3ddea6c01033fedc55ba6d4eac', 4, 'top100:2874f85cf17404b4c43ad4e869ff0c7ef16a2b3ddea6c01033fedc55ba6d4eac'),
    ('bridge-mng.near', 4, 'top100:bridge-mng.near'),
    ('d549d25ebc8dcd705ee1aac7d961fc31b07fa52e8d59ba56ddd788f09d6cec46', 4, 'top100:d549d25ebc8dcd705ee1aac7d961fc31b07fa52e8d59ba56ddd788f09d6cec46'),
    ('940ef3f4f1e2d72b2036c685e5db7ff38ea0f84cce9b1c538bb1db1bb6678950', 4, 'top100:940ef3f4f1e2d72b2036c685e5db7ff38ea0f84cce9b1c538bb1db1bb6678950'),
    ('intents.near', 4, 'top100:intents.near'),
    ('717f12dd9354b83dac4c80b60dbc15712baac97834d63ccf545c53db57d9eeb3', 4, 'top100:717f12dd9354b83dac4c80b60dbc15712baac97834d63ccf545c53db57d9eeb3'),
    ('ccb91e1db61e8d7e1d4ae3e043001140132959a86ee35a548b6563a46284a6ea', 4, 'top100:ccb91e1db61e8d7e1d4ae3e043001140132959a86ee35a548b6563a46284a6ea'),
    ('30d6205b89e02d2c34ade165ae9705f8d9e80d0e304061cb10b8e56c8e703f62', 4, 'top100:30d6205b89e02d2c34ade165ae9705f8d9e80d0e304061cb10b8e56c8e703f62'),
    ('nfendowment03.near', 4, 'top100:nfendowment03.near'),
    ('498eee3c286d618675185ca234c288dce8f30aa39676f38df2f556a0b074cc3d', 4, 'top100:498eee3c286d618675185ca234c288dce8f30aa39676f38df2f556a0b074cc3d'),
    ('7875aef71e16a1c4ec9855a4ad77c0b533d84ec340110f79b652c9b49d7444aa', 4, 'top100:7875aef71e16a1c4ec9855a4ad77c0b533d84ec340110f79b652c9b49d7444aa'),
    ('1e6ef8464ce09f96c6fc22583ead00fa0b65119128daa9732366d2a2e856e960', 4, 'top100:1e6ef8464ce09f96c6fc22583ead00fa0b65119128daa9732366d2a2e856e960'),
    ('f1bb20659f00960c4a54077f00ad4316b01eddc13d2050f6ebc190bb64492e6a', 4, 'top100:f1bb20659f00960c4a54077f00ad4316b01eddc13d2050f6ebc190bb64492e6a'),
    ('1244d552459d7230bdaf267c1d09a296282dc85251958434e670d9b9d561fac7', 4, 'top100:1244d552459d7230bdaf267c1d09a296282dc85251958434e670d9b9d561fac7'),
    ('42c3b82b53f233d0f044cb995451385d359297f94369b99215cf84d1c2b32ca4', 4, 'top100:42c3b82b53f233d0f044cb995451385d359297f94369b99215cf84d1c2b32ca4'),
    ('3e93b62aec7f1275a2eb6a0145d1d6406fd94f6c44f7fd705711f8139b5d25f9', 4, 'top100:3e93b62aec7f1275a2eb6a0145d1d6406fd94f6c44f7fd705711f8139b5d25f9'),
    ('29d0438761b61f5a9a6fb9d736f9c4a194d85e80535d04d80dda568eb8ed7603', 4, 'top100:29d0438761b61f5a9a6fb9d736f9c4a194d85e80535d04d80dda568eb8ed7603'),
    ('2b8cc04e26f38bcbd600a9a1e0991edb7040037eb82f3bf553978284c33f35d3', 4, 'top100:2b8cc04e26f38bcbd600a9a1e0991edb7040037eb82f3bf553978284c33f35d3'),
    ('d2f0f590b1077d6ea63c37fd5c558bd5d3c455ac78ced8e2a81395a24407c22a', 4, 'top100:d2f0f590b1077d6ea63c37fd5c558bd5d3c455ac78ced8e2a81395a24407c22a'),
    ('bf44259660eb5dd66a0a39b0addf94c5724359a38e5caa4acf7be7a832a1f8b8', 4, 'top100:bf44259660eb5dd66a0a39b0addf94c5724359a38e5caa4acf7be7a832a1f8b8'),
    ('opgran01.near', 4, 'top100:opgran01.near'),
    ('23ced4300a4bf282bf94a4fcd2b0af32ad291ef531f544f6d7d283e8ff1e684a', 4, 'top100:23ced4300a4bf282bf94a4fcd2b0af32ad291ef531f544f6d7d283e8ff1e684a'),
    ('5754ff26eaa951cd814f657c840059086da32ecd600efc58106028ed6b6b3559', 4, 'top100:5754ff26eaa951cd814f657c840059086da32ecd600efc58106028ed6b6b3559'),
    ('25ab96ddd0d9a8e0ab48b45c2ef7473a83c4ff7e49239b46613b3d688e024731', 4, 'top100:25ab96ddd0d9a8e0ab48b45c2ef7473a83c4ff7e49239b46613b3d688e024731'),
    ('meta-pool.near', 4, 'top100:meta-pool.near'),
    ('ae1b2d06cee9353fba5ce28827f4cccbbf6e0dc161dfc3b154f71c5902c3fcca', 4, 'top100:ae1b2d06cee9353fba5ce28827f4cccbbf6e0dc161dfc3b154f71c5902c3fcca'),
    ('e672fced9d9e5c3a0d9afbca6f50b957e29f11a3fd0004cc833bb26882c653e2', 4, 'top100:e672fced9d9e5c3a0d9afbca6f50b957e29f11a3fd0004cc833bb26882c653e2'),
    ('ac79b2cdc19e17428057d600bf11892d6b47cb709d6b383a03ec1bf637741958', 4, 'top100:ac79b2cdc19e17428057d600bf11892d6b47cb709d6b383a03ec1bf637741958'),
    ('f9cdfdf61274ce83833a82a05f261417f920f11110769113741d9c4c1acd2c96', 4, 'top100:f9cdfdf61274ce83833a82a05f261417f920f11110769113741d9c4c1acd2c96'),
    ('53aae097294e229eff16b742fd7af62ac6dbae6055fa49a35759c74abb537d0c', 4, 'top100:53aae097294e229eff16b742fd7af62ac6dbae6055fa49a35759c74abb537d0c'),
    ('60142764c4cd3239d7d6e1973e87073f9d25773af225a74b22f3f9c9761fe8a5', 4, 'top100:60142764c4cd3239d7d6e1973e87073f9d25773af225a74b22f3f9c9761fe8a5'),
    ('ec3ba010379f286553bb1ec59891f73b3aa67e1a7a890d394e36db5c6e4598fc', 4, 'top100:ec3ba010379f286553bb1ec59891f73b3aa67e1a7a890d394e36db5c6e4598fc'),
    ('3c5977c54569c420a6f4f9d5244c0cde7e0ccb0c5ca347924bc808610d6c77a0', 4, 'top100:3c5977c54569c420a6f4f9d5244c0cde7e0ccb0c5ca347924bc808610d6c77a0'),
    ('eb3fb6501f7247047e94503443dc5f650fe4502e953bc2e6bc3236844baae7c2', 4, 'top100:eb3fb6501f7247047e94503443dc5f650fe4502e953bc2e6bc3236844baae7c2'),
    ('1e74ab0a225c87cf49c5b031f29208195ba5b284fd0fefceaa9e283455686c02', 4, 'top100:1e74ab0a225c87cf49c5b031f29208195ba5b284fd0fefceaa9e283455686c02'),
    ('943ee8c1dd517f34bd8205fc6aecfc1286ee0d11bcd2e473d23f7a4d918748e0', 4, 'top100:943ee8c1dd517f34bd8205fc6aecfc1286ee0d11bcd2e473d23f7a4d918748e0'),
    ('4e6baf302947fe14135a83a63106bf0834e9247eef4aa76690ab4ac334938bfd', 4, 'top100:4e6baf302947fe14135a83a63106bf0834e9247eef4aa76690ab4ac334938bfd'),
    ('nfendowment03.sputnik-dao.near', 4, 'top100:nfendowment03.sputnik-dao.near'),
    ('03793fb37ffb46533e9b8ab6b9c7a1ebdd6d84f6ebc151b8f60ec1754bbcada6', 4, 'top100:03793fb37ffb46533e9b8ab6b9c7a1ebdd6d84f6ebc151b8f60ec1754bbcada6'),
    ('af09768659017107aad46477428f1ca3c267ff8b95d96bb1ab8a272f8df7c8f6', 4, 'top100:af09768659017107aad46477428f1ca3c267ff8b95d96bb1ab8a272f8df7c8f6'),
    ('linear-protocol.near', 4, 'top100:linear-protocol.near'),
    ('d9690f36c742a6b64a1fbd448a121b0e66bcef14c3115b56192766f2d4c3ba06', 4, 'top100:d9690f36c742a6b64a1fbd448a121b0e66bcef14c3115b56192766f2d4c3ba06'),
    ('41cb324d7992338a882038804cf193154d0001b4af1a096bdd36154c0af0ef00', 4, 'top100:41cb324d7992338a882038804cf193154d0001b4af1a096bdd36154c0af0ef00'),
    ('f9e0ff50970bfdee2a59e039f9da76f267bba161e1a9b11dd16a81e8ef702091', 4, 'top100:f9e0ff50970bfdee2a59e039f9da76f267bba161e1a9b11dd16a81e8ef702091'),
    ('2045ea024b1a72afdbe22ef1d95f1dc42ed0e7db3a906ce4319f723477c2dc5a', 4, 'top100:2045ea024b1a72afdbe22ef1d95f1dc42ed0e7db3a906ce4319f723477c2dc5a'),
    ('efd224256518a7cacd209867963276efed302a8e222c013c43f4b1bd369ae5af', 4, 'top100:efd224256518a7cacd209867963276efed302a8e222c013c43f4b1bd369ae5af'),
    ('7cc35ace7b7e8c5f2a23dbcfc0a99bebb4feb9914539d81fd79cdd1feddc9355', 4, 'top100:7cc35ace7b7e8c5f2a23dbcfc0a99bebb4feb9914539d81fd79cdd1feddc9355'),
    ('5b43682c64f3dce763b73d5f5d17a98fe9133d5d2a2dd7d6dc33e5d703c90cbe', 4, 'top100:5b43682c64f3dce763b73d5f5d17a98fe9133d5d2a2dd7d6dc33e5d703c90cbe'),
    ('8e2922ee58ed8f6c5533e1440529155c429f6089cc81ece428193950f05a0263', 4, 'top100:8e2922ee58ed8f6c5533e1440529155c429f6089cc81ece428193950f05a0263'),
    ('91c122a00982c51255ac646e5dc8a47f5a21990e9c4f6bd3d0b74c434d5c9ff1', 4, 'top100:91c122a00982c51255ac646e5dc8a47f5a21990e9c4f6bd3d0b74c434d5c9ff1'),
    ('ce87229986688b80997501765c2f92b8becd8905079f02871598d2cd4785d64c', 4, 'top100:ce87229986688b80997501765c2f92b8becd8905079f02871598d2cd4785d64c'),
    ('closemeat6237.near', 4, 'top100:closemeat6237.near'),
    ('3723636b73c0d56890c57173d45cfd8ea51ac6c6c79c65fcbf79053438cbc1b6', 4, 'top100:3723636b73c0d56890c57173d45cfd8ea51ac6c6c79c65fcbf79053438cbc1b6'),
    ('75b5de8d982c8b6b98013cd0f1cc7558b8705e5b1928c24936ff47bd87312ca5', 4, 'top100:75b5de8d982c8b6b98013cd0f1cc7558b8705e5b1928c24936ff47bd87312ca5'),
    ('c1833ea5a24a38fa80d50506083bca57205326d8dc08da69a954fc2616fd963c', 4, 'top100:c1833ea5a24a38fa80d50506083bca57205326d8dc08da69a954fc2616fd963c'),
    ('8412703ca30a3ba2add00fb3f1a99931d3a4e31957b887d9438400084832c3c6', 4, 'top100:8412703ca30a3ba2add00fb3f1a99931d3a4e31957b887d9438400084832c3c6'),
    ('903e98523d70dec00e17e153726047a330521ae1c3456f646629134109d0f17c', 4, 'top100:903e98523d70dec00e17e153726047a330521ae1c3456f646629134109d0f17c'),
    ('500dd4de0f75d593a611d0453c8103e30a144ee2131ec985475cd3277f24822b', 4, 'top100:500dd4de0f75d593a611d0453c8103e30a144ee2131ec985475cd3277f24822b'),
    ('e2c58668d0cf3e6f6b43402d5aaa4301aefc9eb12a85df2cb3052992cb029acd', 4, 'top100:e2c58668d0cf3e6f6b43402d5aaa4301aefc9eb12a85df2cb3052992cb029acd'),
    ('308ef8814937fbc72e740b845bcff5fb8c1bc2f5c6a4e7aea780f673bf627703', 4, 'top100:308ef8814937fbc72e740b845bcff5fb8c1bc2f5c6a4e7aea780f673bf627703'),
    ('dclv2.ref-labs.near', 4, 'top100:dclv2.ref-labs.near'),
    ('6e8d9a66c4f74784afc86337a2763873b4599070c7357a7504adb9f21e23cb59', 4, 'top100:6e8d9a66c4f74784afc86337a2763873b4599070c7357a7504adb9f21e23cb59'),
    ('c1ae626298ddaa0fd0cf7b3d416070bf491d7cc5b5fff978318e69f5e099fa13', 4, 'top100:c1ae626298ddaa0fd0cf7b3d416070bf491d7cc5b5fff978318e69f5e099fa13'),
    ('978b2d76a15b5692b47a05b956e285f914d81454c39c608df25af16eb2abc9b4', 4, 'top100:978b2d76a15b5692b47a05b956e285f914d81454c39c608df25af16eb2abc9b4'),
    ('98446b9dd40b9dd365be9d7def69e33b6a3cb790daa95a9b447d64bb3c65d780', 4, 'top100:98446b9dd40b9dd365be9d7def69e33b6a3cb790daa95a9b447d64bb3c65d780'),
    ('45658dff4dacc4d615651388e0b4afd09aa3f60231b722ecc6dbeb46f6ebba3b', 4, 'top100:45658dff4dacc4d615651388e0b4afd09aa3f60231b722ecc6dbeb46f6ebba3b'),
    ('0d96ffd2d1098549c33738d811eb39d08065ffcfa6ac19490b82c431e48db233', 4, 'top100:0d96ffd2d1098549c33738d811eb39d08065ffcfa6ac19490b82c431e48db233'),
    ('423df0a6640e9467769c55a573f15b9ee999dc8970048959c72890abf5cc3a8e', 4, 'top100:423df0a6640e9467769c55a573f15b9ee999dc8970048959c72890abf5cc3a8e'),
    ('1825fca81bb0324279647c943edb78dca118eeb4159adf84f2763e369bdd272e', 4, 'top100:1825fca81bb0324279647c943edb78dca118eeb4159adf84f2763e369bdd272e'),
    ('78e2bf41323b17f275e24f5ce40b6023b443b8aca99e19be5b8dfad570ea21e7', 4, 'top100:78e2bf41323b17f275e24f5ce40b6023b443b8aca99e19be5b8dfad570ea21e7'),
    ('lst-pool.near', 4, 'top100:lst-pool.near'),
    ('88cc2b61cf1f5a8c7508bbe36fbf38ec26e51e7f9b898f66bee1ef5a520fda5a', 4, 'top100:88cc2b61cf1f5a8c7508bbe36fbf38ec26e51e7f9b898f66bee1ef5a520fda5a'),
    ('2380ee9f038cbf102ee807ad476700519cdb05cfb5a39b2d628af6ff8bd5dfe0', 4, 'top100:2380ee9f038cbf102ee807ad476700519cdb05cfb5a39b2d628af6ff8bd5dfe0'),
    ('78f3f9138e7286bab3e69dbf3f8dd2470d410232073c010cdc9d44882b96f292', 4, 'top100:78f3f9138e7286bab3e69dbf3f8dd2470d410232073c010cdc9d44882b96f292'),
    ('c1f4caf77eb54ec89e2f03097cffbdd35fa4186465ebb4bf90960bf23bb6f2a3', 4, 'top100:c1f4caf77eb54ec89e2f03097cffbdd35fa4186465ebb4bf90960bf23bb6f2a3'),
    ('c7f30234b645491fcd2b70a27bfef7b8dba5743ed0feb4e1ca4de08239b7f1c1', 4, 'top100:c7f30234b645491fcd2b70a27bfef7b8dba5743ed0feb4e1ca4de08239b7f1c1'),
    ('bd3b50f1e07389496ba4bb01186dadadeaf2b72c5a68e793b7cbeefd78c9321a', 4, 'top100:bd3b50f1e07389496ba4bb01186dadadeaf2b72c5a68e793b7cbeefd78c9321a'),
    ('crux-solver.near', 4, 'top100:crux-solver.near')
  ])
),
mem AS (
  SELECT acct, MIN(tier) AS tier, ARRAY_AGG(exchange ORDER BY tier LIMIT 1)[OFFSET(0)] AS exchange
  FROM (SELECT account AS acct, 1 AS tier, exchange FROM named UNION ALL SELECT * FROM extra)
  GROUP BY acct
),
lg AS (
  SELECT o.block_date AS day, l.element AS log
  FROM `bigquery-public-data.crypto_near_mainnet_us.execution_outcomes` o, UNNEST(o.logs.list) l
  WHERE o.block_date BETWEEN '2026-08-07' AND '2026-11-04'
    AND o.executor_account_id = 'wrap.near'
    AND o.status NOT LIKE '%FAIL%'
    AND (STARTS_WITH(l.element, 'Transfer ') OR STARTS_WITH(l.element, 'Refund ')
         OR STARTS_WITH(l.element, 'EVENT_JSON:'))
),
mv AS (
  SELECT day, 'legacy' AS fmt,
         CAST(REGEXP_EXTRACT(log, r'^(?:Transfer|Refund) ([0-9]+) from ') AS BIGNUMERIC) / 1e24 AS near,
         REGEXP_EXTRACT(log, r' from (\S+) to ') AS sender,
         REGEXP_EXTRACT(log, r' to (\S+)$') AS receiver
  FROM lg
  WHERE REGEXP_CONTAINS(log, r'^(?:Transfer|Refund) [0-9]+ from \S+ to \S+$')
  UNION ALL
  SELECT day, 'event_json',
         CAST(JSON_VALUE(d, '$.amount') AS BIGNUMERIC) / 1e24,
         JSON_VALUE(d, '$.old_owner_id'), JSON_VALUE(d, '$.new_owner_id')
  FROM lg, UNNEST(JSON_QUERY_ARRAY(SUBSTR(log, 12), '$.data')) d
  WHERE STARTS_WITH(log, 'EVENT_JSON:')
    AND JSON_VALUE(SUBSTR(log, 12), '$.standard') = 'nep141'
    AND JSON_VALUE(SUBSTR(log, 12), '$.event') = 'ft_transfer'
),
tf AS (
  SELECT mv.day, mv.fmt, mv.near, s.tier AS s_tier, s.exchange AS s_ex, r.tier AS r_tier, r.exchange AS r_ex
  FROM mv
  LEFT JOIN mem s ON mv.sender = s.acct
  LEFT JOIN mem r ON mv.receiver = r.acct
  WHERE (s.acct IS NOT NULL OR r.acct IS NOT NULL) AND mv.sender != mv.receiver
),
flow AS (
  SELECT day, lvl, 'in' AS direction, r_ex AS exchange, fmt, SUM(near) AS near, COUNT(*) AS n
  FROM tf, UNNEST([1, 2, 3, 4]) AS lvl
  WHERE r_tier <= lvl AND (s_tier IS NULL OR s_tier > lvl)
  GROUP BY day, lvl, r_ex, fmt
  UNION ALL
  SELECT day, lvl, 'out', s_ex, fmt, SUM(near), COUNT(*)
  FROM tf, UNNEST([1, 2, 3, 4]) AS lvl
  WHERE s_tier <= lvl AND (r_tier IS NULL OR r_tier > lvl)
  GROUP BY day, lvl, s_ex, fmt
)
SELECT 'flow' AS leg, day, lvl, direction, exchange, fmt, ROUND(near, 6) AS near, n FROM flow
UNION ALL
SELECT 'qa', NULL, NULL, NULL, NULL, fmt, ROUND(SUM(near), 6), COUNT(*) FROM mv GROUP BY fmt
RPC call
view_account, account_id buybacks.multisignature.near, block_id 210238033 and 223088015
Endpoint
https://archival-rpc.mainnet.fastnear.com
Data

A table wider than the screen scrolls sideways.

Plotted values
Measure Value Unit
Identified buying: increase in the buyback wallet's balance 1.48 million NEAR
Net exchange inflow, lower bound 4.42 million NEAR
Net exchange inflow, upper bound 152.45 million NEAR
Identified buying ÷ lower bound 33.48 %
Identified buying ÷ upper bound 0.97 %
H1c’s bar 25 %
Figure 20Pre-registered#

Rating rule: no buy or avoid signal

Rating rule inputs: required against observed growth in captured revenue Bars from zero in percent a year: required growth G_req 33.2, or 46.8 without HSP-029; observed growth G_obs 619.0 in USD and 71.4 in NEAR terms. The frozen rule gives no buy or avoid signal. Growth in captured Intents revenue, % a year 0 100 200 300 400 500 600 700 G_req: growth needed for captured revenue to equal net issuance by 2031-11-04 G_req: 33.2%/yr 33.2%/yr G_req without HSP-029's issuance cut G_req without HSP-029: 46.8%/yr 46.8%/yr G_obs in USD: last 180 days against the 180 before, annualized G_obs (USD): 619.0%/yr 619.0%/yr G_obs in NEAR terms (sensitivity) G_obs (NEAR terms): 71.4%/yr 71.4%/yr
Rating rule inputs: required against observed growth in captured revenue Bars from zero in percent a year: required growth G_req 33.2, or 46.8 without HSP-029; observed growth G_obs 619.0 in USD and 71.4 in NEAR terms. The frozen rule gives no buy or avoid signal. Growth in captured Intents revenue, % a year 0 200 400 600 G_req: growth needed for captured revenue to equal net issuance by 2031-11-04 G_req: 33.2%/yr 33.2%/yr G_req without HSP-029's issuance cut G_req without HSP-029: 46.8%/yr 46.8%/yr G_obs in USD: last 180 days against the 180 before, annualized G_obs (USD): 619.0%/yr 619.0%/yr G_obs in NEAR terms (sensitivity) G_obs (NEAR terms): 71.4%/yr 71.4%/yr
Observed growth: the last 180 days against the 180 days before, to 2026-11-04.
Signal from the rule
None
If H1b were confirmed
Buy
If H1b were refuted
None
Notes and sources

The frozen rating rule gives no buy or avoid signal, which carries no view on NEAR: a buy signal needs H1b confirmed and observed growth at least the required growth, an avoid signal needs H1b refuted and observed growth under half the required growth, and the exchange labels cannot settle H1b.

What it shows: The two inputs of the pre-registered rating rule: required growth G_req of 33.2% a year (46.8% without HSP-029) against observed growth G_obs of 619.0% a year in USD (71.4% in NEAR terms).

What it does not show: A view on the token. The rule gives no signal, and that carries no view on NEAR. Below 50% label coverage H1b can come out confirmed or unsettled but never refuted (the range rule as read before the results; PREREG-ADDENDUM.md, 2026-11-06 23:11 UTC entry, item 6), and observed revenue growth (619.0% a year; 71.4% in NEAR terms) is far above the avoid line (16.6% a year, half of G_req 33.2%), so the rule could only ever have given a buy signal or none; had H1b been refuted it would still have given none. Nor does it show that the inputs are firm: G_req rests on constants committed after the freeze, with the as-written H1a result (the price, the length of HSP-029’s ramp and its activation date; data/raw/rpc/rating_assumptions.json), and G_obs compares the last 180 days with the 180 before, a base window that straddles the 2026-02-23 fee switch (pre-switch revenue counts as captured, as DefiLlama labels it), so it does not separate the switch from other causes, and most of the USD growth is the NEAR price. The NEAR-terms growth measures a step in the share of fees NEAR captures: over the same windows gross fees and volume grew far less (docs/second-review.md).

  • The frozen rule, branch by branch:
    • Buy signal needs G_obs ≥ G_req and H1b confirmed. Now: G_obs ≥ G_req is yes (619.0 against 33.2) and H1b confirmed is no (it is unsettled), so the buy signal is not met.
    • Avoid signal needs G_obs < G_req ÷ 2 and H1b refuted. Now: G_obs < G_req ÷ 2 is no and H1b refuted is no (it is unsettled), so the avoid signal is not met.
    • No signal otherwise, which is the case. The rule gives no signal.
  • G_req is the annual growth in captured Intents revenue (4.84M USD over the last 90 days, DefiLlama) needed for it to equal the USD value of net new supply by 2031-11-04. G_obs is the growth of the last 180 days over the 180 before, annualized.
  • G_req assumes HSP-029’s issuance ramp. Its on-chain timelock ends on 2026-11-16, after the submission deadline. We first added that date up from the proposal’s voting start, voting period and timelock period; two published sources give the same date (PREREG-ADDENDUM.md, 2026-11-12 23:50 UTC entry, item 3). Under the House of Stake procedures a Directors’ decision on execution follows the timelock, and the proposal text also says the cut needs validator adoption through a protocol upgrade; we state it as an open question and do not predict it.
  • Under the range rule as read before the results, a low-coverage H1b can come out confirmed or unsettled, never refuted, so the avoid branch cannot be reached while coverage is below 50%. The exploratory ladder below does not feed the rule.

Source:

Query
DefiLlama revenue
GET https://api.llama.fi/summary/fees/near-intents?dataType=dailyRevenue
CoinGecko price
GET https://api.coingecko.com/api/v3/coins/near/market_chart?vs_currency=usd&days=365&interval=daily
Fetchers
pipeline/fetch_keyless.py, pipeline/fetch_issuance.py
Rule and arithmetic
pipeline/h1a.py, function rating()
Data

A table wider than the screen scrolls sideways.

Plotted values
Input Value Unit
G_req 33.2 % a year
G_req without HSP-029 46.8 % a year
G_obs, USD 619.0 % a year
G_obs, NEAR terms 71.4 % a year
Captured revenue, last 90 days 4.84 USD million
Figure 21Pre-registered#

Forward tests: 2 of 4 came true

Forward tests F1 to F4: the frozen predictions, with the scored results Four number lines, one per forward test. Each shows the frozen prediction as a shaded band and the observed value as a dot. F1: buyback wallet balance at the first final block after 2026-11-14 00:00 (million NEAR, axis does not start at zero) 2.0 2.2 2.4 2.6 predicted 2.21M to 2.40M observed 2.280M F2: mean net supply increase per day, 2026-11-06 to 2026-11-13 (thousand NEAR a day, axis does not start at zero) 80 84 88 92 96 predicted 86.0K to 89.5K observed 86.2K F3: captured take rate, DefiLlama revenue ÷ volume, 2026-11-06 to 2026-11-13 (basis points) 0 2 4 6 8 predicted below 4.0 bp observed 4.22 bp F4: NEAR Intents' share of peer-set volume, reported basis, 2026-11-06 to 2026-11-13 (percent) 0% 25% 50% 75% 100% predicted 50% or more observed 37.2%
Forward tests F1 to F4: the frozen predictions, with the scored results Four number lines, one per forward test. Each shows the frozen prediction as a shaded band and the observed value as a dot. F1: buyback wallet balance at the first final block after 2026-11-14 00:00 (million NEAR, axis does not start at zero) 2.0 2.2 2.4 2.6 predicted 2.21M to 2.40M observed 2.280M F2: mean net supply increase per day, 2026-11-06 to 2026-11-13 (thousand NEAR a day, axis does not start at zero) 80 84 88 92 96 predicted 86.0K to 89.5K observed 86.2K F3: captured take rate, DefiLlama revenue ÷ volume, 2026-11-06 to 2026-11-13 (basis points) 0 2 4 6 8 predicted below 4.0 bp observed 4.22 bp F4: NEAR Intents' share of peer-set volume, reported basis, 2026-11-06 to 2026-11-13 (percent) 0% 25% 50% 75% 100% predicted 50% or more observed 37.2%
Window: 2026-11-06 to 2026-11-13 (UTC). Scoring opened 2026-11-14 00:00 UTC. Each line has its own unit, named in its title.
Notes and sources

Of the four frozen predictions, 2 came true, 2 did not and 0 could not be scored.

What it shows: The four predictions frozen in PREREG.md before the window 2026-11-06 to 2026-11-13, scored as written, with the scorer’s operational readings (PREREG-ADDENDUM.md, 2026-11-08 02:03 UTC entry, item 7), by python3 -m pipeline.score_forward --score on 2026-11-14T07:02:07Z from data fetched at 2026-11-14T07:02:07Z.

What it does not show: A score before scoring opens: a dry run of the scorer is not a score and is never shown here.

  1. F1 (prior probability 0.70): came true

    buybacks.multisignature.near balance at the first final block after 2026-11-14 00:00 UTC is in [2.21M, 2.40M] NEAR

    Balance 2,279,854 NEAR at block 224,435,951.

  2. F2 (prior probability 0.75): came true

    Mean net supply increase per day (Nearblocks total_supply, daily deltas for 2026-11-06 → 2026-11-13) is in [86.0K, 89.5K] NEAR/day

    Mean 86,208 NEAR a day over 8 daily deltas.

  3. F3 (prior probability 0.65): did not come true

    Captured take rate (DefiLlama dailyRevenue ÷ dailyVolume, summed over the window) is below 4.0 bp. October's 5.49 bp was a high, not a new level

    Take rate 4.22 bp (revenue $473,131 over volume $1,121,276,608).

  4. F4 (prior probability 0.70): did not come true

    NEAR Intents' share of the peer-set volume (reported basis) over the window is ≥ 50%

    Intents share 37.2% of peer-set volume.

  • Every result is published, whichever way it went. A test with missing data is recorded as not scorable and never estimated.
  • The bands are the frozen predictions and the dot is the observed value. The predictions were frozen before the window; the scorer was written on 2026-11-06, after the window opened. Its first dry run read no scoring-window day for F2 to F4 and only the window-opening block for F1 (PREREG-ADDENDUM.md, 2026-11-06 23:49 UTC entry, item 7). Later dry runs, and direct reads of the buyback wallet’s balance, did touch window days; they are disclosed in the 2026-11-08 05:04 UTC entry of PREREG-ADDENDUM.md.

Source:

  • Code: pipeline/score_forward.py
  • Upstream: DefiLlama dailyVolume and dailyRevenue (api.llama.fi); Nearblocks /v1/charts total_supply; NEAR archival RPC view_account of buybacks.multisignature.near
  • Frozen text: PREREG.md, forward-test table. Scored result: data/forward/score_20261114T070207Z/result.json.
Query
Scorer
python3 -m pipeline.score_forward --score (refuses to run before 2026-11-14 00:00 UTC)
DefiLlama
GET https://api.llama.fi/summary/dexs/<slug>?dataType=dailyVolume; GET https://api.llama.fi/summary/fees/near-intents?dataType=dailyRevenue
Nearblocks
GET https://api.nearblocks.io/v1/charts
NEAR RPC
https://archival-rpc.mainnet.fastnear.com, view_account at the first final block after 2026-11-14 00:00 UTC
Data

A table wider than the screen scrolls sideways.

Forward tests as frozen
Test Prior probability Result Frozen prediction (PREREG.md, verbatim)
F1 0.70 came true buybacks.multisignature.near balance at the first final block after 2026-11-14 00:00 UTC is in [2.21M, 2.40M] NEAR
F2 0.75 came true Mean net supply increase per day (Nearblocks total_supply, daily deltas for 2026-11-06 → 2026-11-13) is in [86.0K, 89.5K] NEAR/day
F3 0.65 did not come true Captured take rate (DefiLlama dailyRevenue ÷ dailyVolume, summed over the window) is below 4.0 bp. October's 5.49 bp was a high, not a new level
F4 0.70 did not come true NEAR Intents' share of the peer-set volume (reported basis) over the window is ≥ 50%

About the data

A token flow statement for NEAR that anyone can re-run. make site runs python3 -m pipeline.compute and python3 -m pipeline.render in one command, rebuilding every number and chart from the raw snapshots in data/raw/, offline. Each chart carries the query behind it and the exact numbers it plots; the steps to check one are under Reproduce.

Windows
Value capture: the 30 days to 2026-11-04. Supply: the 90 days 2026-08-07 to 2026-11-04.
Data as of
2026-11-04 (data/metrics.json). Revenue-wallet window 2026-10-06..2026-11-04. NEAR RPC block 223,230,811.
Data fingerprint
53a27b8ddbf3c336, the first 16 hex of the SHA-256 of data/MANIFEST.json, which pins every raw snapshot.
Pre-registration
PREREG.md SHA-256 19e470be5398f67c…, frozen at git tag prereg-freeze (commit 413d776, 2026-11-05 22:53:29 UTC), before the first BigQuery result the repository records (2026-11-05 22:55:37 UTC in data/MANIFEST.json); the order rests on the author’s own commit and manifest times, and GitHub’s activity log dates the push of the freeze commit to 2026-11-05 22:53:33 UTC. “What we had already seen” in that file lists the data already in hand.

The Today row is exploratory. The browser fetches it when the page opens, from CoinGecko, DefiLlama and NEAR’s public RPC (no keys). It recomputes the growth the price assumes from today’s market cap and the last 90 days of captured revenue, keeping the committed supply path (1.094× to 2031), a 15% required return and a 25× multiple. Nothing else on the page changes.

Documents:

Not computed here

Questions we leave open.

We leave them open either because the committed data cannot answer them or because a number would claim more than the data support.

  • Net exchange inflow as one number (H1b, H1c). Only 20.0% of the top-100 receivers carry an exchange label (10.0% a cited one; the rest are labelled by our sweep rule). The binding gap is labelling: the flows are in the data, but no citable NEAR address was found for OKX, Coinbase, Kraken, Bybit, HTX, Crypto.com, Upbit or Bithumb, and nothing is labelled from its name alone.
  • Which fee stream pays the escrow releases. 11.25 points of the ladder arrive as unshields from the Confidential Intents escrow. The public chain does not show which fee stream funds them; a per-stream attestation by NEAR would turn the range into one number.
  • NEAR’s share of partner fees. On partner swaps with no buyback entry the ledger puts NEAR’s share, as it reaches the buyback wallet, at no more than 22.4% (19.6% on the tighter reading) but does not measure it.
  • The other half of Intents. 1Click is 55.2% of DefiLlama’s volume on the halved basis (49.7% to 52.9% on one-sided volume, taking confidential solver shields as one-sided confidential volume; exploratory, docs/confidential-flow.md). near.com, direct solver flow and other integrations have a fee structure the Explorer API does not show, and we do not extrapolate.
  • Why the usage step happened. BigQuery shows that Sweat Economy’s signers account for 98.7% of the fall in daily transactions on 2026-04-02, and that HOT Wallet’s .tg accounts account for 98.5% of the fall in active accounts over a year (exploratory, docs/usage.md). Why either happened is not in the data, and no sybil or bot filter is applied.
  • Who the sellers were. NEAR is fungible, so every flow here is a market-wide balance. Nothing says which coins were sold.
  • What NEAR is worth as an L1. The investment case sets NEAR’s whole market cap against Intents’ captured revenue. What the L1 itself is worth (its fees, which burn, staking, any monetary premium) is not computed, so the growth the price assumes is what Intents would need if it carried the price alone.
  • Longer-dated predictions P1 to P3. They resolve on 2027-05-04 and 2027-11-04 and cannot be scored yet.
  • HSP-029’s issuance cut. Its on-chain timelock ends on 2026-11-16, after the submission deadline; we added that date up from the proposal’s voting start, voting period and timelock period, and two published sources give the same date (PREREG-ADDENDUM.md, 2026-11-12 23:50 UTC entry, item 3). A House of Stake Directors’ decision on execution follows the timelock, and the proposal text also says the cut needs validator adoption through a protocol upgrade. G_req assumes the ramp; we state it as an open question and do not predict it.
  • Earlier work. An earlier analysis of 14 accounts that reach one unlabelled hub (THESIS.md, the supply-side section, and docs/supply-side.md) is exploratory and is not reproduced here; the repository does not record when it was done or whether it preceded the freeze (PREREG-ADDENDUM.md, 2026-11-08 02:03 UTC entry, item 5). No card on this page uses it.

Reproduce

Every number and chart on this page rebuilds offline from the committed data.

Each step says what its command prints. make reproduce runs steps 2 to 4, make render-check runs step 6, and make site runs steps 2 to 4 and then step 7, offline.

  1. Do: git clone https://github.com/notveiker/near-flow-statement.git && cd near-flow-statement

    See: A folder with README.md, THESIS.md, PREREG.md, data/, pipeline/, sql/ and site/. Python 3.10 or later is the only requirement: standard library only, no keys, no network.

  2. Do: python3 -m pipeline.check --manifest

    See: check: PASS. Every raw snapshot under data/raw/ matches the SHA-256 recorded in data/MANIFEST.json.

  3. Do: python3 -m pipeline.compute

    See: wrote data/metrics.json (856 metrics, as of 2026-11-04). data/metrics.json and data/series.json do not change: the rebuild is deterministic.

  4. Do: python3 -m pipeline.check --numbers

    See: check: PASS. Every number marked in README.md, THESIS.md, PREREG-ADDENDUM.md and docs/*.md matches data/metrics.json.

  5. Do: python3 -m unittest discover -s tests

    See: The run ends with OK. The tests include this page: each number it prints in a data-attributed span is compared with the source it names, each bar is checked against the value it draws, and the committed page must equal a fresh render.

  6. Do: python3 -m pipeline.render --check

    See: render: site/ matches a fresh render. This page is exactly what the committed data produces.

  7. Do: python3 -m pipeline.render

    See: Writes site/index.html, this page, from the committed data. It has no timestamp, so the same data gives the same bytes.

Limits

Four limits matter most: exchange labels, the escrow’s fee stream, one partner source, and two assumptions.

Too few exchange addresses are labelled to settle the exchange tests: 20.0% of the top-100 receivers, where a point result needs 50%. Which fee funds the escrow releases is unattested. Partner numbers rest on one key-gated source. And the investment case rests on two assumptions, shown as a grid. Escrow funding hops are traced per single-use delivery from 2026-10-06, which a test checks against data/raw/escrow/deliveries.csv. The full list comes from the Limits sections of THESIS.md and docs/*.md and from PREREG-ADDENDUM.md.

  • Collector roles. Collector A’s role (the explicit buyback fee) is cross-checked: its priced inflows are 96.5% of the fees the Explorer lists. Collector B’s role (a share of quote improvement) is inferred from committed, re-checkable per-swap evidence: it is paid a variable cut on 43 of 195 sampled swaps across channels. The quote it would be measured against is not in the Explorer API, so the role is consistent with the docs and unproven.
  • Partner numbers rest on one key-gated source, the Explorer API.
  • Sampling. Fee mechanics come from 195 swaps sampled from hours inside the window (3 of the four sampled hours returned swaps) across 55 channels, a small sample. The 30-day totals reconcile.
  • Pro-rata assumption. Collector B’s quote improvement is allocated to SwapKit by volume share. SwapKit swaps do pay collector B (9 of the 67 sampled), so the allocation has support, but its size is not measured.
  • Unpriced tokens are left out of the collector values: 87.8% of collector A’s transfers and 91.0% of collector B’s are priced, so both figures are lower bounds.
  • Escrow funding before 2026-10-06 is mostly sample-attributed.
  • Exchange labels are snapshots dated 2026-11-06. Exchange addresses retired before then may be missing, which biases the lower bound down.
  • The name-filter check behind the lst-pool.near sensitivity read a sample of validator sets, from some of the epochs.
  • Investment-case assumptions. The required return and the 2031 revenue multiple are assumptions, shown as a grid; which data window anchors each scenario was chosen after the annual volumes, monthly shares and take rates were computed; the market’s growth last year is all Intents’ and partly DefiLlama’s 2026-09-01 counting change; the Monte Carlo’s volume drift comes from the one month that spans that change. All of it is exploratory and dated in the addendum.
  • The upper bound is mechanical. It treats every unlabelled top-100 receiver as an exchange, including accounts that are probably not.
  • DefiLlama’s revenue counts the NEAR delivered to the wallets, at delivery, and its volume series steps up on 2026-09-01.
  • Not reproduced here. An earlier analysis of 14 accounts that reach one unlabelled hub (THESIS.md, the supply-side section, and docs/supply-side.md) is exploratory and is not reproduced here; the repository does not record when it was done or whether it preceded the freeze. No card on this page uses it.