,count(distinct TX_ID) as tx_count

,sum(FROM_AMOUNT/1e6) as swap_volume

,rank() over(order by swap_volume)as rank

from terra.core.ez_swaps

where FROM_CURRENCY='uluna'

and BLOCK_TIMESTAMP>='2022-12-25' and BLOCK_TIMESTAMP<'2023-01-07'

and TX_SUCCEEDED='TRUE'

group by 1

order by 3 desc

limit 10