Query editor
WITH locks AS (SELECTamount / 1e18 AS home_amount,evt_block_time + INTERVAL '1' SECOND * CAST(duration AS BIGINT) AS unlock_time,CASEWHEN CAST(duration AS BIGINT) = 7776000 THEN '3mo'WHEN CAST(duration AS BIGINT) = 15552000 THEN '6mo'WHEN CAST(duration AS BIGINT) = 23328000 THEN '9mo'WHEN CAST(duration AS BIGINT) = 31104000 THEN '12mo'ELSE 'other'END AS tierFROM defiapp_base.mfdbase_evt_locked)SELECTdate_trunc('week', unlock_time) AS unlock_week,tier,SUM(home_amount) AS total_amount,COUNT(*) AS position_countFROM locksWHERE unlock_time > NOW()GROUP BY 1, 2ORDER BY 1, 2