BLOCK_TIMESTAMP::date as day,

count(distinct trader) as swapper,

count(distinct tx_id) as swaps

from osmosis.core.fact_swaps where POOL_IDS[0]=812 and TX_STATUS='SUCCEEDED'

group by 1

order by 1