date_trunc('day', block_timestamp) as day,

COUNT(DISTINCT tx_id) as tx_count

FROM terra.msgs

WHERE day >= CURRENT_DATE - 30

GROUP BY 1

ORDER BY 1 DESC