Query editor
with baset as (/*SELECTlower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) AS owner,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic2), 25, 40))) AS sft,varbinary_to_int256(topic3) AS slot,lower(CONCAT('0x', SUBSTRING(TO_HEX(varbinary_substring(data, 1, 32)), 25, 40))) AS erc20,varbinary_to_int256(varbinary_substring(data, 33, 32)) AS sftId,varbinary_to_int256(varbinary_substring(data, 65, 32))/1e18 AS value,tx_hash,block_time,tx_from,tx_toFROM bob.logsWHERE 1=1--and tx_hash = 0xe0cc2e50eca8b6fe69c2fad82caed78d01dffc5f83d34bd0c418cfe8f7f335b0 --depositand topic0 = 0x00989e8d31410c29caf0085f1b67a406c7146d720ea8e126047c5aac4c1b3b2b--and lower(CONCAT('0x', SUBSTRING(TO_HEX(varbinary_substring(data, 1, 32)), 25, 40))) = '0x541fd749419ca806a8bc7da8ac23d346f2df8b77'and lower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) = '0x49b072158564db36304518ffa37b1cfc13916a90'*/SELECTlower(concat('0x',to_hex(topic1))) as poolId,lower(concat('0x',substring(to_hex(topic2), 25, 40))) as user, --subscriberlower(concat('0x',substring(to_hex(varbinary_substring(data, 1, 32)), 25, 40))) as solvBTC,varbinary_to_int256(varbinary_substring(data, 33, 32))/1e18 as amount,--lower(concat('0x',substring(to_hex(varbinary_substring(data, 65, 32)), 25, 40))) as currency,--varbinary_to_int256(varbinary_substring(data, 97, 32))/1e8 as currencyAmount,tx_hash,block_time,tx_from,tx_toFROM bob.logsWHERE 1=1--and tx_hash = 0xe0cc2e50eca8b6fe69c2fad82caed78d01dffc5f83d34bd0c418cfe8f7f335b0 --depositand topic0 = 0x4a29c2a0a0125871fb9cb0dcda775193070a8dd3a98e792b07eca515745de3bfand lower(concat('0x',substring(to_hex(varbinary_substring(data, 1, 32)), 25, 40))) = '0x541fd749419ca806a8bc7da8ac23d346f2df8b77'--and lower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) = '0x410a290373e1eccf90d635ee4c2e323138522400'unionSELECTlower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) AS poolId,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic2), 25, 40))) AS user, --redeemer,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic3), 25, 40))) AS solvBTC,-1 * varbinary_to_int256(varbinary_substring(data, 1, 32))/1e18 AS amount, --redeemAmount--varbinary_to_int256(varbinary_substring(data, 33, 32)) AS redemptionId,tx_hash,block_time,tx_from,tx_toFROM bob.logsWHERE 1=1--and tx_hash = 0x51472e0fe54a1e5c286c524f2af0c91ef00fd98fa21844f32e5bd330cab7b9cb --Redemptionand topic0 = 0x78f28b46ef784512c5644a2069be0c54b5504a85022f6944b8fe318e80288117and lower(CONCAT('0x', SUBSTRING(TO_HEX(topic3), 25, 40))) = '0x541fd749419ca806a8bc7da8ac23d346f2df8b77'--and lower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) = '0x410a290373e1eccf90d635ee4c2e323138522400')selectcount(distinct tx_from) as users,count(distinct tx_hash) as txs,sum(amount) as am--sum(currencyAmount) as tot_amfrom baset/*with withdrawt as (SELECT'withdraw' as action,