Query editor
WITH mint AS (select block_date, blockchain, amountfrom tokens.transferswhere contract_address in (0x5FA487BCa6158c64046B2813623e20755091DA0b, 0xfdd22ce6d1f66bc0ec89b20bf16ccb6670f55a5a)-- and blockchain in ('ethereum', 'arbitrum','hyperevm','base','plasma')and block_month >= date('2025-08-01')and "from" in (0x0000000000000000000000000000000000000000,0xfDD22Ce6D1F66bc0Ec89b20BF16CcB6670F55A5a)-- group by 1UNION ALLselect block_date, blockchain, -amountfrom tokens.transferswhere contract_address in (0x5FA487BCa6158c64046B2813623e20755091DA0b, 0xfdd22ce6d1f66bc0ec89b20bf16ccb6670f55a5a)-- and blockchain in ('ethereum', 'arbitrum','hyperevm','base','plasma')and block_month >= date('2025-08-01')and "to" in (0x0000000000000000000000000000000000000000,0xfDD22Ce6D1F66bc0Ec89b20BF16CcB6670F55A5a)),dates as (SELECT dtFROM UNNEST(SEQUENCE(DATE('2025-08-01'),CURRENT_DATE,INTERVAL '1' DAY)) AS t(dt)),chains as (select blockchainfrom tokens.transferswhere contract_address in (0x5FA487BCa6158c64046B2813623e20755091DA0b, 0xfdd22ce6d1f66bc0ec89b20bf16ccb6670f55a5a)-- and blockchain in ('ethereum', 'arbitrum','hyperevm','base','plasma')and block_month >= date('2025-08-01')group by 1)select a.dt,b.blockchain,SUM(SUM(COALESCE(amount,0))) OVER (PARTITION BY b.blockchain ORDER BY a.dt) AS supplyfrom dates across join chains bleft join mint c on a.dt = c.block_date and b.blockchain = c.blockchaingroup by 1,2order by 1 desc, supply desc