SELECT DATE(block_timestamp) AS date_ ,address

FROM algorand.transaction_participation

WHERE YEAR(block_timestamp)>=2022 AND DATE(block_timestamp)<CURRENT_DATE

GROUP BY address

ORDER BY DATE(block_timestamp);