Overtime Markets - Volume

Analyze Overtime Markets, activity (Volume and users) in the last 2 weeks

Introduction

what is Overtime Markets?

Is an on-chain built AMM on the Optimism layer with multiple sports markets, and is supported by Thales AMM and Chain link oracles. Overtime is a fully decentralized, on-chain sports platform offering users a complete sports trading experience.

\n

\n

I get the information about each game from their contract creation transaction, which the contract address for this transaction is 0x2b91c14ce9aa828ed124d12541452a017d8a2148

SELECT concat('0x',substr(data,27,40)) as game_contract, HEX_DECODE_STRING( substr(data,3+13*64,64) ) as home_team, HEX_DECODE_STRING( substr(data,3+15*64,64) ) as away_team, concat(home_team,'vs ',away_team), tokenflow_eth.hextoint( substr(data,1091,64) ) as sport from optimism.core.fact_event_logs where topics[0] = '0x889e2060e46779287c2fcbf489c195ef20f5b44a74e3dcb58d491ae073c1370f' and contract_address = '0x2b91c14ce9aa828ed124d12541452a017d8a2148'
for Volume and users Data I used 0x170a5714112daeff20e798b6e92e25b86ea603c1 contract with help of

optimism.core.fact_transactions table
the query for Top games base on Volume and number of users :

Top games base on Volume : Link

Top games base on number of users: Link

\n

\n

The Total Volume for last 2 weeks is 292K USD and The Total number user for last 2 weeks is 541 User
Baseball had the highest VOLUME with 154.8K USD
Baseball had the highest number of user with 294 user
Most of the days, Baseball had the highest Volume and users activity
Boston Red Sox vs New York Yankees has the highest Volume in the last 2 weeks base on Volume activity
Baltimore Orioles vs Boston Red Sox has the highest activity base on users in the last 2 weeks

here, we aim to provide this analyzes:

Discord: Abbas_ra21

At 154.8K USD, Baseball had the highest VOLUME and was 603.18% higher than Football, which had the lowest VOLUME at 22K USD.
Baseball accounted for 53.12% of VOLUME.
At 294, Baseball had the highest number of user and was 390.00% higher than MMA, which had the lowest number of user at 60.
Baseball accounted for 43.43% of number of user.
We can see clearly users attracted more to trade on baseball more than others
The most recent VOLUME anomaly was on Wednesday, January 19, 2022, when MMA had a high of 16.9K and was the highest sport Volume
Across SPORTS, Football had the most interesting recent trend and started trending up on Sunday, January 16, 2022, rising by 6,503.89% (4.54K USD) in 9 days.
Most of the days, Baseball had the highest Volume
number of user for Soccer started trending down on Thursday, January 20, 2022, falling by 93.22% (55) in 5 days.
Number of user for Baseball started trending up on Monday, January 17, 2022, rising by 142.31% (37) in 4 days.
We can see clearly baseball has the highest activity among the sports most of the days

The Total Volume for last 2 weeks is 292K USD
AT 70.32K USD, Aug 14th has the highest Volume, 2,433% higher than Aug 15th which was the lowest AT 2.8K USD
we can see clearly that the Volume on the first week was higher than the second week
if we compare the first day Volume to the last one, we can see a decrease in the Volume
The Total number user for last 2 weeks is 541 User
AT 143 user, Aug 21st has the highest activity base on number of users, 348% higher than Aug 25th which was the lowest AT 41 user
we can see clearly that activity base on users was higher on the second week compare to the first one

Information:

In above figures we can see the top games base on Volume and Users activity.

Boston Red Sox vs New York Yankees has the highest Volume in the last 2 weeks base on Volume activity
Baltimore Orioles vs Boston Red Sox has the highest activity base of users in the last 2 weeks
both above games belongs to baseball and that shows us the popularity of this sport for the platform users