WEEK | weekly_fees_usd | weekly_tx_count | cumulative_fees_usd | |
|---|---|---|---|---|
1 | 2024-12-23 00:00:00.000 | 14.542248501 | 451 | 14.542248501 |
2 | 2024-12-30 00:00:00.000 | 128.625364555 | 4871 | 143.167613056 |
3 | 2025-01-06 00:00:00.000 | 150.654436076 | 6571 | 293.822049132 |
4 | 2025-01-13 00:00:00.000 | 175.952876428 | 5251 | 469.77492556 |
5 | 2025-01-20 00:00:00.000 | 138.566272349 | 17079 | 608.341197908 |
6 | 2025-01-27 00:00:00.000 | 158.66534877 | 31295 | 767.006546679 |
7 | 2025-02-03 00:00:00.000 | 64.886556134 | 16099 | 831.893102812 |
8 | 2025-02-10 00:00:00.000 | 2601.087547407 | 97176 | 3432.980650219 |
9 | 2025-02-17 00:00:00.000 | 1362.09374861 | 46637 | 4795.074398829 |
10 | 2025-02-24 00:00:00.000 | 330.029614949 | 26801 | 5125.104013778 |
11 | 2025-03-03 00:00:00.000 | 357.473631229 | 25039 | 5482.577645007 |
12 | 2025-03-10 00:00:00.000 | 222.84416274 | 14229 | 5705.421807748 |
13 | 2025-03-17 00:00:00.000 | 265.199797125 | 14553 | 5970.621604872 |
14 | 2025-03-24 00:00:00.000 | 265.297761037 | 14480 | 6235.919365909 |
15 | 2025-03-31 00:00:00.000 | 425.781645878 | 26933 | 6661.701011788 |
16 | 2025-04-07 00:00:00.000 | 182.774731707 | 23772 | 6844.475743494 |
17 | 2025-04-14 00:00:00.000 | 98.915436391 | 12243 | 6943.391179886 |
18 | 2025-04-21 00:00:00.000 | 71.231312875 | 12576 | 7014.622492761 |
19 | 2025-04-28 00:00:00.000 | 0.2190533433 | 73 | 7014.841546104 |
datavortexweekly Fees
Updated 7 days ago
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 SwapData AS (
SELECT DISTINCT
tx_hash,
block_timestamp
FROM
ink.core.ez_decoded_event_logs
WHERE
event_name = 'Swap'
AND origin_to_address = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
AND block_timestamp IS NOT NULL
AND tx_succeeded = TRUE
),
HourlyEthPrices AS (
SELECT
DATE_TRUNC('hour', HOUR) AS price_hour,
PRICE AS eth_price_usd
FROM
ink.price.ez_prices_hourly
WHERE
SYMBOL = 'WETH'
),
SwapFees AS (
SELECT
sd.tx_hash,
sd.block_timestamp,
t.TX_FEE AS tx_fee_eth,
DATE_TRUNC('hour', sd.block_timestamp) AS swap_hour,
DATE_TRUNC('week', sd.block_timestamp) AS swap_week
FROM SwapData sd
JOIN ink.core.fact_transactions t
ON sd.tx_hash = t.tx_hash
),
FeesWithPrices AS (
Last run: 7 days ago
19
1KB
5s