Methodology

Dashboard Objective

Show BlazeStake Growth in Solana, compare their stake share against other protocols and see their Staking token ($bSOL) Usage in Swaps.

Dashboard Structure

What is BlazeStake?
- Introduction of BlazeStake and Liquidity Staking Protocols
BlazeStake Staking Share
- Share of Stakes and Staked $SOL of each Stake Protocol in Solana
- Blazestake Share
BlazeStake Stake Activity
- New Stakers and Actual Stakers
- Stakes and Unstakes
- $SOL Staked and Unstaked
$bSOL Swap Activity
- $bSOL Swaps
- $bSOL Swappers
- $bSOL Swap Volume
- What assets had been bought with $bSOL?
- What assets are used to buy $bSOL?
Conclusion
- BlazeStake success rest on their User Reach
- BlazeStake in the Solana Environment
- $bSOL Usage
Methodology

Dashboard Method

Using Flipside Tables of Solana I'll track the stake activity of BlazeStake and then looking at the swap activity with their Token.

--Table Used to get the Staking Activity and Swap Activity in Solana

solana.core.fact_stake_pool_actions -- Recently This table added StakePools Names as Stake_Pool_Name 
solana.core.fact_swaps

--Table used to get the labels for Swap Tokens and Swap Protocols in Solana

solana.core.dim_labels

--Contracts

bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1 -- $bSOL Token Contract
stk9ApL5HeVAwPLr3TLhDXdZS8ptVu7zp6ov8HFDuMi -- BlazeStake Staking Pool Contract

--Some of the SQL used are SQL templates (DAU/WAU/MAU, Growth Rates, New User Percentage) learned at Covalent Bootcamp

Dashboard Sources

BlazeStake Banner

$bSOL Token Image

Tweet Screenshot used at the first Tab by @SolBlaze

Solblaze Docs

SolBlaze Twitter

MetricsDAO Bounty Question

Submit a deep dive dashboard that explores a specific topic in detail using Solana data.

The Rise of BlazeStake