Rollbit kpi Dash

The Purpose of this dashboard is to analyze rollbit capital flow and users on both solana and ethereum. In order to achieve this I had to source for the hot wallets:

SOLANA : RBHdGVfDfMjfU6iUfCb1LczMJcQLx7hGnxbzRsoDNvx
ETHEREUM: 0xef8801eaf234ff82801821ffe2d78d60a0237f97, 0xCBD6832Ebc203e49E2B771897067fce3c58575ac

I also used the following tables to obtain the data on this dashboard:

ethereum.core.ez_token_transfers
solana.core.fact_transfers
ethereum.core.ez_eth_transfers
ethereum.core.fact_hourly_token_prices
solana.core.ez_token_prices_hourly

This dashboard is divided into 5 tabs.

Ethereum Tab for rollbit based on ethereum data.
Solana Tab for rollbit on solana data.
Users Tab for Ethereum and Solana users kpi.
Ethereum and Solana tab for comparison between both chains.
Conclusion Tab to conclude the analysis.

Based on the research questions asked, some questions cannot be answered as the platform isn't fully operating on the blockchain, just deposits, withdrawals, tokens burns and cashbacks are conducted on the blockchain. Questions that cannot be answered:

Any signs of leverage trading or on-chain sports betting?
How common are bots in driving these numbers?

Aside these two, the remaining questions have been answered.

Note, the data on this dashboard starts from January till June 2023, the date can be adjusted as desired on the parameters above. NOV 8TH 2021 is the earliest data available on the flipside database.

What is Rollbit?

Rollbit is a leading online casino that provides an exceptional gaming experience to both new and seasoned players. In addition to a wide range of casino games and live casino rooms, Rollbit offers a crypto sportsbook, crypto futures trading, and NFT trading, all on the same platform. The casino has quickly become one of the top crypto gambling destinations worldwide, thanks to its diverse range of services.
Rollbit's addition of cryptocurrency trading has further distinguished the platform from its competitors. The trading feature offers several advantages, including zero-fee trading, up to x1000 leverage for BTC and ETH (maximum leverage for DOGE and LTC is x100), and automatic cashout functions based on either a price or a dollar amount of profit/loss. Rollbit has also incorporated a community focus into its trading feature, enabling users to chat, trade, and compete on the platform's trading leaderboard.
Moreover, Rollbit provides users with additional rewards, such as cashbacks, rakebacks, and level up bonuses, all of which apply to cryptocurrency trading. Overall, Rollbit's platform is a great option for anyone interested in cryptocurrency trading, online gambling, and NFT trading, all in one convenient location.

METHODOLOGY

INTRODUCTION

RESOURCES