TOTAL_SUPPLY_IN_ETH | TOTAL_REWARDS_IN_RSWETH | ETH_TO_RSWETH_RATE | RECEIVED_REWARDS | COMMISION_RATE | |
|---|---|---|---|---|---|
1 | 71081094.933909 | 73572128.6460065 | 1.035 | 2491033.71209751 | 10 |
datavortexrewards
Updated 2025-04-25
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,
10 as commision_rate
FROM
ethereum.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0xfae103dc9cf190ed75350761e95403b7b8afa6c0')
AND event_name = 'Transfer'
),
eth_price AS (
SELECT
price
FROM
ethereum.price.ez_prices_hourly
WHERE
symbol = 'WETH'
ORDER BY
hour DESC
LIMIT
1
), rsweth_price AS (
SELECT
price
Last run: 12 days ago
1
62B
19s