split(pool_name,'-')[0] as "Pool",

count(DISTINCT tx_id) as "Transactions",

count(DISTINCT from_address) as "Users",

sum(from_amount_usd) as "USD Volume"

from thorchain.defi.fact_swaps

where block_timestamp::date >= current_date-30

group by 1

order by 4 desc