Right now there's only one query, extracting staked amount in Ergopad contracts.
Requirements:
- You will need access to an Explorer instance to connect to DB. (You can use https://github.com/abchrisxyz/ergo-setup)
- PGAdmin or similar to run the sqls.
Query will pull a list of addresses in all Ergopad staking contracts:
- Token ID
- Wallet Address
- Current Staked Amount
- Original/Initial staked amount
- Initial Stake date
It's currently one row per staking key and many addresses have multiple keys. Use excel to pivot and analyze by address.
Known Issue:
Ergopad query pulls in a few less tokens than expected (~10) but for the addresses I checked it's correct. It includes burnt tokens (address=NULL)