Query editor
WITH pricet as (selecttimestamp as pdate,pricefrom prices.daywhere contract_address = 0xc0041ef357b183448b235a8ea73ce4e4ec8c265f),baset AS(SELECT'deposit' AS action,block_time,tx_hash,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) AS user,varbinary_to_int256(topic2) AS pool_id,VARBINARY_TO_INT256(VARBINARY_SUBSTRING(data, 1, 32)) / 1e18 AS amountFROM base.logsWHERE contract_address = 0x16a187eF32EA803a9dfBa04207308A04E4451515AND topic0 = 0x36af321ec8d3c75236829c5317affd40ddb308863a1236d2d277a4025cccee1eUNION ALLSELECT'withdraw' AS action,block_time,tx_hash,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) AS user,varbinary_to_int256(topic2) AS pool_id,-1 * VARBINARY_TO_INT256(VARBINARY_SUBSTRING(data, 1, 32)) / 1e18 AS amountFROM base.logsWHERE contract_address = 0x16a187eF32EA803a9dfBa04207308A04E4451515AND topic0 = 0x02f25270a4d87bea75db541cdfe559334a275b4a233520ed6c0a2429667cca94),bsct AS(SELECT'deposit' AS action,block_time,tx_hash,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) AS user,varbinary_to_int256(topic2) AS pool_id,VARBINARY_TO_INT256(VARBINARY_SUBSTRING(data, 1, 32)) / 1e18 AS amountFROM bnb.logsWHERE contract_address = 0x036b6BA384656151471f348fccf5c2818b9223aEAND topic0 = 0x36af321ec8d3c75236829c5317affd40ddb308863a1236d2d277a4025cccee1eUNION ALLSELECT'withdraw' AS action,block_time,tx_hash,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) AS user,varbinary_to_int256(topic2) AS pool_id,-1 * VARBINARY_TO_INT256(VARBINARY_SUBSTRING(data, 1, 32)) / 1e18 AS amountFROM bnb.logsWHERE contract_address = 0x036b6BA384656151471f348fccf5c2818b9223aEAND topic0 = 0x02f25270a4d87bea75db541cdfe559334a275b4a233520ed6c0a2429667cca94)