Query editor
WITHethereum_holograph_protocol_transactions AS (SELECTtx_hash AS tx,COUNT(index) AS idFROMethereum.logsWHEREblock_time >= TIMESTAMP '2023-01-01 00:00:00'AND block_time < TIMESTAMP '2024-01-01 00:00:00'AND (contract_address IN (SELECT contract_address FROM query_2357903) -- Ethereum - deployed holographable contractsOR contract_address IN (SELECT contract_address FROM query_2357917) -- Holograph Protocol contract addresses)GROUP BYtx_hash)SELECTCOUNT(ethereum_holograph_protocol_transactions.tx) AS total_transactionsFROMethereum_holograph_protocol_transactions