shadilTop games with highest profit for users in Baseball games
    Updated 2022-08-22
    with query_1 as (select optimism.core.fact_event_logs.event_inputs:account as bettor,
    optimism.core.fact_event_logs.event_inputs:value/pow(10, 18) as bet_total,
    match_name
    from optimism.core.fact_event_logs join (select '0xc7e8b40bfc2609becfab32dee7330b687b0611fd' as match_address, 'Chicago White Sox | Minnesota Twins' as match_name
    from dual union
    select '0xb55a10da20ba4f2ddfdb470103143e6baba769dd' as match_address, 'Milwaukee Brewers | Chicago Cubs' as match_name
    from dual union
    select '0x06eb14d138161508f02d517f4d3c792efde1d692' as match_address, 'Houston Astros | Kansas City Royals' as match_name
    from dual union
    select '0xd438a559b880293808079aec4d12432221fc73a5' as match_address, 'Arizona Diamondbacks | San Francisco Giants' as match_name
    from dual union
    select '0x108267d6cd22291568e9260df5c122122de26e83' as match_address, 'Oakland Athletics | Toronto Blue Jays' as match_name
    from dual union
    select '0x6d62cc028082fb750957375129fd3d313867fc60' as match_address, 'Los Angeles Dodgers | Colorado Rockies' as match_name
    from dual union
    select '0xedb993c2532d2dee8e80b1ce9e99bf2531f8d805' as match_address, 'Detroit Tigers | Cleveland Guardians' as match_name
    from dual union
    select '0xe91a8ca5ee5e6bd615039a5595b3d57fca18a488' as match_address, 'Chicago White Sox | Minnesota Twins' as match_name
    from dual union
    select '0x03c2d5cc9e8791afa172b3d0a6f0f50aa110aa44' as match_address, 'Milwaukee Brewers | Chicago Cubs' as match_name
    from dual union
    select '0xd088a349d9e29f002853cb70ec5caf5c5691b9ea' as match_address, 'Oakland Athletics | Toronto Blue Jays' as match_name
    from dual union
    select '0x935fdc590d7e9dc1f72a1c3aff1011c7612a0a41' as match_address, 'Cincinnati Reds | New York Mets' as match_name
    from dual union
    select '0xafc3fb03ea531cf24da1bb41fcb43b696758c1ba' as match_address, 'Miami Marlins | Los Angeles Angels' as match_name
    from dual union
    select '0x074617d7ecb70562ea8f9f5f58c2ae4cba391e8c' as match_address, 'Atlanta Braves | St. Louis Cardinals' as match_name
    from dual union
    select '0x733e2ea88cef947b0f93cb7ac9b401497a3ccf5f' as match_address, 'Philadelphia Phillies | Washington Nationals' as match_name
    from dual union
    select '0x781916f5a2b14cc3568b75a9198d37abc0532705' as match_address, 'Pittsburgh Pirates | New York Yankees' as match_name
    from dual union
    select '0x891f09b247d6ce4305a821ba7a41b09e6defa738' as match_address, 'Baltimore Orioles | Texas Rangers' as match_name
    from dual union
    select '0x87b2abfbaaed7d340932832e455505df5bd1e8dc' as match_address, 'Boston Red Sox | Tampa Bay Rays' as match_name
    Run a query to Download Data