boomer77sushi kek
Updated 2021-11-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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