Hi there. I have been working to do something that I think is not done yet. Even when I am mostly a Frontend I can handle backend as well. So I am testing an index for Volume trading on Liquidity Pools.

> The idea is having a data index of each pool about their trading activity.

For example: If I need to calculate the fees based on a trading liquidity pool, right now there is no index to keep that 24 hours data. The only place having it is tribaldex.com and I can see they have no plans to open an API.

So I did this, which is in test mode:
https://hive-liquidity-pools-data-index.onrender.com/

----

![image.png](https://files.peakd.com/file/peakd-hive/theghost1980/23tHbg12BRhWJGk4VoywetdXVqUYHUV3J1DpzZuRgwVyTUMTATmE7v6Z7bQprETeZcdk1.png)

-----

Basically if you navigate within: https://hive-liquidity-pools-data-index.onrender.com/data/ you will see the actual index. This is a cron-job taking 24 hours snapshots of trading volumen for each available Liquidity Pool pair.

If you open a folder you will find the data, stored in a json file per day:

![image.png](https://files.peakd.com/file/peakd-hive/theghost1980/23w3Cvexi9M2graJDtxbTYUNKkVRb3tsrwCroQYfZj31HsyXLhUHsRuLaxa4PCAFis6CZ.png)

```
 "_id": 112,
  "tokenPair": "AFIT:AFITX",
  "baseQuantity": "2640357.59843536",
  "baseVolume": "41742999.59466189",
  "basePrice": "0.00050848",
  "quoteQuantity": "1342.58242031",
  "quoteVolume": "11664.08687893",
  "quotePrice": "1966.62607709",
  "totalShares": "58727.31265509210142249948",
  "precision": 8,
  "creator": "actifit",
  "isoDate": "2025-04-06T00:00:03.000Z"
```

Some public routes I did so far are:
1. Status https://hive-liquidity-pools-data-index.onrender.com/status
2. List all LP token pairs available for data: https://hive-liquidity-pools-data-index.onrender.com/public/available-data-pool-token-pair

And many more to come if this keep gaining track!

By having this we, in the future, I mean WE as developers, we can easily calculate Fees on each pools, earnings on each pools and positions.

If you want to take a look at the code check here:
https://github.com/theghost1980/hive-liquidity-pools-data-index

I am open to ideas, so far I have enabled some public routes and the storage needs seems to be around 1.3 MB of data daily.

The good friend @ecoinstant is pushing me to do this and we will make this work. I truly believe HIVE needs to get his dev community straight and open up for new ideas and also "find a better way to unify thoughts".

I came up with the idea if the LP Index, because I plan to make an app that will benefit the community, basically will be a HIVE Pool simulator, but in order to get there first I need access to the real time data of trading volume.

So also there is a mechanism to ensure always to get data, kind of, which is testing the rpc nodes and selecting the one responds first but I am aware this Index needs much more work and thinking process.

What do you think about this index guys?
What do you suggest?