AddressAppears

Indexes the earliest use of every addresses. Outputs to sqlite.

Useful to determine optimal starting points for other indexers that filter on addresses, e.g utxo, addressbalance, addressdatum, deposit.

Cardano DB Sync equivalent SQL

SELECT MIN(block.slot_no)
     , tx_out.address_raw
  FROM block
  JOIN tx     ON block.id = tx.block_id
  JOIN tx_out ON tx_out.tx_id = tx.id