JabiSports receving most bets
Updated 2022-08-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with sport as (select tokenflow_eth.hextoint(substr(data,3+17*64,64)) as sport,
case
when sport in ( 9001, 9002) then 'Footbal '
when sport = 9003 then 'Baseball '
when sport = 9007 then 'MMA'
when sport in ( 9010,9011, 9012,9013, 9014,9015, 9016) then 'Soccer'
End as name
from optimism.core.fact_event_logs
where topics ilike '%0x889e2060e46779287c2fcbf489c195ef20f5b44a74e3dcb58d491ae073c1370f%'
and BLOCK_TIMESTAMP > CURRENT_DATE - 14)
select name, count(name) as sport
from sport
group by 1
order by 2 desc
Run a query to Download Data