with mint_mmp_tab AS (

SELECT

,tx_hash

,origin_from_address AS user_address

,amount AS mmp_amount

FROM kaia.core.ez_token_transfers

WHERE contract_address = '0x1c7354946d67426ce4e4625d8a82d0db8977ece9' -- mmp token_contract

AND contract_address = origin_to_address

AND from_address = '0x0000000000000000000000000000000000000000' -- mint mmp

),

trace_data AS (

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

),