boomer77sushi kek
    Updated 2021-11-17
    with sushi_users as (
    select max(block_timestamp) as last_tx_from_sushi,
    origin_address as sushi_users
    from ethereum.udm_events
    where to_label like '%sushiswap%'
    and to_label_type is not null
    and amount_usd is not null
    and block_timestamp < current_date() - 30
    group by 2),

    last_tx as (
    select count(distinct sushi_users) as user_leaving,
    date_trunc('day',last_tx_from_sushi) as last_tx_date
    from sushi_users
    group by 2
    )

    select * from last_tx
    Run a query to Download Data