SELECT date_trunc('day',block_timestamp) as dt1,

count(distinct SWAPPER) as algofi_wallets

from algorand.swaps

where SWAP_PROGRAM = 'algofi'

group by 1),

t2 as (

SELECT date_trunc('day',block_timestamp) as dt2,

count(distinct SWAPPER) as tinyman_algofi

from algorand.swaps

where SWAP_PROGRAM = 'algofi'

and SWAPPER in (

select SWAPPER from algorand.swaps

where SWAP_PROGRAM = 'tinyman'

) group by 1

select

t1.dt1 as dt,

algofi_wallets,

tinyman_algofi,

tinyman_algofi/algofi_wallets*100 as wallet_percent

from t1 inner join t2 on t1.dt1=t2.dt2