feyikemicomfortable-brown
Updated 2024-10-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH deposits AS (
SELECT
SUM(OLAS_AMOUNT) AS Total_Locked_Volume
FROM crosschain.olas.ez_olas_locking
WHERE EVENT_NAME = 'Deposit'
),
withdraws AS (
SELECT
SUM(OLAS_AMOUNT) AS Total_Volume_Withdraw
FROM crosschain.olas.ez_olas_locking
WHERE EVENT_NAME = 'Withdraw'
),
Total_Currently_Locked AS (
SELECT
Total_Locked_Volume - COALESCE(Total_Volume_Withdraw, 0) AS Total_Currently_Locked_OLAS
FROM deposits, withdraws
),
veOLAS_Holders AS (
SELECT
ACCOUNT_ADDRESS,
SUM(OLAS_AMOUNT) AS Total_Locked_OLAS,
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
)
SELECT
v.ACCOUNT_ADDRESS AS "veOLAS Holder",
v.Total_Locked_OLAS AS "OLAS Amount",
v.LOCK_DATE AS "Lock Date",
v.UNLOCK_DATE AS "Unlock Date",
QueryRunArchived: QueryRun has been archived