LABEL,

count(tx_id) as "swap count",

count(distinct trader) as "count of users",

sum(FROM_AMOUNT/1e6) as volume

from osmosis.core.fact_swaps,osmosis.core.dim_labels a join osmosis.core.dim_prices b on a.PROJECT_NAME = b.SYMBOL

where FROM_CURRENCY= 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'

and TO_CURRENCY = address

and pool_ids[0]=812

group by 1

order by 4 desc

limit 10