CONTRACT_ADDRESS | TOTAL_GAS_USED_GWEI | TOTAL_GAS_SPENT | CONTRACT_NAME | |
|---|---|---|---|---|
1 | 0x4c4eabd5fb1d1a7234a48692551eaecff8194ca7 | 20.821728 | 0.00000115685917 | |
2 | 0xb33d7138c53e516871977094b249c8f2ab89a4f4 | 8.024497 | 4.359987091e-7 | |
3 | 0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7 | 5.305926 | 2.876432647e-7 | |
4 | 0x758d80767a751fc1634f579d76e1ccaab3485c9c | 4.486781 | 2.357140119e-7 | |
5 | 0xe25c57ff3eea05d0f8be9aaae3f522ddc803ca4e | 4.145523 | 2.206407563e-7 | |
6 | 0xcbe623d259261ffa0cfaff44484bff46c1b7d6c2 | 3.627162 | 2.084056926e-7 | |
7 | 0x2555223a15a931a71951707cb32a541f14e2c730 | 3.0358 | 1.665445839e-7 | |
8 | 0x822eb1add41cf87c3f178100596cf24c9a6442f6 | 2.675094 | 1.466603618e-7 | |
9 | 0xd227d3bce59b91380b7bc4a61a045b528b509439 | 2.258063 | 1.185432506e-7 | |
10 | 0xb2f82d0f38dc453d596ad40a37799446cc89274a | 2.076047 | 1.11727297e-7 |
monadmetrics-JFe1_Rbare-peach
Updated 2025-02-19
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
t.to_address AS contract_address,
SUM(COALESCE(t.gas_used, 0)) / 1e9 AS total_gas_used_gwei, -- تبدیل به Gwei برای مقادیر واقعیتر
SUM(COALESCE(t.gas_used * t.gas_price, 0)) / 1e18 AS total_gas_spent,
c.name AS contract_name
FROM MONAD.testnet.fact_transactions t
JOIN MONAD.testnet.dim_contracts c ON t.to_address = c.address
WHERE t.block_timestamp >= '2025-02-19 14:00:00'
GROUP BY contract_address, contract_name
ORDER BY total_gas_used_gwei DESC
LIMIT 10;
Last run: about 1 month ago
10
761B
2s