SELECT

ACCOUNT_ADDRESS,

SUM(OLAS_AMOUNT) AS Total_Locked_OLAS,

SUM(OLAS_AMOUNT_USD) AS Total_Locked_OLAS_USD,

MIN(DATE_TRUNC('day', BLOCK_TIMESTAMP)) AS LOCK_DATE,

MAX(DATE_TRUNC('day', UNLOCK_TIMESTAMP)) AS UNLOCK_DATE

FROM crosschain.olas.ez_olas_locking

WHERE EVENT_NAME = 'Deposit'

GROUP BY ACCOUNT_ADDRESS

ACCOUNT_ADDRESS AS "veOLAS Holder",

Total_Locked_OLAS AS "OLAS Amount",

LOCK_DATE AS "Lock Date",

UNLOCK_DATE AS "Unlock Date",

DATEDIFF('day', LOCK_DATE, UNLOCK_DATE) AS "Lock Period (Days)"

FROM veOLAS_Holders

ORDER BY "Unlock Date" DESC