'Swapper' as "Type",

date_trunc('week',block_timestamp) as "Week",

count(distinct trader) as "Active User"

from near.core.ez_dex_swaps

where block_timestamp >= '2023-01-01'

and platform = 'v1.jumbo_exchange.near'

group by 1,2

union all

SELECT

'Signer' as "Type",

date_trunc('week',block_timestamp) as "Week",

count(distinct tx_signer) as "Active User"

from near.core.fact_transactions

where block_timestamp >= '2023-01-01'

and tx_receiver='v1.jumbo_exchange.near'

group by 1,2

union all

SELECT

'$JUMBO Swapper' as "Type",

date_trunc('week',block_timestamp) as "Week",

count(distinct trader) as "Active User"

from near.core.ez_dex_swaps

where block_timestamp >= '2023-01-01'

and (token_in='JUMBO' or token_out='JUMBO')

group by 1,2