SELECT

BLOCK_TIMESTAMP,

TX_HASH,

FROM_ADDRESS,

TO_ADDRESS,

TRACE_INDEX,

VALUE_PRECISE

FROM kaia.core.fact_traces

WHERE block_timestamp::date >= '2025-01-01'

AND tx_hash in (SELECT tx_hash FROM kaia.core.fact_event_logs WHERE topics[0] = '0x960a6bb8032c55b0217dc5d5e962cd62168b247a4dfc80213fb185caeb120143')

),

fees AS (

SELECT

TX_HASH,

SUM(CASE WHEN To_address = '0x4d129c57945e769dde797ae7058da8d6c89fd9db' THEN VALUE_PRECISE ELSE 0 END) AS FIRST_FEE,

SUM(CASE WHEN TO_ADDRESS = '0xfb1bffc9d739b8d520daf37df666da4c687191ea' THEN VALUE_PRECISE ELSE 0 END) AS SECOND_FEE

FROM trace_data

GROUP BY TX_HASH

),

program_address AS (

SELECT TX_HASH, TO_ADDRESS AS PROGRAM_ADDRESS, VALUE_PRECISE AS RETURNED_TO_PROGRAM

FROM trace_data

WHERE TRACE_INDEX = 4

),

user_spent AS (

SELECT TX_HASH,from_address AS User_address, VALUE_PRECISE AS USER_SPENT

FROM trace_data

WHERE TRACE_INDEX = 0

),

aggregated_data AS (

SELECT

DISTINCT td.TX_HASH,

us.User_address,