Query editor
-- Exact unlock summary query for HOME Token Staking (MFDBase on Base)-- Returns precise near-term metrics from raw unlock timestamps,-- including the exact next unlock timestamp and amount.---- Keep the weekly unlock-schedule query for the chart/table.-- Use this query for summary cards that need exact 7d / 30d windows.WITH locks AS (SELECTamount / 1e18 AS home_amount,evt_block_time + INTERVAL '1' SECOND * CAST(duration AS BIGINT) AS unlock_timeFROM defiapp_base.mfdbase_evt_lockedWHERE evt_block_date >= CURRENT_DATE - INTERVAL '370' DAY),future_unlocks AS (SELECT unlock_time, home_amountFROM locksWHERE unlock_time > NOW()),weekly AS (SELECTdate_trunc('week', unlock_time) AS unlock_week,SUM(home_amount) AS week_amountFROM future_unlocksGROUP BY 1),peak AS (SELECT unlock_week, week_amountFROM weeklyORDER BY week_amount DESC, unlock_week ASCLIMIT 1),next_unlock AS (SELECTunlock_time,SUM(home_amount) AS unlock_amount,COUNT(*) AS position_countFROM future_unlocksGROUP BY 1ORDER BY unlock_time ASCLIMIT 1)SELECT(SELECT unlock_time FROM next_unlock) AS next_unlock_time,COALESCE((SELECT unlock_amount FROM next_unlock), 0) AS next_unlock_amount,COALESCE((SELECT position_count FROM next_unlock), 0) AS next_unlock_positions,COALESCE(SUM(CASE WHEN unlock_time <= NOW() + INTERVAL '7' DAY THEN home_amount END), 0) AS next_7d_amount,COALESCE(SUM(CASE WHEN unlock_time <= NOW() + INTERVAL '30' DAY THEN home_amount END), 0) AS next_30d_amount,COALESCE(SUM(home_amount), 0) AS total_pending_amount,(SELECT unlock_week FROM peak) AS peak_week_date,COALESCE((SELECT week_amount FROM peak), 0) AS peak_week_amountFROM future_unlocks;