top 15 CASE WHEN b.token0_contract is null OR b.token1_contract is null then regexp_substr(a.swap_contract ,'\\w+', 1, 3)

ELSE regexp_substr(b.token0_contract,'\\w+', 1, 3) || '-' || regexp_substr(b.token1_contract,'\\w+', 1, 3) END as pools,

COUNT(DISTINCT a.trader) as n_swappers

FROM flow.core.ez_swaps a

LEFT JOIN flow.core.dim_swap_pool_labels b

ON a.swap_contract = b.swap_contract

WHERE date_trunc('day',block_timestamp) between CURRENT_DATE-30 AND CURRENT_DATE-1

GROUP BY pools

ORDER BY n_swappers DESC