SELECT

l.BLOCK_NUMBER,

l.TX_HASH,

l.EVENT_INDEX,

l.CONTRACT_ADDRESS,

l.TOPICS,

l.DATA,

l.TX_STATUS

FROM

blast.core.fact_event_logs l

WHERE

l.BLOCK_TIMESTAMP >= '2024-04-17' AND

l.CONTRACT_ADDRESS = LOWER('YOUR_CONTRACT_ADDRESS_HERE') -- Replace with actual contract address

),

contract_abi AS (

SELECT

ARRAY_CONSTRUCT(

{

"fragments": [

{

"type": "constructor",

"inputs": [

{

"name": "args",

"type": "tuple",

"baseType": "tuple",

"components": [

{

"name": "whitelistRoot",

"type": "bytes32",

"baseType": "bytes32",

"components": null,

"arrayLength": null,

"arrayChildren": null

},