date_trunc('day', block_timestamp) as day,

count(*) as Tiny_sawps

from algorand.swaps

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

AND swap_program ILIKE '%tinyman%'

and swap_from_amount > 0

group by day

ORDER BY day DESC;