Afonso_DiazClaim Yield
Updated 2024-04-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with claim_yield as (
select
tx_hash,
block_timestamp,
from_address,
'0x' || substring(input_data, 35, 40) as contract_address,
'0x' || substring(input_data, 99, 40) as claimer,
input_data
from blast.core.fact_transactions
where to_address = '0x4300000000000000000000000000000000000002' -- ETH Address
and origin_function_signature = '0xf9719662' -- Claim Yield Function Signature
and status = 'SUCCESS'
)
select * from claim_yield
QueryRunArchived: QueryRun has been archived