date_trunc('hour', block_timestamp) as hour,

count(DISTINCT tx_id) as events,

count(DISTINCT signers[0]) as buyers,

(sum(pre_balances[0] - post_balances[0])/power(10,9)) as volume

from eclipse.core.fact_transactions

WHERE ((log_messages[0] LIKE 'Program Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic invoke [1]' and log_messages[1] LIKE 'Program log: Instruction: FillOrder')

OR (log_messages[2] LIKE 'Program Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic invoke [1]' and log_messages[3] LIKE 'Program log: Instruction: FillOrder'))

and block_timestamp > '2024-12-05 14:00:00.000'

AND SUCCEEDED

GROUP BY 1