Overtime Markets - Volume
methods :
-
finding sum of sent value to 0x170a5714112daeff20e798b6e92e25b86ea603c1 from INPUT_DATA column from
optimism.core.fact_transactions
as total volume. -
finding information of each game such as game contract , home team , away team and sport code.
from DATA column of
optimism.core.fact_event_logs
table. -
joining these informations on contract game.
-
finding the game that had the most bets on.
-
finding the game that had the most dollar value of bet.
-
categorizing dollar value of bets to each sport
we had two type of transferred value ,
1st ones that used sUSD for paying . these transactions had 18 decimals for transferred value.
2nd others that used USDC , USDT and DAI for paying . these transactions had 6 decimals for transferred value.
we divided them and sumed transferred value to 0x170a5714112daeff20e798b6e92e25b86ea603c1 address each day and also total since last two weeks .
here is the result :
we found informations of each game such as game contract , home team , away team and sport code from DATA column of optimism.core.fact_event_logs
table.
then we found sent value to 0x170a5714112daeff20e798b6e92e25b86ea603c1 from INPUT_DATA column from optimism.core.fact_transactions
for each game contract as game volume.
and finally we ordered games by number of bets on each game and also value of bet on each game and selected top 10 of them.
here is the result
ordered by number of bets on
ordered by total volume of bets on each game
we found each sport code then categorized them using picture bellow
Appendix:
Data provided from app.flipsidecrypto.com
Conclusion:
-
at the time that this dashboard where written , in last two week
(10 aug-23 aug), 14 aug had the most volume with 70.367 k $ volume.
-
these games were the top 3 games based on number of bets at that time.
home team away team number of bets
Baltimore Orioles Boston Red Sox 113Manchester United Liverpool 48
Cincinnati Reds Chicago Cubs 46
-
these games were the top 3 games based on dollar volume of bets at that time.
home team away team number of bets
Boston Red Sox New York Yankees 22049 $Cincinnati Reds Chicago Cubs 16810 $
Leon Edwards Kamaru Usman 14978 $
distribution of volume between each sport was like this
Baseball 125355 $
MMA 29413 $
Soccer 26661 $
Footbal 15734 $
you can run the query again to get last 14 days data