Query editor
WITH prev_cum AS (SELECTminted_supplyFROM dune.sumcap.result_usdt_0_supply_actionsWHERE "day" < date_trunc('day', now() - interval '1' day)ORDER BY day DESCLIMIT 1),daily AS (SELECTdate_trunc('day', evt_block_time) AS day,SUM(CASE WHEN "from" = 0x0000000000000000000000000000000000000000 THEN value ELSE 0 END) / 1e6 AS mint,SUM(CASE WHEN "to" = 0x0000000000000000000000000000000000000000 THEN value ELSE 0 END) / 1e6 AS burn,SUM(CASEWHEN "from" = 0x0000000000000000000000000000000000000000 THEN valueWHEN "to" = 0x0000000000000000000000000000000000000000 THEN -valueELSE 0END) / 1e6 AS net_mint_burnFROM erc20_plasma.evt_transferWHERE contract_address = 0xB8CE59FC3717ada4C02eaDF9682A9e934F625ebbAND date_trunc('day', evt_block_time) = date_trunc('day', now() - interval '1' day)GROUP BY date_trunc('day', evt_block_time)),new_row AS (SELECTd.day,d.mint,-d.burn as burn,d.net_mint_burn,p.minted_supply + d.net_mint_burn AS minted_supplyFROM daily dCROSS JOIN prev_cum p)SELECT *FROM dune.sumcap.result_usdt_0_supply_actionsWHERE "day" < date_trunc('day', now() - interval '1' day)UNION ALLSELECT *FROM new_rowORDER BY day DESC;