bertaWhales Goin’
    Updated 2022-02-01
    with table1 as (select
    date_trunc('day', block_timestamp) as day,
    origin_address as users_leaving,
    sum(amount_usd) as amount_out
    from ethereum.udm_events
    where ORIGIN_FUNCTION_NAME like 'removeLiquidity%'
    and to_label = 'sushiswap'
    and day >= CURRENT_DATE-60
    group by 1,2)
    select day, count (DISTINCT users_leaving) as number_of_whales from table1 where amount_out >=37277400
    group by 1

    Run a query to Download Data