DAY | DAILY_RETH_SUPPLY | DAILY_RATE | DAILY_RETH_TVL_ETH | |
|---|---|---|---|---|
1 | 2025-02-24 00:00:00.000 | 5264860.240052 | ||
2 | 2025-02-23 00:00:00.000 | 14750287.272312 | ||
3 | 2025-02-22 00:00:00.000 | 964771.448504 | ||
4 | 2025-02-21 00:00:00.000 | 1336691.140424 | ||
5 | 2025-02-20 00:00:00.000 | 2428313.593821 | ||
6 | 2025-02-19 00:00:00.000 | 2507870.744599 | ||
7 | 2025-02-18 00:00:00.000 | 1902697.724282 | ||
8 | 2025-02-17 00:00:00.000 | 3062098.335565 | ||
9 | 2025-02-16 00:00:00.000 | 3249814.959605 | ||
10 | 2025-02-15 00:00:00.000 | 1423747.261094 | ||
11 | 2025-02-14 00:00:00.000 | 1996304.752691 | ||
12 | 2025-02-13 00:00:00.000 | 4259174.540825 | ||
13 | 2025-02-12 00:00:00.000 | 2469308.285092 | ||
14 | 2025-02-11 00:00:00.000 | 4283510.649293 | ||
15 | 2025-02-10 00:00:00.000 | 3827202.764987 | ||
16 | 2025-02-09 00:00:00.000 | 7472283.684976 | ||
17 | 2025-02-08 00:00:00.000 | 4461256.856384 | ||
18 | 2025-02-07 00:00:00.000 | 3231518.496701 | ||
19 | 2025-02-06 00:00:00.000 | 3940055.384839 | ||
20 | 2025-02-05 00:00:00.000 | 2552147.791052 |
10Blockchain2) rETH : Daily TVL = totalSupply × exchangeRate
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 RETH_SUPPLY AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
SUM(balance) / 1e18 AS daily_reth_supply
FROM ethereum.core.fact_token_balances
WHERE
contract_address = LOWER('0xae78736cd615f374d3085123a210448e74fc6393') -- rETH
AND block_timestamp >= '2023-01-01'
GROUP BY 1
),
RETH_EXCHANGERATE AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
-- On prend un average daily, si l’event se déclenche plusieurs fois
AVG(
TRY_TO_NUMBER(
'0x' || SUBSTR(data, 67, 64), -- le param #2 s'il s'agit d'ExchangeRateSet(uint256,uint256)
16
) / 1e18
) AS daily_rate
FROM ethereum.core.fact_event_logs
WHERE
contract_address = LOWER('0xae78736cd615f374d3085123a210448e74fc6393')
-- topic_0 = keccak256("ExchangeRateSet(uint256,uint256)"), par ex. 0xef51b4c8...
AND topic_0 = LOWER('<HASH_DE_LEVENT_EXCHANGERATESET>')
AND block_timestamp >= '2023-01-01'
GROUP BY 1
)
SELECT
rs.day,
rs.daily_reth_supply,
re.daily_rate,
rs.daily_reth_supply * re.daily_rate AS daily_reth_tvl_eth
FROM RETH_SUPPLY rs
LEFT JOIN RETH_EXCHANGERATE re ON rs.day = re.day
ORDER BY rs.day DESC;
Last run: about 2 months ago
...
786
41KB
5s