Query editor
with supplyt as (selectblockchain,block_time,tx_hash,amount as amfrom tokens.transferswhere contract_address = 0xaca92e438df0b2401ff60da7e4337b687a2435daand "from" = 0x0000000000000000000000000000000000000000and blockchain != 'bnb'union allselectblockchain,block_time,tx_hash,-1 * amount as amfrom tokens.transferswhere contract_address = 0xaca92e438df0b2401ff60da7e4337b687a2435daand "to" = 0x0000000000000000000000000000000000000000and blockchain != 'bnb')selectdate_trunc('day',block_time) as date,blockchain,sum(am) as mint,sum(sum(am)) over (order by date_trunc('day',block_time) asc) as supply1,sum(sum(am)) over (partition by blockchain order by date_trunc('day',block_time) asc) as supplyfrom supplytgroup by 1,2order by 5 desc