date(BLOCK_TIMESTAMP) AS DAY,

FROM_AMOUNT_USD AS USD_SIZE,

when FROM_ASSET='THOR.RUNE' then FROM_AMOUNT

else TO_AMOUNT end AS RUNE_SIZE

from thorchain.defi.fact_swaps)

select

case

when USD_SIZE <= 10 then 'less than 10 USD'

when USD_SIZE >10 and USD_SIZE <= 100 then 'between 10 and 100 USD'

when USD_SIZE >100 and USD_SIZE <= 1000 then 'between 100 and 1000 USD'

when USD_SIZE >1000 and USD_SIZE <= 10000 then 'between 1,000 and 10,000 USD'

when USD_SIZE >10000 and USD_SIZE <= 100000 then 'between 10,000 and 100,000 USD'

when USD_SIZE >100000 then 'greater than 100,000 USD'

end AS "swap size",

count("swap size") AS "number of swaps"

from tb where DAY >= CURRENT_DATE - 30 group by 1