date_trunc('day', block_timestamp) as day,

count(*) as other_DEx_swaps

from algorand.swaps

WHERE date_trunc('day', block_timestamp) >= '2022-01-01'

AND swap_program NOT ILIKE '%tinyman%'

and swap_from_amount > 0

group by day

ORDER BY day DESC;