flipside

    fun-amaranth
    monadmetrics-JFe1_Rfun-amaranth
    Updated 2025-03-16
    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
    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
    ORDER BY total_gas_used_gwei DESC
    LIMIT 10;
    Last run: 15 days ago
    CONTRACT_ADDRESS
    TOTAL_GAS_USED_GWEI
    TOTAL_GAS_SPENT
    1
    		0x4c4eabd5fb1d1a7234a48692551eaecff8194ca74098.7202970.0002220085126
    2
    		0x8462c247356d7deb7e26160dbfab16b351eef2422896.7152210.000150693681
    3
    		0x760afe86e5de5fa0ee542fc7b7b713e1c54257012561.6303390.0001333534863
    4
    		0xca810d095e90daae6e867c19df6d9a8c56db2c891614.2155870.00008510428766
    5
    		0xedb0f17e5b701c8a1278b94b961384cf4015f2401438.3564990.00007407536098
    6
    		0x758d80767a751fc1634f579d76e1ccaab3485c9c1381.1760010.00007233122171
    7
    		0x88b96af200c8a9c35442c8ac6cd3d22695aae4f01245.4311290.00006698805127
    8
    		0x2c9c959516e9aaedb2c748224a41249202ca8be71235.8743970.00006464848631
    9
    		0x822eb1add41cf87c3f178100596cf24c9a6442f61190.1154650.00006346124882
    10
    		0x2555223a15a931a71951707cb32a541f14e2c7301180.4705710.00006320625127
    10
    757B
    10s