adambalaTrend Analysis
Updated 2022-04-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select date_trunc('day',block_timestamp) as date , count(distinct origin_address) as users,
case when (to_label ilike '%sushiswap%' or from_label ilike '%sushiswap%') then 'sushiswap'
when (to_label ilike '%uniswap%' or from_label ilike '%uniswap%') then 'uniswap' end as platform
from ethereum.udm_events
where (to_label ilike '%sushiswap%' or from_label ilike '%sushiswap%') or (to_label ilike '%uniswap%' or from_label ilike '%uniswap%')
and block_timestamp::date > current_date-356
group by 1,3
Run a query to Download Data