Query editor
SELECTCOUNT(DISTINCT t.sender) AS count,SUM(aa.balance_change * 85 / 15 - t.fee) AS profitFROM solana.account_activity aaJOIN (SELECT id, fee, account_keys[1] AS senderFROM solana.transactionsWHERE DATE(block_time) >= CURRENT_DATE - INTERVAL '30' DAYAND (CONTAINS(account_keys, 'MEVK7RP6dDTbxAwirSY6R5v66oS5WvzbhAQD9jpy9Lj') ORCONTAINS(account_keys, 'MEVbwoHUDJNcxZHFFg4XsyuQmBUeXEHFLNqXH635Sgi'))) t ON aa.tx_id = t.idWHEREDATE(block_time) >= CURRENT_DATE - INTERVAL '30' DAYAND (aa.address = 'Fee1Q19hmgM7krgJf1pn2GcedgEk7YGWBhYeevNWhkeu'OR aa.address = 'FeeuVBK964vYp8QWbP1VY4wv84aRD1DiKMNWv9mfrVMJ'OR aa.address = 'Fee6yfi5rj82hWXakAYibZfnp5U9X44WhCgvgPBzjtUe'OR aa.address = 'Fee8zMoC3mmpcUXFFDNcafDkxAYsYUeCVVu6obqt9ELS'OR aa.address = 'FeeA2GxrNpcPxHk5PbyRQh87moxZbZrFeobK3q68FR4d'OR aa.address = 'FeeCRCooiV5prkyj8YEmExRkM7KwNrJqg8bkbdgw3Lz3'OR aa.address = 'FeeiBNa8WiNhHQCtKeBR56vXebyWKBT8Cd8VsoHRpnPX'OR aa.address = 'Feeuy3Fi3EbwVfWrX4gRwiWi2xbRN7QnAMqJPj2UNJZj'-- New walletsOR aa.address = 'FeeqF3VuLzSe78g2nTkL2vzDmu54K2ZBD4XmaUe7Ardg'OR aa.address = 'FeedQ6vZyLEKVWyTdDTU9awqh6oHvxviRwSv1XD2QH7Z'OR aa.address = 'FeeVzA6bvDzuXxR8GqASU6SN27ujLMPrnamoQ1S1JMhN'OR aa.address = 'Fee4ubrc66yyfME8ckBkSxJ5JT6WzWbZaTPJm5EeFJ7Z'OR aa.address = 'FeecJF4qteQcxMe44L7fa9AM9eaqLwf4TsmPkioQUqDE'OR aa.address = 'FeeZj5DEtnRb6jTACHDF8Db1rmN4wMXDuBQmDnzXdGUr'OR aa.address = 'FeeToM5jrPBpgtHxo2cveAtVkPH6vPF1nag18QVqycLa'OR aa.address = 'Feen2gjG3qpecHfZSyh8pvFo4XijGDU1eDBWVVTFmhA5')AND aa.balance_change > 0