Methodology:

1- To extract the total and daily volume, the optimism.core.fact_event_logs table was used and we set the ORIGIN_TO_ADDRESS field equal to the address 0x170a5714112daeff20e798b6e92e25b86ea603c1

2- 4 tokens are used in bets, which are USDT,DAI,sUSD,USDC

==3==- To extract the names of the teams using the hex_decode_string function and the game market maker contract 0x2b91c14ce9aa828ed124d12541452a017d8a2148, the names of the games and teams were extracted

==4==- The following method was used to extract the names of the games In the optimism.core.fact_event_logs table The DATA field after using the function ethereum.public.udf_hex_to_int and separating the strings, it was found that the names of the games start with 90, for example 9002 is the game 'NCAA - American Football'.

In the chart below, the wallets that bet are checked based on dollar volume

==1==- First rank→ 0xf7****516

2- Second rank→ 0x7c****9bb

In the chart below, the wallets that have bet are checked based on the number of bets

==1==- First rank→ 0xfb****bd

*2- Second rank**→ *0x49****b4

In the chart below, the wallets that have bet are checked based on dollar volume and percentage

in the diagram daily basis Dollar volume of bets By tokens checked Based on this, the highest bet was on August 14

In the following two charts:

==1==- On a daily basis, the number of bets has been checked separately by 4 tokens

→ The highest bet was on August 20

==2==- It has been checked as a percentage in terms of the volume of the tokens with which bets have been made

→ sUSD token ranks first with 86%

In the following two graphs according to the dollar volume:

The most popular teams were analyzed in terms of percentage and volume

==→== The most popular team Boston Red Sox with about 15%

==→== The second place of the New York Yankees team with about 13%

In the following two graphs, according to the popularity among users in betting:

==→== The most popular team Boston Red Sox with about 15%

==→== Baltimore Orioles second place with about 14%

In the following two graphs, sports are classified according to dollar volume:

==→== MLB's most popular sport - Baseball with about 58%

==→== The second rank of MMA sport with about 18%

In the two graphs below, sports are classified according to the number of users:

==→== The most popular MLB sport - Baseball with about 46%

==→== The second rank of EPL sports - Soccer with about 11%

In the two graphs below, the teams were analyzed in terms of the number of bettors and the amount of dollars :

==→== The most user is for MLB

==→== The largest volume of dollars is also for MLB

In the two graphs below The number of users and the amount of dollars bet on a daily basis It has been checked for sports

==→== The most bets in terms of the number of users on August 20

==→== The highest volume of betting was on August 14

In the two graphs below The number of users and the amount of dollars bet on a daily basis

==→== Sports have been evaluated in terms of growth Witness the growth of MLB in terms of dollar volume until the 14th And we are growing MMA from August 19 August and after that, the dollar volume has decreased

==→== Also the growth of MLB in terms of the number of users

Conclusion:

In the dashboard, we reviewed Overtime Markets - Volume in the past two weeks→

Based on this:

==1== - most popular sport among users for betting is MLB - Baseball

==2== - and also in terms of dollar volume And the most popular games in terms of dollars are Boston Red Sox-New York Yankees

==3== - And the most popular game in terms of the number of betting users It was Baltimore Orioles-Boston Red Sox

==4== - And the most popular team in terms of dollar volume of bets and number of users Boston Red Sox

Discord ID: Sal☰h#1747

email : saleh.mz@gmail.com

**twitter : **

In the two graphs below, the most popular games were examined in terms of dollar volume and number of games:

→ The highest dollar volume bet comment for the game Boston Red Sox-New York Yankees

→ Most bettors for Baltimore Orioles-Boston Red Sox game