, signers[0] AS user

, count(tx_id) AS count_tx

FROM solana.core.fact_transactions

WHERE block_timestamp::date BETWEEN '2023-04-20' AND '2023-04-30'

AND account_keys::string LIKE '%ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD%'

AND succeeded = TRUE

GROUP BY 1, 2