Query editor
WITH burns AS (SELECTdate_trunc('month', call_block_time) AS week,SUM(amount/1e9) AS tokens_burnedFROM spl_token_solana.spl_token_call_burnWHERE account_mint = '4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy'AND call_block_time >= DATE '2025-09-01'GROUP BY 1),prices AS (SELECTdate_trunc('month', minute) AS week,AVG(price) AS avg_price_usdFROM prices.usdWHERE contract_address = from_base58('4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy')AND minute >= DATE '2025-09-01'GROUP BY 1)SELECTburns.week,burns.tokens_burned AS burns_honey,burns.tokens_burned * prices.avg_price_usd AS burns_usdFROM burnsLEFT JOIN pricesON burns.week = prices.weekORDER BY burns.week;