Query editor
WITH current_supply AS(SELECT name, symbol, SUM(amount) AS total_supplyFROM (SELECT name, symbol, -SUM(amount) AS amountFROM stablecoin."burn"WHERE symbol != 'TUSD' -- waiting for fix on supplyGROUP BY 1,2UNION ALLSELECT name, symbol, SUM(amount) AS amountFROM stablecoin."mint"WHERE symbol != 'TUSD' -- waiting for fix on supplyGROUP BY 1,2) currentGROUP BY 1,2ORDER BY 3 DESC), old_supply AS(SELECT name, symbol, SUM(amount) AS total_supplyFROM (SELECT name, symbol, -SUM(amount) AS amountFROM stablecoin."burn"WHERE block_time < now() - interval '7 days'GROUP BY 1,2UNION ALLSELECT name, symbol, SUM(amount) AS amountFROM stablecoin."mint"WHERE block_time < now() - interval '7 days'GROUP BY 1, 2) oldGROUP BY 1,2ORDER BY 2 DESC)SELECT n.name, n.symbol, n.total_supply, ((n.total_supply - o.total_supply) / o.total_supply)*100 AS seven_days_growthFROM current_supply nLEFT JOIN old_supply o ON n.name = o.nameORDER BY 3 DESC;