DATE(block_timestamp) as day,

COUNT(DISTINCT tx_id) as tx_count

FROM terra.msgs

WHERE block_timestamp >= ADD_MONTHS(CURRENT_DATE, -6)

GROUP BY 1

ORDER BY 1 DESC