SELECT
DATE(block_timestamp) AS day,
COUNT(*) AS total_transactions
FROM
aptos.core.fact_transactions
WHERE
sender = '0x59e802ff9d63b377998e1959cc297798a4d2de0cdf17b3194b2dcff4af4f9441'
AND json_extract_path_text(payload, 'function') LIKE '0x59e802ff9d63b377998e1959cc297798a4d2de0cdf17b3194b2dcff4af4f9441::flt_fa_coin%'
AND success = 'true'
GROUP BY
day
ORDER BY
day;