Skip to content

Q3 — Per-scope ADA flow

PREFIX cardano: <https://lambdasistemi.github.io/cardano-ledger-rdf/vocab/cardano#>

SELECT ?scope (SUM(?lovIn) AS ?ada_in) (SUM(?lovOut) AS ?ada_out)
       ((SUM(?lovIn) - SUM(?lovOut)) 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:lovelace ?lovIn .
    BIND (0 AS ?lovOut)
  }
  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:lovelace ?lovOut .
    BIND (0 AS ?lovIn)
  }
  BIND (
    IF(?bech = "addr1x8ndhlcfy30t38z0tql64fpg8ply93r37xrgvdagfpsz5nhxm0lsjfz7hzwy7kpl42jzswr7gtz8ruvxscm6sjrq9f8qruq0ae",
       "amaru-treasury.contingency",
    IF(?bech = "addr1xyezq8wpaqnssdjvd3p220uf7e6nzjae44w6yu625y965rfjyqwur6p8pqmycmzz55lcnan4x99mnt2a5fe54ggt4gxs8thzgk",
       "amaru-treasury.network_compliance",
    IF(?bech = "addr1qx9aqvsf6gne2640jec828s25gzhk5wp2day8u24kf8mrs2v0zyuvk80fay35dx008p45ts0u6cdrv9g2maetq8jm8psznjcrz",
       "amaru.network-wallet",
    IF(?bech = "addr1q8qrds2nnx7clx3kcpp2l0eu45twmdcahsfu9m0xcwy59j6xz3vs0hnfaz9nhje8z34kfnds4jyk7hs6dnrag6e2lfgqtyf4rl",
       "amaru.cag-payee",
       "other")))) AS ?scope
  )
}
GROUP BY ?scope
ORDER BY ?scope
scope ADA in ADA out net
amaru-treasury.contingency 3,852,000.000000 4,057,000.000000 −205,000.000000
amaru-treasury.network_compliance 14,923,951.458216 16,209,772.179866 −1,285,820.721650
amaru.cag-payee 2.379120 0.000000 +2.379120
amaru.network-wallet 2,391.518562 2,410.553271 −19.034709
other (sundae.swap.v3.order + pools + scoopers + …) 3,407,732.615094 1,916,915.169253 +1,490,817.445841

Sum of net = −19.931398 ADA = the total of Q1 fees (perfect conservation). The 205,000 ADA disburse left contingency and landed at network_compliance; another 1.286 M ADA left network_compliance into Sundae V3 order UTxOs (recovered as USDM on the scoop side).

flowchart LR
  cont["contingency<br/>net −205,000 ADA"] -->|205k ADA disburse| netcomp["network_compliance<br/>net −1,285,820 ADA"]
  netcomp -->|"swap orders<br/>(ADA → sundae.swap.v3.order)"| swap["sundae.swap.v3.order / pools / scoopers<br/>net +1,490,817 ADA"]
  swap -.->|"USDM proceeds back<br/>(see Q7)"| netcomp
  netwallet["network-wallet<br/>−19 ADA gas"]
  cag["cag-payee<br/>+2.4 ADA min-UTxO"]

Return to the presentation.