gonisgoneWeekly Gas Fee (Kaia)
    Updated 2024-12-05
    SELECT
    SUM(TX_FEE) AS total_tx_fee
    FROM
    kaia.core.fact_transactions
    WHERE
    block_timestamp > current_date - interval '1 weeks'
    AND (
    LOWER(TO_ADDRESS) = LOWER('0xd068c52d81f4409b9502da926ace3301cc41f623')
    OR LOWER(TO_ADDRESS) = LOWER('0x277b2A92981Ca6b0A5BF68D5132E9a78fe82a493')// NftSwap
    OR LOWER(TO_ADDRESS) = LOWER('0x878A3C28D908e5b306A9AEcfCaBcAA8D45E223EC') // NftSwapRewardPool
    OR LOWER(TO_ADDRESS) = LOWER('0x4ac812496ff116465Af2113CF30C80776d062220') // NftCoupon
    OR LOWER(TO_ADDRESS) = LOWER('0xaff706fb4f076a0a8ebfc56827a22cedafced05f') // WARP
    OR LOWER(TO_ADDRESS) = LOWER('0x23e98827c59072b6dcd69e85a5df3d8c7f7f8a6a') // MBX Marketplace
    OR LOWER(TO_ADDRESS) = LOWER('0x97d7d58aE30A0449A43546235C7fBd449486344b') // NFTStaking
    OR LOWER(TO_ADDRESS) = LOWER('0xCB63495F08a4CC192732895d53fFA4b0caFfD81C') // Ticker
    OR LOWER(TO_ADDRESS) = LOWER('0x26de5ada52200adb90977164df2c5949ebd8f740') // MBX Puzzle
    OR LOWER(TO_ADDRESS) = LOWER('0x50f718ca7dc27393dbcc2b41c5867c588e2b48fb') // MBX Lunar
    OR LOWER(TO_ADDRESS) = LOWER('0x29c4b12cb6a9565aeffb25739848994cb130c598') // MBX Marblership
    OR LOWER(TO_ADDRESS) = LOWER('0xd16CA89531313248dce164A2fedc24AdF7AC9905') // MBX KoongYa Service
    OR LOWER(TO_ADDRESS) = LOWER('0x89D1dD7264872A0345ff3Da174dBf202f09c4053') // MBX KoongYa NFT
    OR LOWER(TO_ADDRESS) = LOWER('0xC8901B766D68f08400311fCcC4c5372B2c4343E9') // MBX KoongYa Award
    OR LOWER(TO_ADDRESS) = LOWER('0x7D19581d5b69cbd45Cf18622147BB4b858D9000e') // MBX KoongYa Astronaut
    OR LOWER(TO_ADDRESS) = LOWER('0xB090c70E869e68c89C8359599e9f3e8D9Cf24B10') // MBX KoongYa Cuisine
    )
    Last run: about 1 month ago
    TOTAL_TX_FEE
    1
    85.914627155
    1
    16B
    3s