Query editor
WITH mints_burns AS (SELECTdate_trunc('day',evt_block_time) AS block_date,l.name AS symbol,currency,SUM(CASEWHEN "from" = 0x0000000000000000000000000000000000000000 THEN value/POWER(10,l.decimals)WHEN "to" = 0x0000000000000000000000000000000000000000 THEN -value/POWER(10,l.decimals)END) AS daily_amountFROM erc20_base.evt_transfer tINNER JOIN query_4780995 lON l.address = t.contract_addressAND ("from" = 0x0000000000000000000000000000000000000000 OR"to" = 0x0000000000000000000000000000000000000000)GROUP BY 1,2,3)-- Get a complete set of days for each token, day_tokens AS (SELECT DISTINCTm.block_date,t.symbol,t.currencyFROM(SELECT DISTINCT block_date FROM mints_burns) mCROSS JOIN(SELECT DISTINCT symbol, currency FROM mints_burns) t),-- Fill in any missing month/token combinations with zero changefilled_mints_burns AS (SELECTmt.block_date,mt.symbol,mt.currency,COALESCE(mb.daily_amount, 0) AS daily_amountFROMday_tokens mtLEFT JOINmints_burns mbONmt.block_date = mb.block_date AND mt.symbol = mb.symbol)-- Calculate running totals for each token by day, raw_balances AS (SELECTblock_date,symbol,currency,daily_amount,SUM(daily_amount) OVER (PARTITION BY symbolORDER BY block_dateROWS UNBOUNDED PRECEDING