SELECT

DATE_TRUNC('day', block_timestamp) AS day,

tx_hash,

origin_from_address,

CASE

WHEN CAST(decoded_log:_amount0In AS INTEGER) > 0

THEN CAST(decoded_log:_amount0In AS INTEGER) / POWER(10, 6)

ELSE CAST(decoded_log:_amount0Out AS INTEGER) / POWER(10, 6)

END AS amount0_used

FROM ronin.core.ez_decoded_event_logs

WHERE

contract_address = '0x4f7687affc10857fccd0938ecda0947de7ad3812'

AND origin_to_address = '0x5f0acdd3ec767514ff1bf7e79949640bf94576bd'

AND origin_function_signature = '0x3593564c'

AND event_name = 'Swap'

AND block_timestamp >= '2024-11-20'

),

agg_by_week AS (

SELECT

DATE_TRUNC('week', day) AS week,

COUNT(DISTINCT tx_hash) AS tx_count,

COUNT(DISTINCT origin_from_address) AS swappers,

SUM(amount0_used) AS volume

FROM base

GROUP BY week

),

reference AS (

SELECT *

FROM agg_by_week

WHERE week = DATE_TRUNC('week', DATE '2024-11-25')

),

comparison AS (