SELECT

date_trunc ('day', block_timestamp) as _date,

count(DISTINCT origin_from_address) as uniusers,

CASE

WHEN platform IN ('uniswap-v2', 'uniswap-v3') THEN 'uniswap'

else 'other'

END as platform

FROM ethereum.core.ez_dex_swaps

WHERE platform IN ('uniswap-v2', 'uniswap-v3')

AND block_timestamp::date >= current_date -30

group by _date, platform

),

sushiswap as (

SELECT

date_trunc ('day', block_timestamp) as _date,

count(DISTINCT origin_from_address) as sushiusers,

CASE

WHEN platform = 'sushiswap' THEN 'sushiswap'

else 'other'

END as platform

FROM ethereum.core.ez_dex_swaps

WHERE platform = 'sushiswap'

AND block_timestamp::date >= current_date -30

group by _date, platform

Select

sushiswap._date,

uniswap.platform,

sushiusers,

uniusers

FROM uniswap

LEFT JOIN sushiswap

on uniswap._date = sushiswap._date