DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "Day",

SIGNERS AS "Bots",

COUNT(DISTINCT TX_ID) AS "Transactions"

FROM solana.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= CURRENT_DATE() - INTERVAL'30 day'

GROUP BY "Day", "Bots"

HAVING COUNT(DISTINCT TX_ID) >= 25

SELECT

"Bots",

SUM("Transactions") AS "Total Transactions",

"Total Transactions"/30 AS "Average txs per day"

FROM temp

GROUP BY 1

ORDER BY 2 desc