Query editor
WITH tokens AS(SELECTcontract_address,symbol,decimals-- ,backingFROM tokens.erc20_stablecoinswhere blockchain = 'mantle'union allselect 0x00000000eFE302BEAA2b3e6e1b18d08D69a9012a, 'AUSD', 6),mint as(select block_date as dt,a.symbol,amountfrom tokens_mantle.transfers a join tokens b on a.contract_address = b.contract_addresswhere block_month >= date('2023-07-01')and "from" = 0x0000000000000000000000000000000000000000union allselect block_date as dt,a.symbol, -amountfrom tokens_mantle.transfers a join tokens b on a.contract_address = b.contract_addresswhere block_month >= date('2023-07-01')and "to" = 0x0000000000000000000000000000000000000000),dates as (SELECT dtFROM UNNEST(SEQUENCE(DATE('2023-07-01'),CURRENT_DATE,INTERVAL '1' DAY)) AS t(dt)),t1 as (select *,LAG(supply,1) OVER (PARTITION BY symbol ORDER BY dt) AS supply_1,LAG(supply,7) OVER (PARTITION BY symbol ORDER BY dt) AS supply_7from(select a.dt,b.symbol-- ,sum(amount) amount,SUM(SUM(COALESCE(amount,0))) OVER (PARTITION BY b.symbol ORDER BY a.dt) AS supplyfrom dates across join tokens bleft join mint c on a.dt = c.dt and b.symbol = c.symbolgroup by 1,2) a)