RESTAKE_DAY | TOTAL_SUPPLY_IN_ETH | TOTAL_REWARDS_IN_RSWETH | ETH_TO_RSWETH_RATE | |
|---|---|---|---|---|
1 | 2024-01-29 00:00:00.000 | 47587638.0232837 |
datavortexrestake rewards
Updated 2025-04-05
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 base AS (
SELECT
(
SUM(
CASE
WHEN decoded_log:from = '0x0000000000000000000000000000000000000000' THEN decoded_log:value
ELSE 0
END
) - SUM(
CASE
WHEN decoded_log:to = '0x0000000000000000000000000000000000000000' THEN decoded_log:value
ELSE 0
END
)
) / 1e18 AS circulating_supply,
DATE_TRUNC('day', MIN(block_timestamp)) AS restake_day
FROM
ethereum.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0xfae103dc9cf190ed75350761e95403b7b8afa6c0')
AND event_name = 'Transfer'
),
eth_price AS (
SELECT
AVG(price) AS avg_eth_price
FROM
ethereum.price.ez_prices_hourly
WHERE
symbol = 'ETH'
AND DATE_TRUNC('day', hour) = (SELECT restake_day FROM base)
),
rsweth_price AS (
SELECT
AVG(price) AS avg_rsweth_price
FROM
ethereum.price.ez_prices_hourly
Last run: 30 days ago
1
56B
32s