bertaWhales Goin’
Updated 2022-02-01Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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