DAY | VAULT | TOTALSUUPLY_USD | TOTALBORROWS_USD | ACCUMULATEDFEES_USD | |
|---|---|---|---|---|---|
1 | 2025-01-22 00:00:00.000 | WETH | 171.702825 | 0 | 0 |
2 | 2025-01-22 00:00:00.000 | ezETH | 5.43544655 | 0.5296515497 | 0 |
3 | 2025-01-22 00:00:00.000 | pzETH | |||
4 | 2025-01-22 00:00:00.000 | rsETH | |||
5 | 2025-01-22 00:00:00.000 | rswETH | |||
6 | 2025-01-22 00:00:00.000 | swETH | |||
7 | 2025-01-22 00:00:00.000 | weETH | |||
8 | 2025-01-22 00:00:00.000 | wstETH | |||
9 | 2025-01-23 00:00:00.000 | WETH | 169.33518 | 0 | 0 |
10 | 2025-01-23 00:00:00.000 | ezETH | 5.325759878 | 0.5189811893 | 0.000001810643883 |
11 | 2025-01-23 00:00:00.000 | pzETH | |||
12 | 2025-01-23 00:00:00.000 | rsETH | |||
13 | 2025-01-23 00:00:00.000 | rswETH | |||
14 | 2025-01-23 00:00:00.000 | swETH | |||
15 | 2025-01-23 00:00:00.000 | weETH | |||
16 | 2025-01-23 00:00:00.000 | wstETH | |||
17 | 2025-01-24 00:00:00.000 | WETH | 169.33518 | 0 | 0 |
18 | 2025-01-24 00:00:00.000 | ezETH | 5.325759878 | 0.5189811893 | 0.000001810643883 |
19 | 2025-01-24 00:00:00.000 | pzETH | |||
20 | 2025-01-24 00:00:00.000 | rsETH |
Abbas_ra21daily stats
Updated 2025-04-06
999
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 main AS (
select
block_timestamp,
FULL_DECODED_LOG:address AS Vault_address,
case
when FULL_DECODED_LOG:address = '0x10D0D11A8B693F4E3e33d09BBab7D4aFc3C03ef3' then 'weETH'
when FULL_DECODED_LOG:address = '0x49C077B74292aA8F589d39034Bf9C1Ed1825a608' then 'WETH'
when FULL_DECODED_LOG:address = '0x29c85c752e854b0Cf2372e6B6c56f260755f5120' then 'pzETH'
when FULL_DECODED_LOG:address = '0x4a5C95a0e3FCA4148F91cEb637fBA0E1080BE40e' then 'ezETH'
when FULL_DECODED_LOG:address = '0x3C12AA52b014Acf7957308808362909b5757cca8' then 'wstETH'
when FULL_DECODED_LOG:address = '0x1773002742A2bCc7666e38454F761CE8fe613DE5' then 'rswETH'
when FULL_DECODED_LOG:address = '0x46e3c018798d6de4517A3c98358E4BD8D334B79C' then 'rsETH'
when FULL_DECODED_LOG:address = '0xf34253Ec3Dd0cb39C29cF5eeb62161FB350A9d14' then 'swETH'
end AS Vault,
FULL_DECODED_LOG:data [0] :value / 1e18 AS totalSuuply,
FULL_DECODED_LOG:data [0] :value / 1e18 * price AS totalSuuply_USD,
FULL_DECODED_LOG:data [1] :value / 1e18 AS totalBorrows,
FULL_DECODED_LOG:data [1] :value / 1e18 * price AS totalBorrows_USD,
FULL_DECODED_LOG:data [2] :value / 1e18 AS accumulatedFees,
FULL_DECODED_LOG:data [2] :value / 1e18 * price AS accumulatedFees_USD,
FULL_DECODED_LOG:data [5] :value / 1e18 AS interestRate,
ORIGIN_TO_ADDRESS,
CONTRACT_ADDRESS
from
swell.core.ez_decoded_event_logs
inner join ethereum.price.ez_prices_hourly on date_trunc('hour', block_timestamp) = hour
and token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
where
ORIGIN_TO_ADDRESS = '0x08739cbede6e28e387685ba20e6409bd16969cde'
and EVENT_NAME = 'VaultStatus'
and CONTRACT_ADDRESS in (
lower('0x10D0D11A8B693F4E3e33d09BBab7D4aFc3C03ef3'),
lower('0x49C077B74292aA8F589d39034Bf9C1Ed1825a608'),
lower('0x29c85c752e854b0Cf2372e6B6c56f260755f5120'),
lower('0x4a5C95a0e3FCA4148F91cEb637fBA0E1080BE40e'),
lower('0x3C12AA52b014Acf7957308808362909b5757cca8'),
Last run: 21 days ago
...
592
45KB
5s