Query editor
with apriorit as (select'Stake' as action,contract_address,block_time,tx_hash,tx_from,tx_to,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) AS sender,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic2), 25, 40))) AS owner,varbinary_to_int256(varbinary_substring(data, 1, 32))/pow(10,18) AS assets,varbinary_to_int256(varbinary_substring(data, 33, 32))/pow(10,18) AS sharesfrom monad_testnet.logswhere topic0 = 0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7and contract_address = 0xb2f82D0f38dc453D596Ad40A37799446Cc89274Aunionselect'Redeem' as action,contract_address,block_time,tx_hash,tx_from,tx_to,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) AS sender,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic2), 25, 40))) AS owner,varbinary_to_int256(varbinary_substring(data, 1, 32))/pow(10,18) AS assets,varbinary_to_int256(varbinary_substring(data, 33, 32))/pow(10,18) AS sharesfrom monad_testnet.logswhere topic0 = 0x8caf04742286d017f9ac3924388e188c73e6e5094311c5e59a61a7ef86dda8bfand contract_address = 0xb2f82D0f38dc453D596Ad40A37799446Cc89274A),magmat as (select'Stake' as action,contract_address,block_time,tx_hash,tx_from,tx_to,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) AS sender,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic2), 25, 40))) AS owner,varbinary_to_int256(varbinary_substring(data, 1, 32))/pow(10,18) AS sharesfrom monad_testnet.logswhere topic0 = 0x36af321ec8d3c75236829c5317affd40ddb308863a1236d2d277a4025cccee1eand contract_address = 0x2c9c959516e9aaedb2c748224a41249202ca8be7unionselect'Redeem' as action,contract_address,block_time,tx_hash,tx_from,tx_to,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40))) AS sender,lower(CONCAT('0x', SUBSTRING(TO_HEX(topic2), 25, 40))) AS owner,