kingharald-ethCompare loyalty of users in different situation
    Updated 2022-06-15
    with list1 as (
    select distinct(ORIGIN_FROM_ADDRESS) as wallet_address from ethereum.core.ez_dex_swaps
    where SYMBOL_IN = 'stETH'
    and block_timestamp::date between '2021-10-21' and '2021-12-27'
    ), list2 as (
    select count(distinct(ORIGIN_FROM_ADDRESS)) as down_wallets_count from ethereum.core.ez_dex_swaps
    where SYMBOL_OUT = 'stETH'
    and block_timestamp::date between '2022-05-12' and '2022-06-16'
    and exists (select * from list1 where list1.wallet_address = ORIGIN_FROM_ADDRESS) ),
    list3 as ( select count (wallet_address) as up_wallets_count from list1)
    select up_wallets_count, down_wallets_count from list2 join list3
    Run a query to Download Data