count(DISTINCT tx_hash) as txs,

count(DISTINCT trader) as users,

count(DISTINCT pool_id) as pools

from near.core.ez_dex_swaps

where platform = 'v2.ref-finance.near'

and block_timestamp >= '2022-08-01'

group by 1

UNION ALL

select 'Sushiswap' as platform,

count(DISTINCT tx_hash) as txs,

count(DISTINCT origin_from_address) as users,

count(DISTINCT pool_name) as pools

from ethereum.sushi.ez_swaps

where block_timestamp >= '2022-08-01'

group by 1