Query editor
WITH mints AS (SELECT_account AS address,SUM(_amount) / 1e18 AS minted_amountFROM boba_boba.bobatoken_evt_mintGROUP BY 1),transfers AS (SELECT"to" AS address,SUM(value) / 1e18 AS received_amountFROM boba_boba.bobatoken_evt_transferGROUP BY 1),sent AS (SELECT"from" AS address,SUM(value) / 1e18 AS sent_amountFROM boba_boba.bobatoken_evt_transferGROUP BY 1),balances AS (SELECTCOALESCE(m.address, t.address, s.address) AS holder,COALESCE(m.minted_amount, 0) + COALESCE(t.received_amount, 0) - COALESCE(s.sent_amount, 0) AS final_balanceFROM mints mFULL OUTER JOIN transfers t ON m.address = t.addressFULL OUTER JOIN sent s ON COALESCE(m.address, t.address) = s.address),BOBA_total_holders AS (SELECTCOUNT(*) AS total_holdersFROM balancesWHERE final_balance > 0 -- ā Only count addresses with BOBA),BOBA_price AS (SELECTprice AS current_price,(price - LAG(price) OVER (ORDER BY day)) / LAG(price) OVER (ORDER BY day) AS price_change_1dFROM prices.usd_dailyWHERE symbol = 'BOBA'ORDER BY day DESCLIMIT 1),BOBA_total_supply AS (SELECTCAST(total_supply AS DOUBLE) AS total_supplyFROM JSON_TABLE(CAST(HTTP_GET('https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&ids=boba') AS VARCHAR),'lax $[*]'COLUMNS (total_supply VARCHAR PATH 'lax $.total_supply'))