Query editor
WITHavalanche_holograph_protocol_transactions AS (SELECTtx_hash AS tx,COUNT(index) AS idFROMavalanche_c.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_2357969) -- Avalanche - deployed holographable contractsOR contract_address IN (SELECT contract_address FROM query_2357917) -- Holograph Protocol contract addresses)GROUP BYtx_hash)SELECTCOUNT(avalanche_holograph_protocol_transactions.tx) AS total_transactionsFROMavalanche_holograph_protocol_transactions