Query editor
SELECTDATE_TRUNC('day', block_time) AS day,COUNT(CASE WHEN bytearray_to_uint256(bytearray_substring(data, 193, 32)) = 1THEN 1 END) AS long_count,COUNT(CASE WHEN bytearray_to_uint256(bytearray_substring(data, 193, 32)) = 0THEN 1 END) AS short_count,COUNT(*) AS total_countFROM base.logsWHERE contract_address = 0xbc2DC9feB0a8202eE4e3B908f55549684bf1C4e8AND topic0 IN (0x2fe68525253654c21998f35787a8d0f361905ef647c854092430ab65f2f15022,0x93d75d64d1f84fc6f430a64fc578bdd4c1e090e90ea2d51773e626d19de56d30)GROUP BY 1ORDER BY 1 DESC