Query editor
SELECT SUM(50/POWER(2, ROUND(height/210000)))* (SELECT price FROM prices.usd_latest WHERE symbol='BTC' AND contract_address IS NULL)/POWER(10, 9) AS supplyFROM bitcoin.blocks
Query editor
1SELECT SUM(50/POWER(2, ROUND(height/210000)))2* (SELECT price FROM prices.usd_latest WHERE symbol='BTC' AND contract_address IS NULL)3/POWER(10, 9) AS supply4FROM bitcoin.blocks