CryptoIcicleSushi vs Uni on L2 - Uniswap
    Updated 2022-10-17
    -- Compare the market share of Sushiswap and Uniswap on the following L2 chains.

    -- Pay by Quality Your score determines your final payout.
    -- Grand Prize 85.308 SUSHI (A score of 11 or 12 earns you a Grand Prize title)
    -- Payout 56.872 SUSHI
    -- Score Multiplier 0-7 : 0% 8 : 50% 9 : 75% 10 : 100% 11 : 125% 12 : 150%
    -- Payout Network Ethereum
    -- Level Intermediate
    -- Difficulty Hard

    -- Compare the market share of Sushiswap and Uniswap on the following L2 chains.
    -- Polygon, Arbitrum, Optimism. Use measures such as number of trade or number of swaps, etc.
    with
    contracts as (
    select
    *
    from crosschain.core.address_labels
    where project_name = 'uniswap'
    and label_subtype = 'swap_contract'
    and blockchain in (
    'polygon',
    'arbitrum',
    'optimism'
    )
    ),
    swap_txns as (
    (select
    block_timestamp,
    tx_hash,
    origin_from_address as wallet,
    c.blockchain
    from arbitrum.core.fact_event_logs s
    join contracts c on s.event_name = 'Swap'
    and s.origin_to_address = c.address
    ) union
    Run a query to Download Data