account.address as address,

account.created_at as Block_created,

block.block_timestamp as createdat

FROM

algorand.account account

INNER JOIN

algorand.block block

ON account.created_at=block.block_id

WHERE

address in (

select distinct swapper as wallets

FROM

algorand.swaps

where

SWAP_PROGRAM in ('pactfi','algofi','wagmiswap', 'tinyman') and

block_timestamp::date >= '2022-05-01' and block_timestamp::date <= '2022-06-30'

)

group by 1,2,3