adriaparcerisasSushi vs Uni on L2
Updated 2022-11-18
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
trunc(block_timestamp,'month') as date,
case when project_name = 'sushiswap' then 'Sushiswap'
else 'Uniswap' end as platform,
count(distinct tx_hash) as swaps,
count(distinct origin_from_address) as users,
swaps/users as swaps_per_user
from arbitrum.core.fact_event_logs left join arbitrum.core.dim_labels ON contract_address = address
where (project_name = 'sushiswap' or project_name like '%uniswap%')
and address is not null
GROUP BY 1,2
order by 1 asc
Run a query to Download Data