Tasks

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.

Methodology

Timeframe - last 14 days as two past week.
Process
- Section 1 - Show the total bet volume and count to show the overview of Overt1me markets.
- Section 2 - The 10 ten games based on bet wallets count, bets count, and volume are provided.
- Section 3 - Bets volume and count based on sport type are provided.
- Section 4 - Various information on bet wallets is visualized to show the user behavior.

Total volume on Overtime Markets for the past two weeks

Total count and volume

Numbers on the left show overall bet activity on Overtime Markets.

There are 2208 bets counted from 345 games and 531 wallets in a total of 240k USD volume.

Top 10 games by wallets count

Wallets count can be inferred as the number of users. The two upper graphs show the top 10 wallets count games and wallets count percentage between them.

Baseball games between Baltimore Orioles and Boston Red Sox are the top two that have the highest number of wallets count. The games on Aug 22 and 20 have 53 and 51 counts, respectively.
The next seven of the top ten wallets count games are soccer, and the tenth is MMA

Top 10 games by bets count

Bets count tends to be higher when more wallets bet in the game. The two middle graphs show the top 10 bets count games and bets count percentage between them.

The top two are still the same with wallets count
There is one more baseball game in the top 10 that replace one soccer game.

Top 10 games by bets volume

High bet volume can give a big reward when it hits, on the other hand, it will be a big loss when it misses. The two below graphs show the top 10 bet volume games and the bets volume percentage between them.

The highest bet volume game is still baseball, however, it changes from the match between Baltimore Orioles and Boston Red Sox to Bostom Red Sox and New York Yankees on August 15.
Although MMA is the tenth on wallets count, it is the runner-up on the bets volume.
A football game presents in the top 10 bets volume game which is the first time football is on the top ten charts.
The number of soccer games on the top bets volumes game is half of the top wallets count.

Top 10 games

Bet volume and count based on sport

Performance on various measures

Two upper graphs show the value of each sport on various measures, while the left is grouped by measure, the right is grouped by measures.

Except for the average bet volume per game, baseball and soccer are always the first and the runner-up.
Baseball has the highest games count and bets volume, and wallets count while soccer has the highest bets count.
MMA has the highest average bet volume per game, which means that the bet volume on MMA might exceed baseball’s bet volume if they have the same number of games.

Bets volume percentage based on spot

The lower left chart shows the bet volume percentage based on the sport.

Baseball exceeds half of the total bets volume, in addition, baseball and soccer can achieve 80% of the total bets volume

Bets count percentage based on sport

The lower right chart shows the bets count percentage based on the sport.

The portion of baseball goes down, while the soccer goes up that making soccer has the highest bets count percentage and baseball is the runner-up.
The bet count of the top two nearly touches 90% of the total bet count.

Daily bets volume and cumulative bets volume

Two upper graphs on the right depict the daily bet volume and cumulative bet volume based on sport, respectively.

Baseball shows high bet volume on August 11 and 14 which can make more than 30k USD bets count in one day.
Baseball is the largest band on the cumulative graph which means the it has highest daily cumulative volume.
The first bet volume of MMA and football are on August 12.

Daily bets count and bets count percentage based on sport

Two lower graphs on the right depict the daily bet count and bet count percentage based on sport, respectively.

Different from the bets volume, soccer shows more potential on the bets count.
The size of baseball and soccer bands in the daily percentage graph shows that baseball has a higher number of bet activities than the rest before August 11, after that, soccer comes to take a place.

Bet wallets breakdown

Each sport's peak time by bet volume

Four graphs on the right identify the peak time of each sport based on bet volume.

Baseball - Sunday night
Soccer - weekend daytime
MMA - Friday evening
Football - Saturday evening

Daily bets wallet count based on sport

The upper left graph shows the daily bet wallets count based on sport and bets count.

The bet wallet count has the same similar trend as the bets count.
The interesting finding is that the bet count will outstandingly go up when that number of soccer wallets count reaches 50.

Bet wallets percentages based on sport

The upper right graph shows the daily bet wallets count based on sport and bets count.

The total number of baseball and soccer bet wallets are the same, and nearly reach 80% of the total wallets count.

Daily new wallets percentage

The middle left graph shows the daily new wallet percentage.

There are 13 of the past 14 days that the new bet wallet percentages are higher than 20%, which means the Overtime market still has room to grow and bring new users to the platform.

Number of wallets peak time

The middle left graph shows the number of wallets based on the day of the week and the hour of the day.

The number of bet wallets tends to be higher on Friday, Saturday, and Sunday day time.
Monday has the lowest number of bet wallets.

Total bet wallet count based on the number of sports they bet

Two lower graphs show the bet wallet count categorized by the number of sports they bet and their count percentage.

More than 80% of the bet wallets bet only one sport.
There are 9 of 531 wallets that play all sports which is 1.68% of all wallets that bet on Overtime.

Conclusion

Overall - There are 2208 bets counted from 345 games and 531 wallets in a total of 240k USD volume.
Top game - Baseball with Boston Red Sox games have the highest bet volume, bet count, and wallet count.
Top sport - Baseball and soccer are the two main sports on Overtime, while baseball got the highest bet volume, soccer has the potential to attract wallets to bet on.
Peak time - The daytime of Friday, Saturday, and Sunday is the peak time of bet on the game, while Monday shows the opposite direction.

Collecting sport type

There are two ways to get the sport type from the games address
We use the crawling method base on three issues correctness, completeness, and interpretability.
We collect the sports list and categorize it based on the sport and tag name using a python crawler.
The code and interactive result table are shown in google collab.
The result CSV file is available here.
To avoid the character overflow error using CTE, we backfill only soccer, football, and MMA. The rest beside the backfill are baseball.
We also provide the result from the on-chain method here.

Using on-chain data from the FSC database

PROS

Can query from the database directly.
Doesn’t require manual CTE.
Doesn’t require manual tracking of the top 10.

CONS

There is some game information missing from the database such as 0xd37063eaf88eea27bef94e934055b54f4ca151e7, and 0xae0d0e7c5d9f8d8c17eb48b8d00a823c14dda3e2 due to missing transaction records on the database.
Require backfill
Missing game info makes some games not interpretable.

Crawling from thegraph APIs