signers[0] as signer

, count(distinct tx_id) as txs

, count(distinct block_timestamp::date) as days_active

, txs / days_active

, count(distinct program_id) as programs_used

, min(block_timestamp::date) as first_tx_date

, max(block_timestamp::date) as last_tx_date

from eclipse.core.fact_events

where 1 = 1

and block_timestamp > current_date - 7

and program_id not in (

'BPFLoaderUpgradeab1e11111111111111111111111'

, 'ComputeBudget111111111111111111111111111111'

, '11111111111111111111111111111111'

, 'TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb'

, 'ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL'

, 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'

, 'FUCHhfHbuxXBWiRBfVdhmiog84sUJw11aAq3ibAUGL6e' -- a lot of txs but only 2 signers

, '5hEa5j38yNJRM9vQA44Q6gXVj4Db8y3mWxkDtQeofKKs' -- very probable a airdrop botting farmer

)

and signers[0] != 'G5FM3UKwcBJ47PwLWLLY1RQpqNtTMgnqnd6nZGcJqaBp' -- hyperlane signer

group by 1

qualify row_number() over (order by txs desc) <= 10

or row_number() over (order by programs_used desc) <= 10

or row_number() over (order by days_active desc) <= 10