WITH logs_pull AS (

SELECT

topics,

contract_address,

DATA,

tx_hash,

block_number,

block_timestamp

FROM

base.core.fact_event_logs

WHERE 1=1

AND block_timestamp>='2024-09-01'

AND topics [0] :: STRING IN (

'0x3286b0394bf1350245290b7226c92ed186bd716f28938e62dbb895298f018172',

'0x7f26b83ff96e1f2b6a682f133852f6798a09c465da95921460cefb3847402498'

)

),

new_prod AS (

SELECT

regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,

utils.udf_hex_to_int(

's2c',

segmented_data [0] :: STRING

) :: INT AS product_id,

tx_hash,

block_number,

block_timestamp

FROM

logs_pull

WHERE

topics [0] :: STRING = '0x3286b0394bf1350245290b7226c92ed186bd716f28938e62dbb895298f018172'

),