🟡 What is Rollbit?

Rollbit is a hub for degens. A home to leverage trading (up to 1000x leverage), and casino type games like sports betting, it has gotten the attention of many crypto users.

Rollbit launched in February 2020 by a team of entrepreneurs with a shared passion for online gaming, Rollbit has rapidly grown into one of the leading crypto casinos with over 1 million registered users, an estimated $20 million wagered per day and more than $3 billion wagered overall. From new and innovative casino offerings like Bonus Battles, to cryptocurrency derivatives trading, to Non-Fungible Token (NFT) betting games, Rollbit has become widely recognised as the leading innovator in the industry.

In this dashboard, Flipsidecrypto database is used for data analysis. First, using the solana.core.fact_transfers table, the transactions related to sending SOL and RLB ('RLBxxFkseAZ4RgJH3Sqn8jXxhmGoz9jWxDNJMh8pL7a') to the address RBHdGVfDfMjfU6iUfCb1LczMJcQLx7hGnxbzRsoDNvx were extracted. These transactions are related to depositing assets to Rollbit. In this case, the depositors are the same tx_from addresses. Likewise, transactions in which SOL or RLB were sent from the address RBHdGVfDfMjfU6iUfCb1LczMJcQLx7hGnxbzRsoDNvx were considered withdrawal transactions. In this case, the withdrawers are the same tx_to addresses. We also used the solana.core.fact_token_prices_hourly table to get the volume of withdrawals or deposits in USD. We used the ethereum.core.ez_token_transfers table to check the deposit and withdrawal of tokens on the Ethereum chain. We considered the condition to_address='0xef8801eaf234ff82801821ffe2d78d60a0237f97'to check deposit or withdrawal transactions on the Ethereum chain. 111 address is also used to check ETH deposit or withdrawal status.

In this dashboard, we created a dashboard showing key KPIs on rollbit showing both Solana and Ethereum deposits and withdrawals. The following questions are answered in this dashboard:

• What is the volume of deposits and withdrawals in Rollbit?
• How many active wallets are interacting with rollbit? How common are bots in driving these numbers?
• What addresses are the top users of Rollbit?