block_timestamp::date AS utc_date

, count(*) AS transactions

, avg(CASE WHEN succeeded = True THEN 100.0000 ELSE 0.0000 END) AS success_rate

FROM solana.core.fact_transactions

WHERE block_timestamp >= CURRENT_TIMESTAMP - interval '30 days'

AND (log_messages::string LIKE '%675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8%'

OR log_messages::string LIKE '%5quBtoiQqxF9Jv6KYKctB59NT3gtJD2Y65kdnB1Uev3h%'

)

GROUP BY 1

LIMIT 100