Query editor
SELECT contract_address, count(*) AS n, max(block_time) AS last_seenFROM ethereum.logsWHERE topic0 = 0x6d06dfa000000000000000000000000000000000000000000000000000000000GROUP BY contract_addressORDER BY n DESCLIMIT 100
Query editor
1SELECT contract_address, count(*) AS n, max(block_time) AS last_seen2FROM ethereum.logs3WHERE topic0 = 0x6d06dfa0000000000000000000000000000000000000000000000000000000004GROUP BY contract_address5ORDER BY n DESC6LIMIT 100