Query editor
WITH date_series AS (SELECTdaysFROM UNNEST(SEQUENCE(DATE '2024-04-24', -- Start dateDATE_TRUNC('day', CURRENT_DATE),INTERVAL '1' day)) AS t(days)),aggregated_data AS (SELECTDATE_TRUNC('day', block_time) as day,SUM(CASE WHEN action = 'mint' THEN tr.amount / POW(10, tks.decimals) ELSE -tr.amount / POW(10, tks.decimals) END) as pyusd_net_mint_burnFROM tokens_solana.transfers trLEFT JOIN tokens_solana.fungible tks ON tr.token_mint_address = tks.token_mint_addressWHERE tr.token_mint_address = '2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo'AND tr.block_time > DATE '2024-04-24' -- Adjusted start date for filteringAND action IN ('mint', 'burn')GROUP BY 1)SELECTds.days AS day,COALESCE(ad.pyusd_net_mint_burn, 0) as pyusd_net_mint_burn,SUM(COALESCE(ad.pyusd_net_mint_burn, 0)) OVER (ORDER BY ds.days) as pyusd_total_supplyFROM date_series dsLEFT JOIN aggregated_data ad ON ds.days = ad.dayORDER BY ds.days DESC;