Add SPO tickers in explorer

[jpraynaud]

Why

We want to add the SPOs ticker names next to their pool ids in the explorer

What

We use a list of SPOs provided by a third party (e.g. Cexplorer) and create a manual tool in the aggregator to populate the signer table with the ticker. The aggregator exposes a new route that maps all the pool ids to their known tickers. The explorer uses this route to map the pool ids to the ticker and display it when available

Note:

• mainnet: https://js.cexplorer.io/api-static/pool/list.json
• preprod list: https://preprod-js.cexplorer.io/api-static/pool/list.json
• preview list: https://preview-js.cexplorer.io/api-static/pool/list.json

How

• Add a new thread spawn in aggregator serve command to download (every 12h?) a json file and upsert the signer table with it (pool_ticker field)
• Add a new /signers/tickers HTTP route in aggregator that serves all the signers pool ids and tickers
• Use the new /signers/tickers route in the explorer to store locally the pool id/ticker mapping (refresh every 12h)?
• Enrich pool ids display with the ticker when it is available (add a link to cexplorer on the pool id)
• Implementation terraform deployments