Skip to content

Q7 — Per-scope USDM flow

PREFIX cardano: <https://lambdasistemi.github.io/cardano-ledger-rdf/vocab/cardano#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

SELECT ?scope (SUM(?qIn) AS ?usdm_in) (SUM(?qOut) AS ?usdm_out)
       ((SUM(?qIn) - SUM(?qOut)) AS ?net)
WHERE {
  {
    VALUES ?seedTxId {
      "18d57a4f104df4cc776104ce626958e2110122392e4c4c7671edc8861b48452e"
      "affe90d1fa9a93b3e2a48009ef80634e9de8428640f5d673e85b002a86399982"
      "c150d5c5c67658c8f2a3bc24e16a4852257d46a03224257ac990fcca6f6fde78"
      "cb8f1a1254d650afc1c5b2a1e677df24ac72c4540e96eff52072bcb04b7274ba"
      "019586ee09f54155379d36ea2c6aa010296dcf5b8e28564a668bec1a44d8f503"
      "71ff129b5e0b5983ac01da968c6e345a8b6bc36d650a27f18c02ea9787a13dbe"
      "65bfd93936abf4fb26a135e89bd3ef133bb4b02152b37199586ed443979a95b1"
      "021e6b48610dd73b9c72c39f50986c1f2a34927fe7a764e0f06305f61b3b44ea"
      "013329ee0504d62c593491b76084bdd3958c0578037d28382c0de4611709c3f6"
      "107e439f247fad6bd05543d81b9139547c521f50e5409120bed9f3d80b644055"
      "10a5c1dafe7dd8d4ab680e35dc53b8b550da90bea55f2c758f36474064f2e598"
      "22e914892e83c22e19514937914ca32a0c059f9d1c5b555429edde0ea3406ae4"
      "2695f20941ac832a9b36fdbe4f0b78a8f5bafddf964b353b81aec360a13df3f3"
      "26ef34aa02aecfb068e44f00e7d2f50deef377d168a7e33d1e7d01a11f32d46d"
      "36d57c1be24bd617d1b7eb1f4aa4a391c3f351aa5b6cc4ac32ebc1dd2ded4d84"
      "488e5b417aa4f573528057fd1d7ab6de4f7ad06e296f945ee4097d8a94ee62e7"
      "5262be893119bd6d43c1c2fce5b0b89f7ac15f8e7d3d3dd66d0eb01e42b875d7"
      "59e10ca5e03b8d243c699fc45e1e18a2a825e2a09c5efa6954aec820a4d64dfe"
      "5fc04113da630ec676a5a7a66d82f53c0e64527ee592c3e6c5e1dccad67732ea"
      "7353059f0e0f59e974887b3f2405019e26c2a06673a9ce45d3cfdcbd814d5896"
      "7ac5f9e3f5de550b72aaf9e1c476bac02837e44d22600ddc00f63c7b4e753d7f"
      "a38cb99bab8eb9922454fc7ae61ca38ff31b54d0db4afa6b33933763ba1cfd09"
      "ad6ac0a1889733757f4503dac327ee57d3397dadf2948bff624f315ea0754aeb"
      "b5716ae98bb41b53c5fa2ebc6e8d5558879dc86d14fb998333e643095c6b233e"
      "b63aa2dd78c2a63b71aeba687cf45d445a98653a81f48774aa30236e47f30b86"
      "dfd355530e2d3baef6fc4cb22369c8b64aa117b0a84ff2cdaadc24cdc3fbc7bc"
      "f2791967f99ac04b33da17bd9c848b673c690a40d647b1e21e2651ff7a2f4657"
      "9f119393a85bb9aa0c94f8c649288dabb956b88dcbe055b10e741a2237123420"
      "a8bab7bfe1e2ed9d3a5b40189c8de51c5974a6e05c71fc1000a6abd57500b365"
      "4e2642080c8d171aad05baed11b076de498b76acecc1c2412660048fae8aefa3"
    }
    ?seed a cardano:Transaction ;
          cardano:hasTxId/cardano:bytesHex ?seedTxId ;
          cardano:hasOutput ?out .
    ?out cardano:atAddress/cardano:bech32 ?bech ;
         cardano:hasAssetValue/rdf:rest*/rdf:first ?asset .
    ?asset cardano:hasIdentifier ?id ; cardano:quantity ?qIn .
    ?id cardano:bytesHex
          "c48cbb3d5e57ed56e276bc45f99ab39abe94e6cd7ac39fb402da47ad0014df105553444d" .
    BIND (0 AS ?qOut)
  }
  UNION
  {
    VALUES ?seedTxId {
      "18d57a4f104df4cc776104ce626958e2110122392e4c4c7671edc8861b48452e"
      "affe90d1fa9a93b3e2a48009ef80634e9de8428640f5d673e85b002a86399982"
      "c150d5c5c67658c8f2a3bc24e16a4852257d46a03224257ac990fcca6f6fde78"
      "cb8f1a1254d650afc1c5b2a1e677df24ac72c4540e96eff52072bcb04b7274ba"
      "019586ee09f54155379d36ea2c6aa010296dcf5b8e28564a668bec1a44d8f503"
      "71ff129b5e0b5983ac01da968c6e345a8b6bc36d650a27f18c02ea9787a13dbe"
      "65bfd93936abf4fb26a135e89bd3ef133bb4b02152b37199586ed443979a95b1"
      "021e6b48610dd73b9c72c39f50986c1f2a34927fe7a764e0f06305f61b3b44ea"
      "013329ee0504d62c593491b76084bdd3958c0578037d28382c0de4611709c3f6"
      "107e439f247fad6bd05543d81b9139547c521f50e5409120bed9f3d80b644055"
      "10a5c1dafe7dd8d4ab680e35dc53b8b550da90bea55f2c758f36474064f2e598"
      "22e914892e83c22e19514937914ca32a0c059f9d1c5b555429edde0ea3406ae4"
      "2695f20941ac832a9b36fdbe4f0b78a8f5bafddf964b353b81aec360a13df3f3"
      "26ef34aa02aecfb068e44f00e7d2f50deef377d168a7e33d1e7d01a11f32d46d"
      "36d57c1be24bd617d1b7eb1f4aa4a391c3f351aa5b6cc4ac32ebc1dd2ded4d84"
      "488e5b417aa4f573528057fd1d7ab6de4f7ad06e296f945ee4097d8a94ee62e7"
      "5262be893119bd6d43c1c2fce5b0b89f7ac15f8e7d3d3dd66d0eb01e42b875d7"
      "59e10ca5e03b8d243c699fc45e1e18a2a825e2a09c5efa6954aec820a4d64dfe"
      "5fc04113da630ec676a5a7a66d82f53c0e64527ee592c3e6c5e1dccad67732ea"
      "7353059f0e0f59e974887b3f2405019e26c2a06673a9ce45d3cfdcbd814d5896"
      "7ac5f9e3f5de550b72aaf9e1c476bac02837e44d22600ddc00f63c7b4e753d7f"
      "a38cb99bab8eb9922454fc7ae61ca38ff31b54d0db4afa6b33933763ba1cfd09"
      "ad6ac0a1889733757f4503dac327ee57d3397dadf2948bff624f315ea0754aeb"
      "b5716ae98bb41b53c5fa2ebc6e8d5558879dc86d14fb998333e643095c6b233e"
      "b63aa2dd78c2a63b71aeba687cf45d445a98653a81f48774aa30236e47f30b86"
      "dfd355530e2d3baef6fc4cb22369c8b64aa117b0a84ff2cdaadc24cdc3fbc7bc"
      "f2791967f99ac04b33da17bd9c848b673c690a40d647b1e21e2651ff7a2f4657"
      "9f119393a85bb9aa0c94f8c649288dabb956b88dcbe055b10e741a2237123420"
      "a8bab7bfe1e2ed9d3a5b40189c8de51c5974a6e05c71fc1000a6abd57500b365"
      "4e2642080c8d171aad05baed11b076de498b76acecc1c2412660048fae8aefa3"
    }
    ?seed a cardano:Transaction ;
          cardano:hasTxId/cardano:bytesHex ?seedTxId ;
          cardano:hasInput ?in .
    ?in cardano:fromTxOutRef ?ref .
    ?ref cardano:hasTxId ?h ; cardano:hasIndex ?ix .
    ?h cardano:bytesHex ?parentHex .
    ?parent cardano:hasTxId/cardano:bytesHex ?parentHex ; cardano:hasOutput ?parentOut .
    ?parentOut cardano:hasIndex ?ix ;
               cardano:atAddress/cardano:bech32 ?bech ;
               cardano:hasAssetValue/rdf:rest*/rdf:first ?asset .
    ?asset cardano:hasIdentifier ?id ; cardano:quantity ?qOut .
    ?id cardano:bytesHex
          "c48cbb3d5e57ed56e276bc45f99ab39abe94e6cd7ac39fb402da47ad0014df105553444d" .
    BIND (0 AS ?qIn)
  }
  BIND (
    IF(?bech = "addr1x8ndhlcfy30t38z0tql64fpg8ply93r37xrgvdagfpsz5nhxm0lsjfz7hzwy7kpl42jzswr7gtz8ruvxscm6sjrq9f8qruq0ae",
       "amaru-treasury.contingency",
    IF(?bech = "addr1xyezq8wpaqnssdjvd3p220uf7e6nzjae44w6yu625y965rfjyqwur6p8pqmycmzz55lcnan4x99mnt2a5fe54ggt4gxs8thzgk",
       "amaru-treasury.network_compliance",
    IF(?bech = "addr1q8qrds2nnx7clx3kcpp2l0eu45twmdcahsfu9m0xcwy59j6xz3vs0hnfaz9nhje8z34kfnds4jyk7hs6dnrag6e2lfgqtyf4rl",
       "amaru.cag-payee",
       "other"))) AS ?scope
  )
}
GROUP BY ?scope
ORDER BY ?scope
scope USDM in (raw) USDM out (raw) net (raw) net (USDM)
amaru-treasury.network_compliance 1,146,156,659,602 1,554,849,981,833 −408,693,322,231 −408,693.322231
amaru.cag-payee 418,750,000,000 0 418,750,000,000 +418,750.000000
other (SundaeSwap pool, batchers) 490,819,149,109 500,875,826,878 −10,056,677,769 −10,056.677769

(USDM has 6 decimals; divide raw by 10⁶.)

TOTAL in − out (raw) = (1,146,156,659,602 + 418,750,000,000 + 490,819,149,109) − (1,554,849,981,833 + 0 + 500,875,826,878) = 2,055,725,808,711 − 2,055,725,808,711 = 0 — conservation exact within the USDM dimension of the seed batch.

network_compliance lost 408,693.322231 USDM net over the seed batch — 418,750 of that went to cag-payee (vendor bridge); the 10,056.677769 USDM "shortfall" was absorbed by SundaeSwap batcher fees / slippage (visible directly in the other row).

Return to the presentation.