SELECT

DATE(CREATED_AT) AS TRANSACTION_DATE,

COUNT(*) AS TOTAL_TRANSACTIONS

FROM

axelar.axelscan.fact_gmp

WHERE

DATA LIKE '%0xce16f69375520ab01377ce7b88f5ba8c48f8d666%'

AND DATE(CREATED_AT) = '2024-06-1'

GROUP BY

DATE(CREATED_AT)

ORDER BY

TRANSACTION_DATE;