WEEK | TOTAL_TX_FEE | AVG_TX_FEE | |
|---|---|---|---|
1 | 2025-03-17 00:00:00.000 | 8.717062278 | 0.02027223785 |
2 | 2025-03-10 00:00:00.000 | 19.442983669 | 0.01956034574 |
3 | 2025-03-03 00:00:00.000 | 18.390579283 | 0.01933814856 |
4 | 2025-02-24 00:00:00.000 | 19.595819591 | 0.01751190312 |
5 | 2025-02-17 00:00:00.000 | 26.944062231 | 0.01875021728 |
6 | 2025-02-10 00:00:00.000 | 18.954069417 | 0.02009975548 |
7 | 2025-02-03 00:00:00.000 | 24.232601056 | 0.02092625307 |
8 | 2025-01-27 00:00:00.000 | 13.750292755 | 0.01644771861 |
9 | 2025-01-20 00:00:00.000 | 23.038254362 | 0.01910303015 |
10 | 2025-01-13 00:00:00.000 | 15.27654437 | 0.01820803858 |
11 | 2025-01-06 00:00:00.000 | 16.804198815 | 0.01826543349 |
12 | 2024-12-30 00:00:00.000 | 10.949932538 | 0.01546600641 |
13 | 2024-12-23 00:00:00.000 | 12.985570055 | 0.01834120064 |
14 | 2024-12-16 00:00:00.000 | 24.630397758 | 0.01943993509 |
15 | 2024-12-09 00:00:00.000 | 13.461932684 | 0.01755141158 |
16 | 2024-12-02 00:00:00.000 | 16.69505602 | 0.01651340853 |
17 | 2024-11-25 00:00:00.000 | 16.694220764 | 0.01724609583 |
18 | 2024-11-18 00:00:00.000 | 18.799991088 | 0.01723188917 |
19 | 2024-11-11 00:00:00.000 | 13.294210333 | 0.01571419661 |
20 | 2024-11-04 00:00:00.000 | 11.26046844 | 0.01673175103 |
datavortexWeekly Fees
Updated 2025-03-19
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 transfer_from_ronin AS (
SELECT
t.tx_hash,
MAX(CASE WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_to, t.decoded_log:to) END) AS bridger,
MAX(CASE WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_value, t.decoded_log:value) END) AS transfer_value_raw,
MAX(CASE WHEN t.event_name = 'Transfer' THEN t.contract_address END) AS contract_address,
MAX(DATE_TRUNC('day', t.block_timestamp)) AS event_date
FROM ronin.core.ez_decoded_event_logs t
WHERE t.event_name IN ('Transfer', 'Deposited')
AND t.ORIGIN_FUNCTION_SIGNATURE = '0xb9afa177'
AND (
(t.event_name = 'Deposited'
AND t.decoded_log:anonymous_1.mainchain.chainId = 1
AND t.decoded_log:anonymous_1.ronin.chainId = 2020)
OR (t.event_name = 'Transfer'
AND COALESCE(t.decoded_log:_from, t.decoded_log:from) = '0x0cf8ff40a508bdbc39fbe1bb679dcba64e65c7df')
)
AND t.contract_address NOT IN (
'0xf083289535052e8449d69e6dc41c0ae064d8e3f6',
'0x241a81fc0d6692707dad2b5025a3a7cf2cf25acf',
'0x5cf6654fc5f33dfbaf3f6f859fbbe5f017edcc3b'
)
GROUP BY t.tx_hash
),
transfer_to_ronin AS (
SELECT
t.tx_hash,
MAX(CASE WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_from, t.decoded_log:from) END) AS bridger,
MAX(CASE WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_value, t.decoded_log:value) END) AS transfer_value_raw,
MAX(CASE WHEN t.event_name = 'Transfer' THEN t.contract_address END) AS contract_address,
MAX(DATE_TRUNC('day', t.block_timestamp)) AS event_date
FROM ronin.core.ez_decoded_event_logs t
WHERE t.event_name IN ('Transfer', 'WithdrawalRequested')
AND t.ORIGIN_FUNCTION_SIGNATURE = '0x0b1ff17f'
AND (
(t.event_name = 'WithdrawalRequested'
Last run: 2 months ago
25
1KB
12s