log_messages[1] AS logMsg,

min(block_timestamp) AS genesis,

count(1) AS events,

min(tx_id) AS genesisTx,

max(tx_id) AS lastTx

solana.core.fact_transactions

block_timestamp > '2023-01-01'

AND (

instructions[0]:programId = 'dvyFwAPniptQNb1ey4eM12L8iLHrzdiDsPPDndd6xAR'

OR instructions[1]:programId = 'dvyFwAPniptQNb1ey4eM12L8iLHrzdiDsPPDndd6xAR'

)

GROUP BY

logMsg

-- SELECT *

-- FROM solana.core.fact_transactions

-- WHERE block_timestamp > '2023-03-15' and tx_id = 'XPbCeM9BrwGZRWJ9Ev2xChU7BtPVpotA5LjVB5o7gh4NPcYUH67Rx48pvv722cqfFRda5qst2bjPxV1U8Egm4ku'