rezarwzAll Claim Gas TX
Updated 2024-03-22
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
›
⌄
SELECT
tx.tx_hash,
tx.ORIGIN_FUNCTION_SIGNATURE,
'ClaimAllGas' as function,
Concat('0x', substring(input_data, 35, 40)) AS contract_address,
Concat('0x', substring(input_data, 99, 40)) AS recipient,
AMOUNT
FROM
blast.core.fact_transactions tx
inner join blast.core.ez_native_transfers tr on tr.tx_hash = tx.tx_hash
and Concat('0x', substring(tx.input_data, 99, 40)) = tr.to_address
where
tx.to_Address = '0x4300000000000000000000000000000000000002'
and tx.origin_function_signature = '0x954fa5ee'
and tx.status = 'SUCCESS'
UNION all
SELECT
tx.tx_hash,
tx.ORIGIN_FUNCTION_SIGNATURE,
'ClaimGasAtMinClaimRate' as function,
Concat('0x', substring(input_data, 35, 40)) AS contract_address,
Concat('0x', substring(input_data, 99, 40)) AS recipient,
AMOUNT
FROM
blast.core.fact_transactions tx
inner join blast.core.ez_native_transfers tr on tr.tx_hash = tx.tx_hash
and Concat('0x', substring(tx.input_data, 99, 40)) = tr.to_address
where
tx.to_Address = '0x4300000000000000000000000000000000000002'
and tx.origin_function_signature = '0x0951888f'
and tx.status = 'SUCCESS'
union all
SELECT
tx.tx_hash,
tx.ORIGIN_FUNCTION_SIGNATURE,
'ClaimMaxGas' as function,
QueryRunArchived: QueryRun has been archived