Query editor
WITHlatest_sbot_price AS (-- Calc price from buys onlySELECT token_bought_amount, amount_usd, (amount_usd / token_bought_amount) AS sbot_price, block_timeFROM dex.tradesWHEREproject_contract_address = 0x19Ffc51C7AeC11f9b0f6027F895F68C02687bc07 -- STAR LPAND blockchain = 'ethereum'AND token_bought_symbol = 'STAR'AND token_sold_symbol = 'WETH'ORDER BY block_time DESCLIMIT 1),aps AS (SELECT"30dy average revenue (USD)" * 365 * 0.75 / 10000000 / latest_sbot_price.sbot_price * 100 AS "APY","30dy average revenue (USD)" * 365/12 * 0.75 / 10000000 / latest_sbot_price.sbot_price * 100 AS "APM"FROM query_3756369, latest_sbot_price -- Starbot StatsORDER BY block_date ASCLIMIT 1)SELECTAPY,APY/12 AS "APM",latest_sbot_price.sbot_price,-- Fair price per yieldlatest_sbot_price.sbot_price / 6 * APY AS "Fair price @ 6% APY"FROM query_3756369, latest_sbot_price, aps -- Starbot Stats