Try Quests to earn SOLSide Quest: Pool Props: Decentralized Sports Exchange
Pool Props just surpassed $1M USD in volume on their decentralized sports exchange where players can purchase and trade assets based on game and player odds and receive payouts based on the results.
Introductions
What is Solana?
Solana is a high-performance blockchain supporting builders around the world creating crypto apps that scale today, Its native cryptocurrency is SOL it also uses a “proof of stake” system to verify transactions, Anatoly Yakovenko created it.
What is pool Props?
Sports betting protocol on Solana that uses liquidity pools to create a liquid peer-to-peer sports betting solution. more info
Focus of this dashboard
Creating a wallet address based parameterized tool to help players understand their overall activities on betting pools(how much they’ve won or lost win/lose ratio…) and a overall view on top10 best and worst performers(how many these users won or lost, volume and bet count…).
Thank you for your time!
Special thanks goes to adriaparcerisas for his phenomenal queries.
Methodology
Using mainly solana.core.fact_transactions the required data regarding wallets betting on Pool props and their performance were extracted, all of these tables were provided by Flipsidecrypto database, to make these raw extracted data more comprehensible all types of proper charts and graphs were used.
As was required, wallet parameters was applied to all of the visualized numeric values in the last part of this dashboard.
By default the wallet DrFuJ7fWq5T9yScUgASWFNMs7Pjsqnkr54GKetBPRv7h is used as the constant in the parameter sections which can be changed to the desired available wallet address.