Loading the Numbers
Reading the published files. Nothing is shown until they arrive.
What this page answers: how you can check every number yourself, without trusting Tideline.
Three steps, no key and no account. Going further, BigQuery needs your own Google project, and the panel your own key.You do not have to trust Tideline. These commands re-run the numbers on your own computer, and the chain check shows that no saved day was changed later: each day’s is on NEAR’s .
Daily Hash on NEAR Testnet
Check It Yourself in Three Steps
No install? Use a ready terminal
A terminal in your browser with everything installed, running free on your own GitHub account. Then skip step 1.
Get the code
Download the project and install what it uses. Needs Node 24; no key and no account.
git clone https://github.com/ervhint/tideline-thesis.git && cd tideline-thesis && npm ciCheck every number
Works out every published number again from the saved data and compares it with the files. About a minute.
You should see: every number OK, then ALL OK.
npm run verifyCheck a saved day against NEAR testnet
Fingerprints a saved day and compares it with the fingerprint stored on NEAR testnet, so you can see it was not changed later.
You should see: match. The newest day says not yet anchored until its daily anchor runs.
npm run attest:check 2026-11-12Going Further
Recompute every chart
From the stored public data. Needs: nothing.
npm run rebuildRe-run the SQL
Reads the public NEAR dataset on BigQuery again. Needs: your own Google project.
npm run rebuild -- --bigqueryPrint the rolling panel
Writes nothing to the repo. Needs: your own Explorer key.
npm run panelEvery Reading and ChartWhere Each Number Comes From
See Every Chart in One PlaceThe Five ReadingsThe Five Questions
Pricing PowerWhen fees go up, do people stop swapping?
When a frontend changed its fee, whether its volume moved more than the same dates with no change. It reads Bullish only if the whole interval is above −1.When an app changed its fee, whether people swapped less afterwards than on days with no change.
Query: queries/elasticity_read.sql (opens in a new tab), queries/elasticity_days.sql (opens in a new tab), analysis/elasticity.mjs (opens in a new tab), pipeline/build_elasticity.mjs (opens in a new tab)
Source: BigQuery intents.near logs to 3 Oct 2026, then frozen chain days. PREREG.md sections 3 and 4, amendment A4.
Query: queries/elasticity_read.sql (opens in a new tab), queries/elasticity_days.sql (opens in a new tab), analysis/elasticity.mjs (opens in a new tab), pipeline/build_elasticity.mjs (opens in a new tab)
Source: BigQuery intents.near logs to 3 Oct 2026, then frozen chain days. PREREG.md sections 3 and 4, amendment A4.
NEAR's Share of FeesDoes NEAR keep a fair share of the fees?
The part of Intents fees that DefiLlama books as NEAR revenue over the last 30 days.The part of the swap fees that NEAR keeps, as DefiLlama counts it, over the last 30 days.
Query: analysis/readings.mjs (opens in a new tab), pipeline/pull_defillama.mjs (opens in a new tab)
Source: DefiLlama fees and revenue, all Intents. Stored in data/snapshot/defillama_daily.json.
Query: analysis/readings.mjs (opens in a new tab), pipeline/pull_defillama.mjs (opens in a new tab)
Source: DefiLlama fees and revenue, all Intents. Stored in data/snapshot/defillama_daily.json.
Solver CompetitionDo the traders really compete?
What solvers keep on public $1k to $10k swaps, and how much the top 3 fill. Not Measured while the Treasury carries over 50% of counted USD.What the traders keep on public swaps, and how much the three biggest of them fill. It cannot be answered while most of the money goes private.
Query: analysis/realised_cost.mjs (opens in a new tab), analysis/readings.mjs (opens in a new tab), pipeline/build_fee_trace.mjs (opens in a new tab)
Source: Frozen chain days in data/chain. PREREG.md sections 5 and 8, amendment A2.
Query: analysis/realised_cost.mjs (opens in a new tab), analysis/readings.mjs (opens in a new tab), pipeline/build_fee_trace.mjs (opens in a new tab)
Source: Frozen chain days in data/chain. PREREG.md sections 5 and 8, amendment A2.
Largest IntegratorDoes one app bring most of the business?
The largest frontend's share of visible app fees over the last 30 frozen days.The biggest app’s share of the app fees we can see, over the last 30 saved days.
Query: analysis/integrator.mjs (opens in a new tab), pipeline/build_thesis.mjs (opens in a new tab)
Source: Frozen chain days in data/chain. PREREG.md amendments A1 and A2.
Query: analysis/integrator.mjs (opens in a new tab), pipeline/build_thesis.mjs (opens in a new tab)
Source: Frozen chain days in data/chain. PREREG.md amendments A1 and A2.
Path to DeflationIs NEAR's fee income growing?
Whether the 90-day revenue total rose or fell at each of the last three month-ends.Whether NEAR’s fee income over 90 days went up at each of the last three month-ends.
Query: analysis/readings.mjs (opens in a new tab), pipeline/pull_defillama.mjs (opens in a new tab)
Source: DefiLlama revenue, all Intents. Stored in data/snapshot/defillama_daily.json.
Query: analysis/readings.mjs (opens in a new tab), pipeline/pull_defillama.mjs (opens in a new tab)
Source: DefiLlama revenue, all Intents. Stored in data/snapshot/defillama_daily.json.
Charts and PagesCharts and Pages
Volume Against the Threshold (Home Gauge)How Far Swapping Is From the Target (Home)
How far monthly Intents volume sits below the level at which buybacks would cover new NEAR issuance.How far the money swapped each month is from the amount that would let buybacks cancel out the new NEAR coins.
Query: lib/model.ts (opens in a new tab), pipeline/model_inputs.mjs (opens in a new tab), pipeline/build_thesis.mjs (opens in a new tab)
Source: DefiLlama volume and revenue, NEAR RPC supply. Stored in data/published/model_inputs.json.
Query: lib/model.ts (opens in a new tab), pipeline/model_inputs.mjs (opens in a new tab), pipeline/build_thesis.mjs (opens in a new tab)
Source: DefiLlama volume and revenue, NEAR RPC supply. Stored in data/published/model_inputs.json.
What a $10,000 Swap Costs (Follow the Fee)
Where the cost of a real public swap goes, with anything the fees do not explain shown as the rest.Where the cost of a real public swap goes, with anything we cannot explain shown as the rest.
Query: analysis/realised_cost.mjs (opens in a new tab), pipeline/build_fee_trace.mjs (opens in a new tab)
Source: Frozen chain days in data/chain, DefiLlama hourly prices. PREREG.md section 7, amendment A2.
Query: analysis/realised_cost.mjs (opens in a new tab), pipeline/build_fee_trace.mjs (opens in a new tab)
Source: Frozen chain days in data/chain, DefiLlama hourly prices. PREREG.md section 7, amendment A2.
Fee Changes on a Date Axis (Elasticity)The Fee Changes We Studied (Elasticity)
Each tick is a fee change that held for 7 days on both sides; the plot shows how far volume moved for a given change in fee.Each line is a fee change that held for a week on both sides; the chart shows how much swapping moved.
Query: queries/elasticity_read.sql (opens in a new tab), queries/elasticity_days.sql (opens in a new tab), analysis/elasticity.mjs (opens in a new tab), pipeline/build_elasticity.mjs (opens in a new tab)
Source: BigQuery intents.near logs to 3 Oct 2026, then frozen chain days. PREREG.md section 3, amendment A4.
Query: queries/elasticity_read.sql (opens in a new tab), queries/elasticity_days.sql (opens in a new tab), analysis/elasticity.mjs (opens in a new tab), pipeline/build_elasticity.mjs (opens in a new tab)
Source: BigQuery intents.near logs to 3 Oct 2026, then frozen chain days. PREREG.md section 3, amendment A4.
Move a Number, See the Threshold (Model)
The monthly volume at which buybacks cover issuance, for any issuance, price and buyback share you set.How much swapping a month would let buybacks cancel out the new coins, for any setting you choose.
Query: lib/model.ts (opens in a new tab), pipeline/model.mjs (opens in a new tab), pipeline/model_inputs.mjs (opens in a new tab)
Source: DefiLlama and NEAR RPC. Stored in data/published/model_inputs.json.
Query: lib/model.ts (opens in a new tab), pipeline/model.mjs (opens in a new tab), pipeline/model_inputs.mjs (opens in a new tab)
Source: DefiLlama and NEAR RPC. Stored in data/published/model_inputs.json.
Who Brings the Volume? (Concentration)Who Brings the Swaps? (Concentration)
How much of each swap size comes from the largest frontend and the largest solvers on public swaps.How much of each swap size comes from the biggest app and the biggest traders.
Query: analysis/integrator.mjs (opens in a new tab), analysis/realised_cost.mjs (opens in a new tab), pipeline/build_thesis.mjs (opens in a new tab)
Source: Frozen chain days in data/chain. The Treasury is never counted as a solver.
Query: analysis/integrator.mjs (opens in a new tab), analysis/realised_cost.mjs (opens in a new tab), pipeline/build_thesis.mjs (opens in a new tab)
Source: Frozen chain days in data/chain. The Treasury is never counted as a solver.
Side Measures (Set No Reading)Extra Measures (They Answer Nothing on Their Own)
Confidential ShareHow Much Goes Private
Other accounts' funds going into the Treasury, as a share of the flow still visible. It sets no reading.How much of the money we can still see goes into the private system. It answers nothing on its own.
Query: analysis/treasury.mjs (opens in a new tab), pipeline/treasury_day.mjs (opens in a new tab), pipeline/build_confidential.mjs (opens in a new tab)
Source: dip4 transfer events (the event standard intents.near logs) to and from the Treasury on intents.near, in data/treasury. PREREG.md amendment A2 rule 8.
Query: analysis/treasury.mjs (opens in a new tab), pipeline/treasury_day.mjs (opens in a new tab), pipeline/build_confidential.mjs (opens in a new tab)
Source: dip4 transfer events (the event standard intents.near logs) to and from the Treasury on intents.near, in data/treasury. PREREG.md amendment A2 rule 8.
How Much the Public Chain Still Sees
DefiLlama volume divided by chain-counted USD: a rise means the chain sees less, not that demand fell. It has no line and no state.How much of the swapping the public record still shows. When it shows less, swaps moved out of view; it does not mean fewer people are swapping.
Query: analysis/visibility.mjs (opens in a new tab), pipeline/build_visibility.mjs (opens in a new tab)
Source: DefiLlama daily volume and frozen chain days. PREREG.md amendment A3.
Query: analysis/visibility.mjs (opens in a new tab), pipeline/build_visibility.mjs (opens in a new tab)
Source: DefiLlama daily volume and frozen chain days. PREREG.md amendment A3.
Public Activity on intents.nearActivity on NEAR Intents
Transactions, signing accounts, receipts and NEAR burnt each week, as a chart and table. Treasury traffic is in these counts, so more activity is not more swaps.Transactions and accounts each week. They include the private system’s traffic, so more activity is not more swaps.
Query: queries/daily_transactions.sql (opens in a new tab), queries/daily_contract_usage.sql (opens in a new tab), analysis/activity.mjs (opens in a new tab), pipeline/build_activity.mjs (opens in a new tab), pipeline/activity_refresh.mjs (opens in a new tab)
Source: BigQuery public dataset crypto_near_mainnet_us, the last 90 finished days, re-run weekly by the activity job.
Query: queries/daily_transactions.sql (opens in a new tab), queries/daily_contract_usage.sql (opens in a new tab), analysis/activity.mjs (opens in a new tab), pipeline/build_activity.mjs (opens in a new tab), pipeline/activity_refresh.mjs (opens in a new tab)
Source: BigQuery public dataset crypto_near_mainnet_us, the last 90 finished days, re-run weekly by the activity job.
Tideline is research, not financial advice.Follow Us on Telegram (opens in a new tab)