Query editor
SELECTDATE_TRUNC('day', block_time) AS day,MAX_BY(bytearray_to_uint256(bytearray_substring(data, 97, 32)) / 1e18 +bytearray_to_uint256(bytearray_substring(data, 161, 32)) / 1e18,block_time) AS tvl_usd,-- zlp_supply + zlp_minted = supply после депозитаMAX_BY(bytearray_to_uint256(bytearray_substring(data, 129, 32)) / 1e18 +bytearray_to_uint256(bytearray_substring(data, 193, 32)) / 1e18,block_time) AS zlp_supply,CASEWHEN MAX_BY(bytearray_to_uint256(bytearray_substring(data, 129, 32)) / 1e18 +bytearray_to_uint256(bytearray_substring(data, 193, 32)) / 1e18,block_time) > 0THEN MAX_BY(bytearray_to_uint256(bytearray_substring(data, 97, 32)) / 1e18 +bytearray_to_uint256(bytearray_substring(data, 161, 32)) / 1e18,block_time) / MAX_BY(bytearray_to_uint256(bytearray_substring(data, 129, 32)) / 1e18 +bytearray_to_uint256(bytearray_substring(data, 193, 32)) / 1e18,block_time)ELSE NULLEND AS zlp_price_usdFROM base.logsWHERE contract_address = 0xe7499dD441950F743044bf4Bf22D254690B601a3AND topic0 = 0x38dc38b96482be64113daffd8d464ebda93e856b70ccfc605e69ccf892ab981eGROUP BY 1ORDER BY 1 DESC