Query editor
WITH raw AS (SELECT'moonriver' AS blockchain,block_time, block_number, tx_hash,contract_address AS token_contract,bytearray_substring(topic1, 13, 20) AS owner,bytearray_to_uint256(data) AS allowanceFROM moonriver.logsWHERE topic0 = 0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925AND topic2 = 0x000000000000000000000000ca11bde05977b3631167028862be2a173976ca11),ranked AS (SELECT *, ROW_NUMBER() OVER (PARTITION BY token_contract, ownerORDER BY block_number DESC) AS rnFROM raw)SELECTblockchain,'0x' || lower(to_hex(token_contract)) AS token_contract,'0x' || lower(to_hex(owner)) AS owner,CAST(allowance AS VARCHAR) AS allowance,CAST(block_time AS VARCHAR) AS last_approval_time,'0x' || lower(to_hex(tx_hash)) AS last_tx_hash,CAST(block_number AS VARCHAR) AS block_numberFROM rankedWHERE rn = 1AND allowance > UINT256 '0'ORDER BY allowance DESC