Identify the 5 most profitable traders on Overtime Markets in the last two weeks. How much has each wallet won by sport?

\n

Top 5 users

• The first user gained 9244 USD as a profit. This user gained 17.5k by making almost 8k bets.
• The second user of the top 5 users gained 8.2k profit. This wallet gained 11k by 2.8k bets.
• The third one gained almost 8.2k profit. This wallet used 4k USD to make bets and gained 11k.

Top 5 users based on games

\

• The first wallet of the top 5 based on the team gained 9224 as profit. This wallet made 8.2k bets and gained 17.5k USD wins. The first wallet gained profit by making bets on Boston Red VS. New York Yankees team.

• The second wallet made bets on Leon Edwards VS. Kamaru Usman. More than 5.2k USD was used to make bets and won 11k USD.

  \

• The third wallet gained 8256 USD as profit. This profit gained by 5297 USD for the bet and won 10.3k USD. This wallet made bets on Buffalo bills VS. Indianapolis Colts.

Top 5 users based on sports

• The first wallet gained 9.2k profits by making bets on Baseball. This wallet put 8.2k USD on Baseball games and won 17.5k.
• The second wallet gained 8.2k profits on MMA. This wallet put 2.8k USD on MMA games and won 11.05k.
• The third wallet gained almost 7k profits on MMA. This wallet put 4k USD on Baseball games and won 11k.

Info

Thales protocol

Thales is a protocol that allows for the creation of peer-to-peer parimutuel markets that anyone can join. A Parimutuel Market is a market where the collateral is locked in a pool, and the final payout to participants is not determined until after the market-settling event finalizes. There are several types of markets, including Up and Down markets, ranged markets, exotic markets, and Overtime Markets.

What’s Overtime?

Overtime is a fully on-chain sports AMM (Automated market maker) that operates Chainlink sports data provides to fetch chances updates (before matches begin) and final results (once matches end). The Overtime platform is deployed on the Optimism network, leveraging low-cost transaction fees and near-instant verifications.

\

table: from optimism.core.fact_token_transfers

Info

The name of the games was written by help mohsen#4796

VALUES 
(9010, 'Soccer'),
(9003, 'Baseball'),
(9013, 'Soccer'),
(9012, 'Soccer'),
(9011, 'Soccer'),
(9014, 'Soccer'),
(9002, 'Football'),
(9015, 'Soccer'),
(9007, 'MMA')

where event_name = 'OptionsExercised' 
and block_timestamp::date >= CURRENT_DATE - 14