block_timestamp,

tx_hash,

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

blast.core.fact_transactions transactions

JOIN blast.core.fact_traces traces using (tx_hash)

transactions.to_address = '0x4300000000000000000000000000000000000002'

AND traces.type = 'CALL'

AND traces.FROM_address = '0x4300000000000000000000000000000000000001'

AND transactions.status = 'SUCCESS'

AND transactions.origin_function_signature = '0x954fa5ee'