f.value as Contracts,

count(tx_id) as interaction

from osmosis.core.fact_swaps, table(flatten(osmosis.core.fact_swaps.pool_ids)) f

where block_timestamp > '2022-05-01'

and tx_status = 'SUCCEEDED'

group by contracts

order by interaction DESC

limit 10