Query editor
SELECTDATE_TRUNC('day', block_time) AS day,SUM(bytearray_to_uint256(bytearray_substring(data, 161, 32)) / 1e30) AS total_volume_usd,SUM(CASE WHEN topic0 = 0x2fe68525253654c21998f35787a8d0f361905ef647c854092430ab65f2f15022THEN bytearray_to_uint256(bytearray_substring(data, 161, 32)) / 1e30ELSE 0 END) AS increase_volume_usd,SUM(CASE WHEN topic0 = 0x93d75d64d1f84fc6f430a64fc578bdd4c1e090e90ea2d51773e626d19de56d30THEN bytearray_to_uint256(bytearray_substring(data, 161, 32)) / 1e30ELSE 0 END) AS decrease_volume_usdFROM base.logsWHERE contract_address = 0xbc2DC9feB0a8202eE4e3B908f55549684bf1C4e8AND topic0 IN (0x2fe68525253654c21998f35787a8d0f361905ef647c854092430ab65f2f15022,0x93d75d64d1f84fc6f430a64fc578bdd4c1e090e90ea2d51773e626d19de56d30)GROUP BY 1ORDER BY 1 DESC