Create a new GitHub repository similar to the example below implementing an API endpoint.

Scope of the work

Create an API endpoint which returns back the total TVL of Realms i.e. the total value of SOL and SPL tokens kept in the treasury of all the DAOs in USD value. The data can be fetched and stored as JSON or otherwise (database) and update once a month. The API can return a static stored data for a month. The update to the data can be automatic or manual (through running a Node script monthly or otherwise). Details:

The Jupiter API should be used to calculate the end value of the tokens and SOL.

The scope of work includes the calculation of treasury values for all the DAOs created using the following Governance Program ID:

GovER5Lthms3bLBqWub97yVrMmEogzX7xNjdXpPPCVZw
gUAedF544JeE6NYbQakQvribHykUNgaPJqcgf3UQVnY
GqTPL6qRf5aUuqscLh8Rg2HTxPUXfhhAXDptTLhp1t2J
DcG2PZTnj8s4Pnmp7xJswniCskckU5E6XsrKuyD7NYFK
AEauWRrpn9Cs6GXujzdp1YhMmv2288kBt3SdEcPYEerr
G41fmJzd29v7Qmdi8ZyTBBYa98ghh3cwHBTexqCG1PQJ
GovHgfDPyQ1GwazJTDY2avSVY8GGcpmCapmmCsymRaGe
pytGY6tWRgGinSCvRLnSv4fHfBTMoiDGiCsesmHWM6U
J9uWvULFL47gtCPvgR3oN7W357iehn5WF2Vn9MJvcSxz
JPGov2SBA6f7XSJF5R4Si5jEJekGiyrwP2m7gSEqLUs
Ghope52FuF6HU3AAhJuAAyS2fiqbVhkAotb7YprL5tdS
5sGZEdn32y8nHax7TxEyoHuPS3UXfPWtisgm8kqxat8H
smfjietFKFJ4Sbw1cqESBTpPhF4CwbMwN8kBEC1e5ui
GovMaiHfpVPw8BAM1mbdzgmSZYDw2tdP32J2fapoQoYs
GCockTxUjxuMdojHiABVZ5NKp6At8eTKDiizbPjiCo4m
HT19EcD68zn7NoCF79b2ucQF8XaMdowyPt5ccS6g1PUx
GRNPT8MPw3LYY6RdjsgKeFji5kMiG1fSxnxDjDBu4s73
ALLGnZikNaJQeN4KCAbDjZRSzvSefUdeTpk18yfizZvT
A7kmu2kUcnQwAVn8B4znQmGJeUrsJ1WEhYVMtmiBLkEr
MGovW65tDhMMcpEmsegpsdgvzb6zUwGsNjhXFxRAnjd
jdaoDN37BrVRvxuXSeyR7xE5Z9CAoQApexGrQJbnj6V
GMnke6kxYvqoAXgbFGnu84QzvNHoqqTnijWSXYYTFQbB
hgovkRU6Ghe1Qoyb54HdSLdqN7VtxaifBzRmh9jtd3S
jtogvBNH3WBSWDYD5FJfQP2ZxNTuf82zL8GkEhPeaJx
dgov7NC8iaumWw3k8TkmLDybvZBCmd1qwxgLAGAsWxf

The code can be created for one program ID and re-run for all the programs.

SDK that can be used:
https://www.npmjs.com/package/@solana/spl-governance
https://www.npmjs.com/package/governance-idl-sdk

Existing implementation for reference (just for inspiration, your solution can be entirely different):
https://github.com/solana-labs/governance-api/blob/main/src/stats/stats.controller.ts#L11