Query editor
/* Because we added new metric, so we build new query*/withbtc as (with today as (SELECTdate_trunc('day', minute) as day, symbol, AVG(price) as price_todayFROM prices.usd_latestWHERE blockchain is NULLAND symbol = 'BTC'GROUP BY 1,2), one_day as (SELECTdate_trunc('day', minute) as day, symbol, AVG(price) as price_24hFROM prices.usdWHERE blockchain is NULLAND symbol = 'BTC'AND DATE(minute) = DATE(NOW() - interval '24' hour)AND EXTRACT(HOUR FROM minute) >= 0 AND EXTRACT(HOUR FROM minute) < 1GROUP BY 1,2)SELECTa.day, symbol, price_today, ((price_today - price_24h)/price_24h)*100 as growth_1dFROM today aLEFT JOIN one_day using(symbol)), token as (with today as (SELECTday, symbol, AVG(price) as price_todayFROM (SELECTdate_trunc('day', minute) as day, symbol, priceFROM prices.usd_latestWHERE contract_address IN (SELECT from_base58('9se6kma7LeGcQWyRBNcYzyxZPE3r9t9qWZ8SnjnN3jJ7')) --luna by virtualsUNION ALLSELECTdate_trunc('day', minute) as day, symbol, priceFROM prices.usd_latestWHERE contract_address IN (SELECT from_base58('CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump')) --goatUNION ALLSELECTdate_trunc('day', block_time) as day, token_bought_symbol as symbol, SUM(amount_usd)/SUM(token_bought_amount) as priceFROM dex_solana.trades