WEEK | WEEKLY_FEE_USD | CUMULATIVE_FEE_USD | |
|---|---|---|---|
1 | 2024-01-29 00:00:00.000 | 19405.457279482 | 19405.457279482 |
2 | 2024-02-05 00:00:00.000 | 21687.875651979 | 41093.332931461 |
3 | 2024-02-12 00:00:00.000 | 9268.32999911 | 50361.662930572 |
4 | 2024-02-19 00:00:00.000 | 26621.175153021 | 76982.838083592 |
5 | 2024-02-26 00:00:00.000 | 22595.120267633 | 99577.958351226 |
6 | 2024-03-04 00:00:00.000 | 18028.918984371 | 117606.877335597 |
7 | 2024-03-11 00:00:00.000 | 30071.653348432 | 147678.530684029 |
8 | 2024-03-18 00:00:00.000 | 67569.75610404 | 215248.286788069 |
9 | 2024-03-25 00:00:00.000 | 53442.303413043 | 268690.590201112 |
10 | 2024-04-01 00:00:00.000 | 25309.872363487 | 294000.462564599 |
11 | 2024-04-08 00:00:00.000 | 46245.870146483 | 340246.332711083 |
12 | 2024-04-15 00:00:00.000 | 14759.648215832 | 355005.980926914 |
13 | 2024-04-22 00:00:00.000 | 7943.567631687 | 362949.548558601 |
14 | 2024-04-29 00:00:00.000 | 4988.807623953 | 367938.356182554 |
15 | 2024-05-06 00:00:00.000 | 7019.230928433 | 374957.587110987 |
16 | 2024-05-13 00:00:00.000 | 3736.853688949 | 378694.440799937 |
17 | 2024-05-20 00:00:00.000 | 2971.88969137 | 381666.330491307 |
18 | 2024-05-27 00:00:00.000 | 3889.684322475 | 385556.014813782 |
19 | 2024-06-03 00:00:00.000 | 2469.225429491 | 388025.240243273 |
20 | 2024-06-10 00:00:00.000 | 3002.47699339 | 391027.717236662 |
datavortexrestake fee in usd
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
›
⌄
WITH base AS (
SELECT DISTINCT tx_hash, block_timestamp
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address = LOWER('0xfae103dc9cf190ed75350761e95403b7b8afa6c0')
AND event_name = 'Transfer'
AND decoded_log:from = '0x0000000000000000000000000000000000000000'
),
tx_fees AS (
SELECT tx_hash, tx_fee, block_timestamp
FROM ethereum.core.fact_transactions
),
eth_price AS (
SELECT hour AS price_hour, price
FROM ethereum.price.ez_prices_hourly
WHERE symbol = 'WETH'
)
SELECT
DATE_TRUNC('week', b.block_timestamp) AS week,
SUM(f.tx_fee * p.price) AS weekly_fee_usd,
SUM(SUM(f.tx_fee * p.price)) OVER (ORDER BY DATE_TRUNC('week', b.block_timestamp)) AS cumulative_fee_usd
FROM base b
JOIN tx_fees f ON b.tx_hash = f.tx_hash
JOIN eth_price p ON DATE_TRUNC('hour', f.block_timestamp) = p.price_hour
GROUP BY DATE_TRUNC('week', b.block_timestamp)
ORDER BY week;
Last run: about 1 month ago
65
4KB
108s