Query editor
WITH meem_price_feed_logs AS (SELECTfrom_unixtime(bytearray_to_uint256(bytearray_substring(data, 1, 32))) AS timestamp,bytearray_to_int256(bytearray_substring(data, 33, 32)) AS price,bytearray_to_uint256(bytearray_substring(data, 65, 32)) AS valid,contract_addressFROMarbitrum.logsWHEREcontract_address = 0x5d1e13872e687cfdf651b2ffe92264d235865ca5AND topic0 = 0xec385e1ce54a8e9d6a576269ae097576195191e829639205064f4172cd4254c5),meem_price_feed AS (SELECTtimestamp AS date_time,CASE WHEN contract_address = 0x5d1e13872e687cfdf651b2ffe92264d235865ca5 THEN 'MEEM-USD' END AS product_id,price / 1e6 AS price_usd,CASEWHEN valid = 1 THEN 'true'ELSE 'false'END AS valid_statusFROM meem_price_feed_logs)SELECT *FROM meem_price_feedORDER BY 1 DESC