DAY | VAULT | DAILY_APY | |
|---|---|---|---|
1 | 2025-02-24 00:00:00.000 | 0x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef3 | 0.0328 |
2 | 2025-02-24 00:00:00.000 | 0x29c85c752e854b0cf2372e6b6c56f260755f5120 | 0.1796 |
3 | 2025-02-24 00:00:00.000 | 0x49c077b74292aa8f589d39034bf9c1ed1825a608 | 0.0016 |
4 | 2025-02-24 00:00:00.000 | 0x4a5c95a0e3fca4148f91ceb637fba0e1080be40e | 0.0083 |
5 | 2025-02-24 00:00:00.000 | 0xf34253ec3dd0cb39c29cf5eeb62161fb350a9d14 | 0.0134 |
6 | 2025-02-23 00:00:00.000 | 0x1773002742a2bcc7666e38454f761ce8fe613de5 | 0.0021 |
7 | 2025-02-23 00:00:00.000 | 0x29c85c752e854b0cf2372e6b6c56f260755f5120 | 0.0879 |
8 | 2025-02-23 00:00:00.000 | 0x46e3c018798d6de4517a3c98358e4bd8d334b79c | 0.0217 |
9 | 2025-02-23 00:00:00.000 | 0x49c077b74292aa8f589d39034bf9c1ed1825a608 | 0.0025 |
10 | 2025-02-23 00:00:00.000 | 0x4a5c95a0e3fca4148f91ceb637fba0e1080be40e | 0.0249 |
11 | 2025-02-22 00:00:00.000 | 0x49c077b74292aa8f589d39034bf9c1ed1825a608 | 0.0011 |
12 | 2025-02-21 00:00:00.000 | 0x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef3 | 0.021 |
13 | 2025-02-21 00:00:00.000 | 0x1773002742a2bcc7666e38454f761ce8fe613de5 | 0.0047 |
14 | 2025-02-21 00:00:00.000 | 0x29c85c752e854b0cf2372e6b6c56f260755f5120 | 0.0568 |
15 | 2025-02-21 00:00:00.000 | 0x3c12aa52b014acf7957308808362909b5757cca8 | 0.0068 |
16 | 2025-02-21 00:00:00.000 | 0x46e3c018798d6de4517a3c98358e4bd8d334b79c | 0.0379 |
17 | 2025-02-21 00:00:00.000 | 0x49c077b74292aa8f589d39034bf9c1ed1825a608 | 0.0014 |
18 | 2025-02-21 00:00:00.000 | 0x4a5c95a0e3fca4148f91ceb637fba0e1080be40e | 0.0087 |
19 | 2025-02-21 00:00:00.000 | 0xf34253ec3dd0cb39c29cf5eeb62161fb350a9d14 | 0.0043 |
20 | 2025-02-20 00:00:00.000 | 0x3c12aa52b014acf7957308808362909b5757cca8 | 0.0114 |
rezarwzcoherent-salmon
Updated 2025-02-24
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 vault_status AS (
SELECT
DATE_TRUNC('DAY', block_timestamp) AS day_date,
-- اگر نیاز به تبدیل واحد است، مثلاً تقسیم بر 1e18، آن را اضافه کنید:
TO_DECIMAL(DECODED_LOG:interestAccumulator, 0) AS interest_acc
FROM
swell.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0x1773002742A2bCc7666e38454F761CE8fe613DE5')
AND event_name = 'VaultStatus'
),
daily_values AS (
-- برای هر روز، مقدار ماکسیمم interest_acc را به عنوان "آخرین مقدار" همان روز در نظر میگیریم
SELECT
day_date,
MAX(interest_acc) AS last_acc
FROM
vault_status
GROUP BY
day_date
),
calc_apy AS (
SELECT
day_date,
last_acc,
LAG(last_acc) OVER (
ORDER BY
day_date
) AS prev_acc
FROM
daily_values
)
SELECT
day_date,
CASE
WHEN prev_acc IS NOT NULL
Last run: 2 months ago
...
169
13KB
1s