Query editor
withDVN_list (contract, name) AS (VALUES(0x58dff8622759ea75910a08dba5d060579271dcd7, '01 node'),(0x7e65bdd15c8db8995f80abf0d6593b57dc8be437, 'Animoca-Blockdaemon'),(0xce5b47fa5139fc5f3c8c5f4c278ad5f56a7b2016, 'Axelar'),(0xe552485d02edd3067fe7fcbd4dd56bb1d3a998d2, 'BCW Group'),(0x05d78174b97cf2ec223ee578cd1f401ff792ca31, 'BitGo'),(0x6e70fcdc42d3d63748b7d8883399dcb16bbb5c8c, 'Blockhunters'),(0x7a23612f07d81f16b26cf0b5a4c3eca0e8668df2, 'Bware'),(0x771d10d0c86e26ea8d3b778ad4d31b30533b9cbf, 'CCIP Chainlink'),(0x87048402c32632b7c4d0a892d82bc1160e8b2393, 'Delegate'),(0x38179d3bfa6ef1d69a8a7b0b671ba3d8836b2ae8, 'Gitcoin'),(0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc, 'Google Cloud'),(0x380275805876ff19055ea900cdb2b46a94ecf20d, 'Horizen'),(0x95729ea44326f8add8a9b1d987279dbdc1dd3dff, 'Lagrange'),(0x589dedbd617e0cbcb916a9223f4d1300c294236b, 'LayerZero Labs'),(0x58249a2ec05c1978bf21df1f5ec1847e42455cf4, 'Luganodes'),(0x0ae4e6a9a8b01ee22c6a49af22b674a4e033a23d, 'MIM Abracadabra'),(0xa59ba433ac34d2927232918ef5b2eaafcf130ba5, 'Nethermind'),(0x04584d612802a3a26b160e3f90341e6443ddb76a, 'Nocturnal Labs'),(0x9f45834f0c8042e36935781b944443e906886a87, 'Nodes Guru'),(0xaf75bfd402f3d4ee84978179a6c87d16c4bd1724, 'Omni-X'),(0xf10ea2c0d43bc4973cfbcc94ebafc39d1d4af118, 'Omnicat'),(0x94aafe0a92a8300f0a2100a7f3de47d6845747a9, 'P-OPS'),(0x06559ee34d85a88317bf0bfe307444116c631b67, 'P2P'),(0xd24972c11f91c1bb9eaee97ec96bb9c33cf7af24, 'Pearlnet'),(0x972ed7bd3d42d9c0bea3632992ebf7e97186ea4a, 'Planetarium Labs'),(0x8ddf05f9a5c488b4973897e278b58895bf87cb24, 'Polyhedra'),(0x92ef4381a03372985985e70fb15e9f081e2e8d14, 'Portal'),(0xa1bc1b9af01a0ec78883aa5dc7decdce897e1e76, 'Republic'),(0xe4193136b92ba91402313e95347c8e9fad8d27d0, 'Restake'),(0xce97511db880571a7c31821eb026ef12fcac892e, 'Shrapnel'),(0x5fddd320a1e29bb466fa635661b125d51d976f92, 'StableLab'),(0xdeb742e71d57603d8f769ce36f4353468007fc02, 'StakingCabin'),(0x8fafae7dd957044088b3d0f67359c327c6200d18, 'Stargate'),(0x276e6b1138d2d49c0cda86658765d12ef84550c1, 'Switchboard'),(0xd42306df1a805d8053bc652ce0cd9f62bde80146, 'Zenrock')),payloadVerified_evt AS (SELECT *FROM TABLE (decode_evm_event (abi => '{"anonymous":false,"inputs":[{"indexed":false,"internalType":"address","name":"dvn","type":"address"},{"indexed":false,"internalType":"bytes","name":"header","type":"bytes"},{"indexed":false,"internalType":"uint256","name":"confirmations","type":"uint256"},{"indexed":false,"internalType":"bytes32","name":"proofHash","type":"bytes32"}],"name":"PayloadVerified","type":"event"}',input => TABLE (SELECT * FROM ethereum.logsWHERE 1=1 AND topic0 = 0x2cb0eed7538baeae4c6fde038c0fd0384d27de0dd55a228c65847bda6aa1ab56))))SELECTblock_date,CONCAT_WS(', ', dvn_array) AS dvn_array,COUNT(proofHash) OVER (PARTITION BY block_date, dvn_array) AS tx_countFROM (SELECTt.proofHash,ARRAY_AGG(l.name ORDER BY l.name) AS dvn_array,