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.
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 assumeswas 79.8% a year
- NEAR market capwas $4.48B
- Intents revenue, 30 dayswas $1.8M
- NEAR’s take, 30 dayswas 4.75 bp
- Buyback wallet2.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.
Verifiable value capture: 4.53% to 15.81% of net issuance
- 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:
- SQL:
sql/buyback_withdraw_sources.sql,sql/collector_inflow_funders.sql,sql/collector_funder_checks.sql - Raw snapshot:
data/raw/escrow/deliveries.csvsha256 3176231d2065data/raw/escrow/issuance_reads.jsonsha256 2e9c824b4b3ddata/raw/escrow/verify_sample.jsonsha256 3a64f2ad0615data/raw/bq/buyback_withdraw_sources.jsonsha256 e310eb0c522adata/raw/bq/collector_inflow_funders.jsonsha256 c16656a80c73data/raw/bq/collector_funder_checks.jsonsha256 15360dcfb5e6
- Code:
pipeline/compute.py,pipeline/fetch_escrow.py - Upstream: BigQuery public dataset bigquery-public-data.crypto_near_mainnet_us, table execution_outcomes (intents.near native_withdraw events); FastNEAR transaction API and NEAR archival RPC (keyless) for the funding hops and the two total_supply reads
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.
| 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 |
Growth the price assumes: 84.9% a year to 2031
- 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.
| 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.
Source:
- Raw snapshot:
data/raw/llama/dailyRevenue_near-intents.jsonsha256 1c07e697a9afdata/raw/llama/volume_near-intents.jsonsha256 8fcf1cdd855fdata/raw/llama/volume_thorchain-dex.jsonsha256 33f425395933data/raw/llama/volume_chainflip-amm.jsonsha256 597c6e6bd83edata/raw/llama/volume_maya-protocol.jsonsha256 fc0d9b05af6ddata/raw/coingecko/near_snapshot.jsonsha256 199d54d4131bdata/raw/rpc/epoch_issuance.jsonsha256 2937ac18000adata/raw/rpc/rating_assumptions.jsonsha256 dda808e7f742
- Code:
pipeline/investment_case.py,pipeline/model.py,pipeline/h1a.py
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.
| 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% |
Take NEAR would need: 2.5× Intents’ whole gross fee
- 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.
Source:
- Raw snapshot:
data/raw/llama/dailyRevenue_near-intents.jsonsha256 1c07e697a9afdata/raw/llama/volume_near-intents.jsonsha256 8fcf1cdd855fdata/raw/llama/volume_thorchain-dex.jsonsha256 33f425395933data/raw/llama/volume_chainflip-amm.jsonsha256 597c6e6bd83edata/raw/llama/volume_maya-protocol.jsonsha256 fc0d9b05af6ddata/raw/coingecko/near_snapshot.jsonsha256 199d54d4131bdata/raw/rpc/epoch_issuance.jsonsha256 2937ac18000adata/raw/rpc/rating_assumptions.jsonsha256 dda808e7f742data/raw/llama/fees_near-intents.jsonsha256 20099b72ae5c
- Code:
pipeline/investment_case.py
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.
| 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 |
Dilution paid for in 2031: 3.5% bear, 44.6% base, 277.5% bull
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.
Source:
- Raw snapshot:
data/raw/llama/dailyRevenue_near-intents.jsonsha256 1c07e697a9afdata/raw/llama/volume_near-intents.jsonsha256 8fcf1cdd855fdata/raw/llama/volume_thorchain-dex.jsonsha256 33f425395933data/raw/llama/volume_chainflip-amm.jsonsha256 597c6e6bd83edata/raw/llama/volume_maya-protocol.jsonsha256 fc0d9b05af6ddata/raw/coingecko/near_snapshot.jsonsha256 199d54d4131bdata/raw/rpc/epoch_issuance.jsonsha256 2937ac18000adata/raw/rpc/rating_assumptions.jsonsha256 dda808e7f742data/raw/coingecko/near_market_chart_365d.jsonsha256 3cb5249d777e
- Code:
pipeline/investment_case.py,pipeline/model.py
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.
| 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 |
Signposts: the take rate and market growth are far from what the price needs
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.
Source:
- Raw snapshot:
data/raw/llama/dailyRevenue_near-intents.jsonsha256 1c07e697a9afdata/raw/llama/volume_near-intents.jsonsha256 8fcf1cdd855fdata/raw/llama/volume_thorchain-dex.jsonsha256 33f425395933data/raw/llama/volume_chainflip-amm.jsonsha256 597c6e6bd83edata/raw/llama/volume_maya-protocol.jsonsha256 fc0d9b05af6ddata/raw/coingecko/near_snapshot.jsonsha256 199d54d4131bdata/raw/rpc/epoch_issuance.jsonsha256 2937ac18000adata/raw/rpc/rating_assumptions.jsonsha256 dda808e7f742
- Code:
pipeline/investment_case.py,pipeline/compute.py
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.
| 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 |
Monte Carlo: 31.8% of paths pay for all dilution by 2031, 3.3% without one month
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.
Source:
- Raw snapshot:
data/raw/llama/dailyRevenue_near-intents.jsonsha256 1c07e697a9afdata/raw/llama/volume_near-intents.jsonsha256 8fcf1cdd855fdata/raw/coingecko/near_market_chart_365d.jsonsha256 3cb5249d777edata/raw/rpc/epoch_issuance.jsonsha256 2937ac18000adata/raw/rpc/rating_assumptions.jsonsha256 dda808e7f742
- Code:
pipeline/model.py,pipeline/h1a.py,pipeline/compute.py
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.
| 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).
| 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×.
Intents’ share of its peer set: 55.7% over 30 days, 62.1% over 365 days
- 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.nearsettlement 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:
- Raw snapshot:
data/raw/llama/volume_near-intents.jsonsha256 8fcf1cdd855fdata/raw/llama/volume_thorchain-dex.jsonsha256 33f425395933data/raw/llama/volume_chainflip-amm.jsonsha256 597c6e6bd83edata/raw/llama/volume_maya-protocol.jsonsha256 fc0d9b05af6d
- Code:
pipeline/fetch_keyless.py,pipeline/compute.py - Upstream: DefiLlama dailyVolume for near-intents, thorchain-dex, chainflip-amm and maya-protocol
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.
| 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 |
| 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 |
Market cap ÷ gross fees: NEAR 89.2×, THORChain 9.8×, Chainflip 1.8×
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.
Source:
- Raw snapshot:
data/raw/coingecko/peer_caps_30d.jsonsha256 9527a6ce737bdata/raw/coingecko/near_snapshot.jsonsha256 199d54d4131bdata/raw/llama/fees_near-intents.jsonsha256 20099b72ae5cdata/raw/llama/fees_thorchain-dex.jsonsha256 7aab86309385data/raw/llama/fees_chainflip-amm.jsonsha256 cc19df6373b4
- Code:
pipeline/fetch_peer_caps.py,pipeline/investment_case.py
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.
| 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).
Captured revenue: $2.19M in October, 5.49 bp of volume
- 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:
- Raw snapshot:
data/raw/llama/volume_near-intents.jsonsha256 8fcf1cdd855fdata/raw/llama/dailyRevenue_near-intents.jsonsha256 1c07e697a9afdata/raw/llama/fees_near-intents.jsonsha256 20099b72ae5c
- Code:
pipeline/fetch_keyless.py,pipeline/compute.py - Upstream: DefiLlama dailyVolume, dailyRevenue and dailyFees for near-intents
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.
| 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 |
NEAR’s explicit 1Click fee: up from 1.83 bp to 4.08 bp of volume
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.nearsettlement 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:
- Raw snapshot:
data/raw/explorer/daily.jsonsha256 bf77c7832108data/raw/llama/volume_near-intents.jsonsha256 8fcf1cdd855fdata/raw/llama/dailyRevenue_near-intents.jsonsha256 1c07e697a9af
- Code:
pipeline/fetch_explorer.py,pipeline/fetch_keyless.py,pipeline/compute.py - Upstream: NEAR Intents Explorer API (needs a partner key); DefiLlama dailyVolume and dailyRevenue for near-intents
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.
| 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 |
Escrow share of the buyback wallet’s NEAR: 28.6% in August, 53.0% in September
- 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 indata/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_IDin NEAR’s Confidential Intents docs, where it is called the Treasury.
Source:
- SQL:
sql/buyback_withdraw_sources.sql - Raw snapshot:
data/raw/escrow/deliveries.csvsha256 3176231d2065data/raw/escrow/verify_sample.jsonsha256 3a64f2ad0615data/raw/escrow/verify_all.jsonsha256 f20cb3dffca1data/raw/bq/buyback_withdraw_sources.jsonsha256 e310eb0c522a
- Code:
pipeline/compute.py,pipeline/fetch_escrow.py - Upstream: intents.near native_withdraw deliveries to the three revenue wallets (BigQuery; FastNEAR samples before 2026-10-06)
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.
| 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.
SwapKit: 38.2% of 1Click volume, $159 in explicit fees to NEAR in 30 days
- 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:
- SQL:
sql/buyback_withdraw_sources.sql,sql/collector_inflows.sql,sql/revenue_wallet_inflows.sql - Raw snapshot:
data/raw/explorer/daily.jsonsha256 bf77c7832108data/raw/bq/buyback_withdraw_sources.jsonsha256 e310eb0c522adata/raw/bq/collector_inflows.jsonsha256 76ca2d1194f0data/raw/bq/revenue_wallet_inflows.jsonsha256 98a521e32949data/raw/evidence/fee_sample_explorer.jsonsha256 e358b57acdb2data/raw/evidence/fee_sample_onchain.jsonsha256 490fd71de5f2
- Code:
pipeline/compute.py,pipeline/fetch_explorer.py,pipeline/fetch_fee_evidence.py - Upstream: NEAR Intents Explorer API (needs a partner key); BigQuery public dataset bigquery-public-data.crypto_near_mainnet_us, tables execution_outcomes and receipt_actions
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.
| 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 |
| 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 |
Listed partner fees: 1.44× to 2.22× NEAR’s captured revenue
- 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:
- SQL:
sql/revenue_wallet_inflows.sql,sql/revenue_wallet_wnear_inflows.sql - Raw snapshot:
data/raw/explorer/daily.jsonsha256 bf77c7832108data/raw/bq/revenue_wallet_inflows.jsonsha256 98a521e32949data/raw/bq/revenue_wallet_wnear_inflows.jsonsha256 37517e5f3dc6data/raw/llama/dailyRevenue_near-intents.jsonsha256 1c07e697a9af
- Code:
pipeline/compute.py,pipeline/fetch_explorer.py - Upstream: NEAR Intents Explorer API (needs a partner key); BigQuery public dataset bigquery-public-data.crypto_near_mainnet_us, tables receipt_actions and ft_events
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.
| 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.
Supply: up 2.48% in 365 days; net issuance 88.2K NEAR a day
- 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_supplyvalues 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:
- Raw snapshot:
data/raw/nearblocks/charts.jsonsha256 2b7345969508data/raw/rpc/epoch_issuance.jsonsha256 2937ac18000a
- Code:
pipeline/fetch_keyless.py,pipeline/compute.py,pipeline/h1a.py - Upstream: Nearblocks /v1/charts total_supply; NEAR archival RPC epoch-boundary block headers (gross issuance)
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.
| 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 |
| 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 |
Supply growth to 2031: 9.4% with HSP-029, 13.1% without
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:
- Raw snapshot:
data/raw/rpc/epoch_issuance.jsonsha256 2937ac18000adata/raw/rpc/rating_assumptions.jsonsha256 dda808e7f742
- Code:
pipeline/model.py,pipeline/h1a.py
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.
| 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.
Daily active accounts: 61.6K, -77.1% on a year earlier; 98.5% of the fall is one wallet app’s Telegram accounts
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.tgaccounts, and count contracts called;docs/usage.mdhas the details. - The lines are single days and the headline figures 30-day averages, so their last points differ.
Source:
- Raw snapshot:
data/raw/nearblocks/charts.jsonsha256 2b7345969508
- Code:
pipeline/fetch_keyless.py,pipeline/compute.py - Upstream: Nearblocks /v1/charts daily transactions, active accounts, active contracts and new accounts
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.
| 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 |
| 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 |
| 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.
Net staking outflow: 6.56× staking rewards (H1a predicted under 0.5×)
- 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:
- SQL:
sql/staking_flows_daily.sql,sql/staking_pool_totals_endpoints.sql - Raw snapshot:
data/raw/bq/staking_flows_daily.jsonsha256 010fcd4df130data/raw/bq/staking_pool_totals_endpoints.jsonsha256 4e1b90af3b25data/raw/rpc/epoch_issuance.jsonsha256 2937ac18000adata/raw/rpc/pool_endpoints_archival.jsonsha256 e9e2372a4e33
- Code:
pipeline/h1a.py,pipeline/fetch_issuance.py - Upstream: BigQuery public dataset bigquery-public-data.crypto_near_mainnet_us, table account_changes; NEAR archival RPC epoch-boundary block headers
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 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 |
| 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 |
Net exchange inflow: 4.42M to 152.45M NEAR (8.0098M minted)
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.nearand a DAO account) and accounts outside the set, which is howpipeline/h1b.pyapproximates 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:
- SQL:
sql/h1b_a_native_flows.sql,sql/h1b_b_wnear_logs.sql,sql/h1b_c_sweep_clusters.sql - Raw snapshot:
data/raw/bq/h1b_a_native_flows.jsonsha256 ac928fe08ef0data/raw/bq/h1b_b_wnear_logs.jsonsha256 3b7b4433b777data/raw/bq/h1b_c_sweep_clusters.jsonsha256 e9588b535fffdata/raw/labels/exchange_accounts.jsonsha256 86e17c81c187data/raw/labels/binance_por_address_2026-11-06.jsonsha256 5557f3c2ba1f
- Code:
pipeline/h1b.py - Upstream: BigQuery public dataset bigquery-public-data.crypto_near_mainnet_us, tables receipt_actions and execution_outcomes; exchange labels: Binance proof-of-reserves address list and DefiLlama exchange-transparency adapters, snapshots dated 2026-11-06
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.
| 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 | % |
Identified buying: 33.48% of exchange inflow at one bound, 0.97% at the other
- 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.nearin 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:
- SQL:
sql/h1b_a_native_flows.sql,sql/h1b_b_wnear_logs.sql - Raw snapshot:
data/raw/rpc/buyback_balance_endpoints.jsonsha256 8b25f66f4b26data/raw/bq/h1b_a_native_flows.jsonsha256 ac928fe08ef0data/raw/bq/h1b_b_wnear_logs.jsonsha256 3b7b4433b777
- Code:
pipeline/h1b.py - Upstream: NEAR archival RPC view_account of buybacks.multisignature.near at the window's two end-point blocks (heights under Query); BigQuery public dataset bigquery-public-data.crypto_near_mainnet_us
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.
| 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 | % |
Rating rule: no buy or avoid signal
- 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:
- Raw snapshot:
data/raw/rpc/rating_assumptions.jsonsha256 dda808e7f742data/raw/rpc/epoch_issuance.jsonsha256 2937ac18000adata/raw/llama/dailyRevenue_near-intents.jsonsha256 1c07e697a9afdata/raw/coingecko/near_market_chart_365d.jsonsha256 3cb5249d777e
- Code:
pipeline/h1a.py - Upstream: DefiLlama dailyRevenue for near-intents; CoinGecko NEAR daily price; NEAR archival RPC epoch-boundary block headers
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.
| 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 |
Forward tests: 2 of 4 came true
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.
-
F1 (prior probability 0.70): came true
buybacks.multisignature.nearbalance at the first final block after 2026-11-14 00:00 UTC is in [2.21M, 2.40M] NEARBalance 2,279,854 NEAR at block 224,435,951.
-
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/dayMean 86,208 NEAR a day over 8 daily deltas.
-
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 levelTake rate 4.22 bp (revenue $473,131 over volume $1,121,276,608).
-
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.
| 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.
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
.tgaccounts 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.
-
Do:
git clone https://github.com/notveiker/near-flow-statement.git && cd near-flow-statementSee: 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.
-
Do:
python3 -m pipeline.check --manifestSee: check: PASS. Every raw snapshot under data/raw/ matches the SHA-256 recorded in data/MANIFEST.json.
-
Do:
python3 -m pipeline.computeSee: 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.
-
Do:
python3 -m pipeline.check --numbersSee: check: PASS. Every number marked in README.md, THESIS.md, PREREG-ADDENDUM.md and docs/*.md matches data/metrics.json.
-
Do:
python3 -m unittest discover -s testsSee: 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.
-
Do:
python3 -m pipeline.render --checkSee: render: site/ matches a fresh render. This page is exactly what the committed data produces.
-
Do:
python3 -m pipeline.renderSee: 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.