SELECT

DATE_TRUNC('day', block_timestamp) AS day,

DECODED_LOG:"recipient" AS recipient,

DECODED_LOG:"user" AS sender

FROM ink.core.ez_decoded_event_logs

WHERE ORIGIN_TO_ADDRESS = '0x9f500d075118272b3564ac6ef2c70a9067fd2d3f'

AND TX_SUCCEEDED = 'TRUE'

AND ORIGIN_FUNCTION_SIGNATURE IN ('0xe884624b', '0xc0129d43')

),

user_stats AS (

SELECT

user,

COUNT(CASE WHEN user = sender THEN 1 END) AS total_sent,

COUNT(CASE WHEN user = recipient THEN 1 END) AS total_received,

GREATEST(COUNT(DISTINCT CASE WHEN user = sender THEN recipient END)-1 , 0) AS unique_gms_sent,

COUNT(DISTINCT CASE WHEN user = recipient THEN sender END) AS unique_gms_received,

COUNT(DISTINCT day) AS active_days

FROM (

SELECT sender AS user, recipient,sender, day FROM gm_data

UNION ALL

SELECT recipient AS user, recipient,sender, day FROM gm_data

) AS combined

GROUP BY user

),

user_activity AS (

SELECT sender AS user, day FROM gm_data

UNION

SELECT recipient AS user, day FROM gm_data

),

streak_computation AS (