DATE | ETH amount | Total claimed(ETH) | |
|---|---|---|---|
1 | 2024-05-01 00:00:00.000 | 122.145174784 | 335.816874597 |
2 | 2024-12-01 00:00:00.000 | 20.977236673 | 1228.286692032 |
3 | 2024-09-01 00:00:00.000 | 82.759005323 | 916.218050039 |
4 | 2024-06-01 00:00:00.000 | 176.669603519 | 512.486478116 |
5 | 2024-04-01 00:00:00.000 | 183.041320155 | 213.671699813 |
6 | 2024-11-01 00:00:00.000 | 250.699182 | 1207.309455359 |
7 | 2024-10-01 00:00:00.000 | 40.39222332 | 956.610273359 |
8 | 2024-07-01 00:00:00.000 | 189.687875873 | 702.17435399 |
9 | 2024-08-01 00:00:00.000 | 131.284690726 | 833.459044716 |
10 | 2024-02-01 00:00:00.000 | 0.20991404 | 0.20991404 |
11 | 2025-02-01 00:00:00.000 | 13.327799908 | 1260.234719672 |
12 | 2025-01-01 00:00:00.000 | 18.620227732 | 1246.906919764 |
13 | 2024-03-01 00:00:00.000 | 30.420465619 | 30.630379659 |
rezarwz Claiming Gas Fees by developers
Updated 2025-02-24
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
29
30
31
32
33
34
35
36
›
⌄
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: about 1 month ago
13
715B
217s