CryptoIcicleSushi-86.Sushi during Volatile Times II
    Updated 2022-05-30
    -- Sushi during Volatile Times II
    -- Payout 62.89 SUSHI
    -- Grand Prize 188.68 SUSHI
    -- Level Intermediate

    -- Q86. During the recent spike in market volatility, which chain saw the most activity in swaps for sushi? Polygon, Ethereum or Harmony?
    -- Hint: For harmony and ethereum swap info, you can use the table in the easy swap table in the crosschain schema

    with
    swaps_sushi_eth as (
    select
    block_timestamp::date as date,
    count(distinct tx_hash) as n_txns,
    sum(n_txns) over (order by date asc rows between unbounded preceding and current row) as cum_n_txns
    from flipside_prod_db.ethereum_core.ez_dex_swaps
    where block_timestamp >= {{start_date}} and (symbol_in = 'SUSHI' or symbol_out = 'SUSHI')
    group by date
    ),
    swaps_sushi_harmony as (
    select
    block_timestamp::date as date,
    count(distinct tx_hash) as n_txns,
    sum(n_txns) over (order by date asc rows between unbounded preceding and current row) as cum_n_txns
    from flipside_prod_db.crosschain.ez_swaps
    where block_timestamp >= {{start_date}} and (symbol_in = '1SUSHI' or symbol_out = '1SUSHI') and blockchain = 'Harmony'
    group by date
    ),
    swaps_sushi_polygon as (
    select
    block_timestamp::date as date,
    count(distinct tx_id) as n_txns,
    sum(n_txns) over (order by date asc rows between unbounded preceding and current row) as cum_n_txns
    from flipside_prod_db.polygon.events_emitted
    where block_timestamp >= {{start_date}}
    and event_name = 'Swap'
    and (
    Run a query to Download Data