DATE_TRUNC('day', BLOCK_TIMESTAMP) as DATE,

COUNT(DISTINCT FROM_ADDRESS) as Daily_CheckIn

FROM bsc.core.fact_transactions

WHERE TO_ADDRESS = LOWER('0xCac410CD44717311F63aAf6081CB07244F10844f')

AND STATUS = 'SUCCESS'

AND ORIGIN_FUNCTION_SIGNATURE = '0xe95a644f'

AND BLOCK_TIMESTAMP > '2023-12-18'

GROUP BY 1

ORDER BY 1 ASC