Skip to content

Q4 — Multisig shape distribution

PREFIX cardano: <https://lambdasistemi.github.io/cardano-ledger-rdf/vocab/cardano#>
SELECT ?requiredSigners (COUNT(?seed) AS ?txCount)
WHERE {
  { SELECT ?seed (COUNT(DISTINCT ?sig) AS ?requiredSigners) 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:hasRequiredSigner ?sig .
  } GROUP BY ?seed }
  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 .
    FILTER NOT EXISTS { ?seed cardano:hasRequiredSigner ?_ }
    BIND (0 AS ?requiredSigners)
  }
}
GROUP BY ?requiredSigners
ORDER BY DESC(?requiredSigners)
required signers tx count
4 1
2 23
1 6

(Total = 30 — matches the seed batch size.)

The single 4-required-signer transaction is the contingency disburse 18d57a4f… — the highest-authority shape in the batch. The six 1-required-signer transactions are the five 11-input reorganizes (71ff129b, 021e6b48, 65bfd939, cb8f1a12, 019586ee) plus the nine-order scoop dive 4e2642…. The remaining 23 two-required-signer transactions cover the other two disburses, the 20 swap-order opens, and the swap cancel a8bab7bf… (verified per-seed in selections.txt crossed with the per-seed signer count). The fact that the reorganizes and the scoop are 1-signer contradicts the case study's earlier guess that 1-signer covered "swap-order opens, swap-cancel and scoop participation" — the actual shape mapping is read off the chain via the query above.

Return to the presentation.