select count(distinct blockchain) as count_blockchain

from thorchain.swaps

where block_timestamp::date BETWEEN '2021-04-11' AND '2021-05-10'

),

last_30_days AS (

select count(distinct blockchain) as count_bc

from thorchain.swaps

WHERE block_timestamp::date BETWEEN DATEADD(day,-30,GETDATE()) AND CURRENT_DATE

select count_blockchain , 'first 30 days' as period

from first_30_days

select count_bc, 'last 30 days' as period

from last_30_days