WITH

t1 as (

select

trunc(block_timestamp,'month') as date,

count(distinct tx_signer) as users

FROM near.core.fact_transactions

where tx_status = 'Success'

group by 1

),

t2 as(

SELECT

trunc(block_timestamp,'month') as date,

count(distinct tx_signer) as users

FROM near.core.fact_transactions

WHERE tx_receiver = 'token.jumbo_exchange.near' and tx_status = 'Success'

group by 1

)

SELECT

ifnull(t1.date,t2.date) as date,

ifnull(t1.users,0) as near_users,

ifnull(t2.users,0) as jumbo_users,

jumbo_users/near_users as share_rate

from t1

left join t2 on t1.date=t2.date

where t1.date>=CURRENT_DATE-INTERVAL '1 YEAR'

order by 1 asc