SELECT
date_trunc('day', block_timestamp) AS dt
, COUNT(DISTINCT trader) AS swapper
, COUNT(DISTINCT tx_id) AS swaps
FROM
osmosis.defi.fact_swaps
WHERE
date_trunc('day', block_timestamp) >= CAST('2023-01-01' AS TIMESTAMP)
AND tx_succeeded = 'true'
GROUP BY 1
ORDER BY 1