Afonso_DiazSource
Updated 2024-03-16
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 claimGasMinRate AS (
SELECT
tx_hash,
block_timestamp,
traces.to_address,
concat('0x', substring(input_data, 35, 40)) AS contract_address,
concat('0x', substring(input_data, 99, 40)) AS gas_claimer,
traces.value AS amount
FROM
blast.core.fact_transactions transactions
JOIN blast.core.fact_traces traces using (tx_hash)
WHERE
transactions.to_address = '0x4300000000000000000000000000000000000002'
AND traces.type = 'CALL'
AND traces.FROM_address = '0x4300000000000000000000000000000000000001'
AND transactions.status = 'SUCCESS'
AND transactions.origin_function_signature = '0x0951888f'
),
claimAllGas AS (
SELECT
tx_hash,
block_timestamp,
traces.to_address,
traces.value AS amount,
concat('0x', substring(input_data, 35, 40)) AS contract_address,
concat('0x', substring(input_data, 99, 40)) AS gas_claimer
FROM
blast.core.fact_transactions transactions
JOIN blast.core.fact_traces traces using (tx_hash)
WHERE
transactions.to_address = '0x4300000000000000000000000000000000000002'
AND traces.type = 'CALL'
AND traces.FROM_address = '0x4300000000000000000000000000000000000001'
AND transactions.status = 'SUCCESS'
AND transactions.origin_function_signature = '0x954fa5ee'
),
QueryRunArchived: QueryRun has been archived