DATE(block_timestamp) AS day,

COUNT(*) AS total_transactions

aptos.core.fact_transactions

json_extract_path_text(payload, 'function') IN (

'0x77fd4b106c60d492617014e08505ef3be53085880ac63d6d43bcd82cd1091f9f::flt_coin::mint_v2',

'0x77fd4b106c60d492617014e08505ef3be53085880ac63d6d43bcd82cd1091f9f::flt_coin::mint'

)

AND success = 'true'

AND block_timestamp >= CURRENT_DATE - INTERVAL '90 days'

GROUP BY

DATE(block_timestamp)

ORDER BY

day;