shadilTop 10 matches with highest number of bettors (Football)
Updated 2022-08-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with q1 as (select optimism.core.fact_event_logs.event_inputs:from as bettor,
optimism.core.fact_event_logs.event_inputs:value/pow(10, case
when optimism.core.fact_event_logs.contract_address ilike lower('0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9') then 18
when optimism.core.fact_event_logs.contract_address ilike lower('0x7f5c764cbc14f9669b88837ca1490cca17c31607') then 6
when optimism.core.fact_event_logs.contract_address ilike lower('0x94b008aa00579c1307b0ef2c499ad98a8ce58e58') then 6
when optimism.core.fact_event_logs.contract_address ilike lower('0xda10009cbd5d07dd0cecc66161fc93d7c9000da1') then 18
when optimism.core.fact_event_logs.contract_address ilike lower('0xc40f949f8a4e094d1b49a23ea9241d289b7b2819') then 18
when optimism.core.fact_event_logs.contract_address ilike lower('0xcb8fa9a76b8e203d8c3797bf438d8fb81ea3326a') then 18
when optimism.core.fact_event_logs.contract_address ilike lower('0x4200000000000000000000000000000000000006') then 18
when optimism.core.fact_event_logs.contract_address ilike lower('0xe405de8f52ba7559f9df3c368500b6e6ae6cee49') then 18 end) as total,
regexp_substr_all(substr(joined_table1.data, 3, len(joined_table1.data)),'.{64}')[1] as s1,
concat('0x', substr(s1, 25, len(s1))) as ad
from optimism.core.fact_event_logs join optimism.core.fact_event_logs joined_table1
on joined_table1.tx_hash = optimism.core.fact_event_logs.tx_hash
where optimism.core.fact_event_logs.origin_from_address = optimism.core.fact_event_logs.event_inputs:from
and optimism.core.fact_event_logs.block_timestamp >= '2022-08-05' -- Since two weeks ago
),
q2 as (
SELECT q1.*, table1.match_name from q1
join (select '0x03d27f89edc8c0b708deeb9cda38364ba1e45744' as match_address, 'Jacksonville Jaguars | Cleveland Browns' as match_name
from dual union
select '0x6a52b15095e20817782458a5295d5fa0858b433f' as match_address, 'Cincinnati Bengals | Arizona Cardinals' as match_name
from dual union
select '0x9374b12c6421b800cf65b524fb2da578168f79c3' as match_address, 'Philadelphia Eagles | New York Jets' as match_name
from dual union
select '0x85e0ce099b2cc4ac09309728806dd77eadf899dc' as match_address, 'San Francisco 49ers | Green Bay Packers' as match_name
from dual union
select '0x5edf6db3e2d5162b3da47761adc3fbfcca0001f0' as match_address, 'Washington Football Team | Carolina Panthers' as match_name
from dual union
select '0x4a582596caf8c7546e53ec904e88b62c3484b86c' as match_address, 'Chicago Bears | Kansas City Chiefs' as match_name
from dual union
select '0xdfd8048aad87dd43d1e90f6c57c3bf75c265f2be' as match_address, 'Buffalo Bills | Indianapolis Colts' as match_name
from dual union
select '0xe0a4a153c8581995f9bc729cdd177172bf3971b0' as match_address, 'Pittsburgh Steelers | Seattle Seahawks' as match_name
from dual union
Run a query to Download Data