Overtime Markets - Volume
Analyze the total volume on Overtime Markets over the past two weeks. Which games received the most activity, both in total users and total $ volume? Which sports are receiving the most bets in total dollar volume on a daily basis? Explain your findings.
Introduction
Overtime was made to bring the fun of sports to the blockchain, and part of that is providing a great market interface. The simple, well thought out dapp is easy to navigate and easy to use.
Overtime is a positional market for popular sporting events that operates without relying on a centralized entity like most sports markets. Now that Thales contracts have been used as inspiration for the new Sports AMM, as well as reliable data feeds from the industry best oracle Chain-link, Overtime promises the most fun you'll have with DeFi.
The Sports AMM is one of the most anticipated products built on Thales, as it allows users to purchase positions for their favorite sports teams through the highs and lows of an entire season. With sports such as soccer, football, and basketball on offer, and more on the way such as UFC, Formula 1, Moto GP, you can finally support your favorite team or athlete entirely on the blockchain!
Overtime is not only bringing the game to the blockchain; it’s doing it with some of the best odds available across all sportsbooks, not just crypto. These odds come from Pinnacle Sportsbook, a highly respected bookmaker with customers in over 100 countries. The level of security they employ is top notch, with the same strong encryption and security standards used by top financial institutions. It is also one of the few sportsbooks to offer odds on eSports. For more information you can check this :


Method
In this dashboard, we needed a lot of diverse data, most of which we obtained by using two tables: optimism.core.fact_token_transfers and optimism.core.fact_transactions. Also, we used the existing document for the overtime platform; for example, three different tokens and contracts are created for each game, such as a football match with the ability to win, lose, and draw, and for matches like basketball, where there are only wins and losses, only two tokens are created. Wins and losses are created.
(The names of these tokens are as follows: Home; Draw; Away)
Finally, by using the hint in the Bounty text and with the help of the Optimism scan, the main contract of this platform was obtained, and we obtained the desired data with suitable queries and filters.
(The main contract of the overtime betting platform is '0x170a5714112daeff20e798b6e92e25b86ea603c1')
The following numbers indicate the ==total volume== of transactions, the ==total number of transactions== and the number of ==distinct addresses== used on the platform Overtime for the last two weeks.
2. The graphs below show the games with the most significant number of users and the most considerable amount of money in and out in the last two weeks.
Note that, as mentioned in the methodology section, two or three tokens are created for each game according to the type of sport, and the names you see in the charts are the tokens created.
In addition, to obtain these statistics and draw graphs, the incoming flow of money by four stablecoins, ==USDC,== ==USDT==, ==DAI==, and ==SUSD==, were considered, which was done by finding their contract on the Optimism scan.
We first obtained the desired contracts using a query to find the names of the tokens (the games on which the most bets were made). In the next step, using these contracts and entering them in Optimism Scan, We found the name of the desired games and the win or draw or loss, and using the case command, we showed them in the results and on the graph.
In the opposite donut chart, you can see the sports that have received the most bets in the last two weeks, in which football has received the most bets, as expected and due to popularity.
The following charts show the total volume of transactions; It shows the total number of transactions performed and the number of distinct addresses used on the overtime platform daily and weekly for the last two weeks.

conclusion.
Considering that betting on the results of sports competitions has had many fans for a long time, Betting platforms in crypto have been well received, and every day the number of these platforms and their users and the types of sports that can be bet on is increasing.
The overtime platform is one of the attractive platforms with the ability to use several stable coins for betting, which is gradually increasing its users due to the reasonable costs of the Optimism second layer network and the security of Ethereum. The strength of these platforms for users; Respecting the privacy and security of users' assets.