Query editor
-- Show actual Locked events from around TGE (June 10, 2025)-- with 12-month duration, proving unlock_time lands ~June 5, 2026SELECTevt_block_time AS lock_time,CAST(duration AS BIGINT) AS duration_seconds,CAST(duration AS BIGINT) / 86400 AS duration_days,evt_block_time + INTERVAL '1' SECOND * CAST(duration AS BIGINT) AS unlock_time,amount / 1e18 AS home_amountFROM defiapp_base.mfdbase_evt_lockedWHERE CAST(duration AS BIGINT) = 31104000 -- 12mo tierAND evt_block_time >= TIMESTAMP '2025-06-08'AND evt_block_time <= TIMESTAMP '2025-06-12'ORDER BY evt_block_timeLIMIT 20