Skip to content

rezenzeffekt/solana-data-analytics

Repository files navigation

Solana Data Analytics

Requirements

Virtual Environment with Python 3.11 for Jupyter Notebook (.ipynb)

How to create virtual environments for python with conda

Flipside account with the free plan or higher for SQL query (.sql) and there can be a short latency for the SQL database.

Flipside Studio

Sharky Loan Offers

Sharky.fi is a Solana-based lending and borrowing protocol that uses NFTs as collateral. The Jupyter notebook files in this repository procure pending offered loans by querying live blockchain data.

Visualize Sharky loan data on their website


Offered loans for the 'Play Solana NFT' collection compared to the results in 'sharky-loan-offers-1.ipynb'

Results Comparison for 'sharky-loan-offers.ipynb'


Offered loans for the 'Sharx' collection with a 16 day duration compared to the results in 'sharky-loan-offers-2.ipynb'

Results Comparison for 'sharky-loan-offers.ipynb'


Offered loans for the 'Leveraged Labs' collection with a 7 day duration compared to the results of 'sharky-loan-offers.sql' in Flipside Studio

Results Comparison for 'sharky-loan-offers.sql'


Offered loans for the 'Sr Manzano' collection with a 7 day duration compared to the results in 'sharky-loan-offers-3.ipynb'

Results Comparison for 'sharky-loan-offers.ipynb'


Loans of the 'Sr Manzano' collection expiring within 36 hours compared to the results in 'sharky-loans-1.ipynb'

Results Comparison for 'sharky-loan-offers.ipynb'


About

on-chain data analytics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published