rezarwzall tx for claiming the yield
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
›
⌄
SELECT
tx_hash,
ORIGIN_FUNCTION_SIGNATURE,
'claimAllYield' as function,
'0x' || SUBSTRING(input_data, 35, 40) AS contract_Address,
'0x' || SUBSTRING(input_data, 99, 40) AS receiver
from
blast.core.fact_transactions
where
to_address = '0x4300000000000000000000000000000000000002'
and ORIGIN_FUNCTION_SIGNATURE = '0x860043b6'
union all
SELECT
tx_hash,
ORIGIN_FUNCTION_SIGNATURE,
'claimYield' as function,
'0x' || SUBSTRING(input_data, 35, 40) AS contract_Address,
'0x' || SUBSTRING(input_data, 99, 40) AS receiver
from
blast.core.fact_transactions
where
to_address = '0x4300000000000000000000000000000000000002'
and ORIGIN_FUNCTION_SIGNATURE = '0xf9719662'
QueryRunArchived: QueryRun has been archived