label,

sum(FROM_AMOUNT/pow(10,FROM_DECIMAL)) as volume,

count(tx_id) as no_swaps,

count(distinct trader) as swapper

from osmosis.core.fact_swaps s left join osmosis.core.dim_labels b on s.FROM_CURRENCY=b.address

where(POOL_IDS[0]=722) and TX_STATUS='SUCCEEDED'

and BLOCK_TIMESTAMP>=CURRENT_DATE-7

group by 1 having label is not null

order by 3 desc