Try Quests to earn cryptoOvertime Markets - Profitable Traders
Identify the 5 most profitable traders on Overtime Markets in the last two weeks. How much has each wallet won by sport?
Again with Overtime Markets but this time for traders
Like this my dashboard, I will review Overtime Markets, but here I am going to review 5 Profitable Traders in all Overtime Markets and separately for each sport from '2022-08-06' to '2022-08-19'.
Method
The procedure is the same as my previous dashboard (this link). Information about sports and games is taken from thegraph API. The JSON file related to the games is available in my GitHub repository (this link). Also, for easier use in the Flipside query section, you can use this page in my GitHub that I have created for this purpose.
Note: The information in the above JSON file is up to August 20, 2022. Also, on the page where the information is displayed as a query (this page) from August 6, 2022 (the time period in which the analysis was carried out).
In first step, from the optimism.core.fact_event_logs table, all transactions that sent a transaction to the address 0x170a5714112daeff20e798b6e92e25b86ea603c1 have been called. Also, from the optimism.core.fact_transactions table, the game address information of the transactions obtained in fact_event_logs was found. Finally, by joining the data of these two tables and the data received from the thegraph API, the final results have been obtained.
The method I used to find the received win amount is as follows. The mechanism of each bet is such that with each bet, the user receives an NFT worth the prize amount of each bet. If the betting result is correct, the user can convert this NFT to USD. So every time the user wins a bet and receives it, the winning amount is deposited into the person's wallet from the same game address. Here, I have checked how much of the address of the bet game was deposited to the user for each bet.
In the table and chart below, 5 addresses that have the most profit are shown. The second table also contains information such as betting transaction address, withdrawal transaction address, withdrawal transaction time, bet value, win value, profit, game, sport and league. In these two weeks, the address 0xbf3cbc3efdfa389bcacdbadc79d6349b81b2593e has had the largest amount of profit with 2800 USD bet and 11056 USD win and totally 8256 USD profit. The interesting thing is that this amount of profit is only with one bet related to fight Leon Edwards vs. Kamaru Usman (MMA) is acquired.
Wallet 0xcb938bbed7789ee8aabd259a8cb789aa3500bbf3 is in second place in terms of profit volume. This wallet has made 16 bets in these two weeks, the bet amount, win amount and profit amount of each game that this wallet has bet on are listed below.
| GAME | Total Bet Amount | Total Win Amount | Total Profit Amount |
|---|---|---|---|
| Werder Bremen - VfB Stuttgart(Soccer-Bundesliga) | 444.2327 | 1283.96 | 839.7273 |
| Brighton & Hove Albion - Newcastle United(Soccer-EPL) | 442.9727 | 1282.35 | 839.3773 |
| Hertha Berlin - Eintracht Frankfurt(Soccer-Bundesliga) | 432.6536 | 1249.2 | 816.5464 |
| AS Monaco - Stade Rennes(Soccer-League 1) | 388.6442 | 1122 | 733.3558 |
| Southampton - Leeds United(Soccer-EPL) | 231.8404 | 670.15 | 438.3096 |
Wallets 0x013316e97255b159fb90f344ecbd8d837c2f1063 with 3187 USD profit for the game Cádiz - Real Sociedad(Soccer-La liga), Wallet 0x7478bf358f55bf9709754105180f079035bc8180 with 2807 USD profit for game Texas Rangers - Seattle Mariners(Baseball) And wallet 0xf72dc326a6b0bc66794c9ab7ed0a4aa01bffb5a9 with 2661 USD profit for the game Salernitana - AS Roma (Soccer-Serie A) ranked third to fifth highest profit value in these two weeks.
in the charts below, bet amount (blue), total win amount (orange) and total profit amount (red) of top 5 traders in each game are shown. as you can see wallet 0x0291eb432cb4a2613a7415018933e3db45bcd769 with 514 USD profit has the highest profit amount in American Football game. wallet 0x7478bf358f55bf9709754105180f079035bc8180 with 2807 USD profit has the highest profit amount in Baseball game. wallet 0xbf3cbc3efdfa389bcacdbadc79d6349b81b2593e with 8256 USD profit has the highest profit amount in MMA game and wallet 0xcb938bbed7789ee8aabd259a8cb789aa3500bbf3 with 3667 USD profit has the highest profit amount in Soccer game.
Also, in the last chart, the total claimed in these two weeks in Overtime Markets is shown daily for each game.