select

distinct pool_ids[0] as pool,

count(*)

from osmosis.core.fact_swaps

where block_timestamp > '2022-05-01'

group by 1

order by 2 DESC

limit 10 )

select

date_trunc('day', block_timestamp),

pool_ids[0],

count(*)

from osmosis.core.fact_swaps

where block_timestamp > '2022-05-01'

and pool_ids[0] in (select pool from tab1)

group by 1, 2