Address Rank | Total Fee | |
---|---|---|
1 | 322189 | 1.620569936 |
Mrftiyour gas fee
Updated 7 hours 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
›
⌄
-- forked from raw-turquoise copy copy copy @ https://flipsidecrypto.xyz/studio/queries/442eff73-2491-413a-b041-01a4ec36b5ed
WITH address_fees AS (
SELECT
from_address,
SUM(TX_FEE_PRECISE) AS total_fee
FROM
monad.testnet.fact_transactions
GROUP BY
from_address
),
ranked_fees AS (
SELECT
from_address,
total_fee,
RANK() OVER (ORDER BY total_fee DESC) AS fee_rank
FROM
address_fees
)
SELECT
fee_rank AS "Address Rank",
total_fee AS "Total Fee"
FROM
ranked_fees
WHERE
from_address = LOWER('{{Address}}');
Last run: about 7 hours agoAuto-refreshes every 12 hours
1
22B
32s