with thorchain as (select date_trunc('week', block_timestamp) as week,

'THORChain' as platform,

sum(from_amount_usd) as tc

from thorchain.defi.fact_swaps

where block_timestamp >= '2022-01-01'

group by 1),

uniswap as (select date_trunc('week', block_timestamp) as week,

'Uniswap' as platform,

sum(amount_in_usd) as uni

from ethereum.defi.ez_dex_swaps

where block_timestamp >= '2022-01-01'

and platform in ('uniswap-v2', 'uniswap-v3')

group by 1),

sushiswap as (select date_trunc('week', date) as week,

'SushiSwap' as protocol,

sum(volume) as sushi

from external.defillama.fact_dex_volume

where protocol in ('sushiswap')

and date >= '2022-01-01'

group by 1)

select a.week,

tc as "THORChain",

uni as "Uniswap",

sushi as "Sushiswap",

from thorchain a

join uniswap b on a.week = b.week

join sushiswap c on a.week = c.week

order by 1