CryptoIcicleSushi-86.Sushi during Volatile Times II
Updated 2022-05-30
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
›
⌄
-- 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