shadilBettors that bets on Football 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 '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
    select '0x29cdc6a3c7d870162af548f72deca9588e4d6316' as match_address, 'Tampa Bay Buccaneers | Miami Dolphins' as match_name
    from dual union
    select '0x6dd469d060f58bac0704fa6a63859f4b6f23e81e' as match_address, 'Houston Texans | New Orleans Saints' as match_name
    from dual union
    select '0xb5024a5b991bcba0bb7805707f8c90663a1ccd63' as match_address, 'Denver Broncos | Dallas Cowboys' as match_name
    from dual union
    select '0xe0fdb22be9d8d1314fc6fbc8762d3f95c0f7dc68' as match_address, 'Los Angeles Chargers | Los Angeles Rams' as match_name
    from dual union
    select '0xa5c6db541895bed8af3960e9e09f0346d156dc10' as match_address, 'Las Vegas Raiders | Minnesota Vikings' as match_name
    from dual union
    select '0x8e63e3723dfbab33c03267ed1bc60cdbbc94625e' as match_address, 'Seattle Seahawks | Chicago Bears' as match_name
    from dual union
    select '0xa7f3adfd1bf0b28384a78d7b14ea5c8856690217' as match_address, 'New England Patriots | Carolina Panthers' as match_name
    from dual union
    select '0x27e425ca6c23dfd3b6cbf922fdc01b81ccb841e3' as match_address, 'Green Bay Packers | New Orleans Saints' as match_name
    from dual union
    select '0x9d5a7e89abe1810dda9de76be0083ecf828c5ddb' as match_address, 'Los Angeles Rams | Houston Texans' as match_name
    Run a query to Download Data