Find txs chain with addresses

tx-address.cql

PROFILE MATCH (:Address {address: "addr1-2"})-[:OUT]->(:Output)<-[:OUT]-(t:Transaction)
CALL apoc.path.expandConfig(t, { sequence:'Transaction, <IN, Input, <UNLOCK, Output, <OUT' })
YIELD path
UNWIND nodes(path) as tx
MATCH (tx:Transaction)-[:OUT]->(o:Output)<-[:OUT]-(a:Address)
WHERE (o)-[:UNLOCK]->(:Input)
RETURN DISTINCT *

// check tx chain, 3 - min number of hops in the chain, 6 - max
// where is no chains longer than 3 hops = 2 tx. (each (tx)-to->(tx) step required 3 hops).
// you can try 4..6 - nothing found.
// with long chain in database we can apply: 4..12 (can find chain with at least 3 tx, max 5 tx)
MATCH path = (:Tx)<-[*3..6]-(:Tx)
RETURN path