trader as buyer,

sum(TO_AMOUNT/pow(10,6)) as amount

from osmosis.core.fact_swaps

where TO_CURRENCY = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'

and BLOCK_TIMESTAMP >= CURRENT_DATE - 30

group by 1

order by 2 desc

limit 10