DATE(block_timestamp) as day,

COUNT(DISTINCT tx_id) as tx_count

FROM terra.msgs

WHERE day <= (CURRENT_DATE - 1)

GROUP BY 1

ORDER BY 1 DESC