rezarwzClaimed Gas Fee by Dapps
    Updated 2025-04-10
    with all_data as (
    SELECT
    *
    from
    (
    SELECT
    *,
    CASE
    when ORIGIN_FUNCTION_SIGNATURE = '0x954fa5ee' then 'ClaimAllGas'
    when ORIGIN_FUNCTION_SIGNATURE = '0x860043b6' then 'ClaimAllYield'
    when ORIGIN_FUNCTION_SIGNATURE = '0xfafce39e' then 'ClaimGas'
    when ORIGIN_FUNCTION_SIGNATURE = '0x0951888f' then 'ClaimGasAtMinClaimRate'
    when ORIGIN_FUNCTION_SIGNATURE = '0x662aa11d' then 'ClaimMaxGas'
    when ORIGIN_FUNCTION_SIGNATURE = '0xf9719662' then 'ClaimYield'
    when ORIGIN_FUNCTION_SIGNATURE = '0xc8992e61' then 'Configure'
    when ORIGIN_FUNCTION_SIGNATURE = '0x7114177a' then 'ConfigureAutomaticYield'
    when ORIGIN_FUNCTION_SIGNATURE = '0x3ba5713e' then 'ConfigureAutomaticYieldOnBehlaf'
    when ORIGIN_FUNCTION_SIGNATURE = '0x4e606c47' then 'ConfigureClaimableGas'
    when ORIGIN_FUNCTION_SIGNATURE = '0x908c8502' then 'ConfigureClaimableGasOnBehalf'
    when ORIGIN_FUNCTION_SIGNATURE = '0xf098767a' then 'ConfigureClaimableYield'
    when ORIGIN_FUNCTION_SIGNATURE = '0x4c802f38' then 'ConfigureContract'
    when ORIGIN_FUNCTION_SIGNATURE = '0x37ebe3a8' then 'ConfigureClaimableYieldOnBehalf'
    when ORIGIN_FUNCTION_SIGNATURE = '0xeb864698' then 'ConfigureGoverner'
    when ORIGIN_FUNCTION_SIGNATURE = '0x0ca12c4b' then 'ConfigureGovernerOnBehalf'
    when ORIGIN_FUNCTION_SIGNATURE = '0x2210dfb1' then 'ConfigureVoidGas'
    when ORIGIN_FUNCTION_SIGNATURE = '0xeb59acdc' then 'ConfigureVoidGasOnBehalf'
    when ORIGIN_FUNCTION_SIGNATURE = '0xaa857d98' then 'ConfigureVoidYield'
    when ORIGIN_FUNCTION_SIGNATURE = '0xb71d6dd4' then 'ConfigureVoidYieldOnBehalf'
    Else 'initialize'
    end as event_name
    FROM
    blast.core.fact_transactions
    where
    to_Address = '0x4300000000000000000000000000000000000002'
    and STATUS = 'SUCCESS'
    )
    Last run: 17 days ago
    CONTRACT_ADDRESS
    NAME
    Claimed Gas Fee (ETH)
    CREATOR_ADDRESS
    1
    0x40a2accbd92bca938b02010e17a5b8929b49130dJucieFinance267.9191230180x4e59b44847b379578588920ca78fbf26c0b4956c
    2
    0xb85b77f32dbdb7e4895b288e70770c90e232c751SynFutures193.1297671390x03b7a26da62f25ca2b5b236f1cb477c2fe81b372
    3
    0x87300d35353d21479e0c96b87d9a7997726f4c16133.2862560370x4e1dcf7ad4e460cfd30791ccc4f9c8a4f820ec67
    4
    0x3b143ca171194c97183ef51b0d56554aa68d0588Thruster113.9372277210xa6b71e26c5e0845f74c812102ca7114b6a896ab2
    5
    0xfb03340fdb69024c6579b35170f1b3c0d7d67242YoloGames76.7995323130xa6b71e26c5e0845f74c812102ca7114b6a896ab2
    6
    0x6b86ff7863e27d1c8ccf05df9cb03b8efaa52125YoloGames55.164053180xa6b71e26c5e0845f74c812102ca7114b6a896ab2
    7
    0xf9d64d54d32ee2bdceaabfa60c4c438e224427d0JucieFinance40.214265960x4e59b44847b379578588920ca78fbf26c0b4956c
    8
    0xf8797db8a9eed416ca14e8dfaede2bf4e1aabfc3Hypersound28.0782266330x62951c8fe1b7ba6e9a873f137c99776d8861e799
    9
    0xc73c8c60ea7d7f4338f9a8542927f4f1471e36edAmbient240xa6b71e26c5e0845f74c812102ca7114b6a896ab2
    10
    0xba99b8a284f45447929a143dc2efa5bcfe7ade6017.0941266180x14f3fc5bd9f29fa60b84310cf6e5cfed67d75fb9
    11
    0xa0df6adaa4f7e880b4b3c40147c6ae92124d88a814.4147840030x13e5eeafb74f6026aeeb35401737d50da7ff103f
    12
    0xc15568330926e2a6f1519992b0364ca00faf6a7aDuelArena9.1642514890xbe16d5c286aa885a2261a6b99a518e5effd2f388
    13
    0xde79a65dfb3d0b1bc212cb283a5ccbc51707e4e8Spacebar8.5993353910xa6b71e26c5e0845f74c812102ca7114b6a896ab2
    14
    0x6764b30cf85ba2474c81ccf8be26ac263244a763MemeFun7.4959234660x7929100c062e91bbd31baf5fa587ef80de0f049a
    15
    0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7Layer3 CUBE6.7103742830xf1c0df2381ac4a6cac9c866ddbde3c3d641a1337
    16
    0x8044f710c58b6ea6a178cc540f9f1cd758f7d1b2Baseline6.205128440xa6b71e26c5e0845f74c812102ca7114b6a896ab2
    17
    0x7adce99519db8b7d5a010e12e359ade0bbabb219unknown5.8947646370x65432138ae74065aeb3bd71aeac887ccae0e32a4
    18
    0x73c369f61c90f03eb0dd172e95c90208a28dc5bcOLE token powering both DistrictOne and OpenLeverage5.8115548820xbc2beee86f74fe7e86f58d46d2a6c09019be0c3c
    19
    0x8898962bdf1c40e06e8d5f5b231000e7908c3f12Modular Punk Traits5.7780035150xc1e42f862d202b4a0ed552c1145735ee088f6ccf
    20
    0x1dd4fb074e9f28ca9d21c93e0aa915b487893b1c5.6662779250xd04e20f3e8ed0d382e27d05fd0675d345f7ac7c3
    ...
    5837
    630KB
    266s