SELECT

block_timestamp,

decoded_log:taker as taker,

decoded_log:maker as maker

FROM blast.core.fact_decoded_event_logs

WHERE contract_address IN ('0x739f0331594029064c252559436edce0e468e37a', '0x6a3796c21e733a3016bc0ba41edf763016247e72')

AND event_name = 'OrderFilled'

),

first_interactions AS (

SELECT

taker AS user,

MIN(block_timestamp) AS first_interaction

FROM predictfun

GROUP BY taker

UNION ALL

SELECT

maker AS user,

MIN(block_timestamp) AS first_interaction

FROM predictfun

GROUP BY maker

),

daily_new_users AS (

SELECT

DATE_TRUNC('day', first_interaction) AS interaction_date,

COUNT(DISTINCT user) AS new_users,

SUM(COUNT(DISTINCT user)) OVER (ORDER BY interaction_date) AS Cum_users

FROM first_interactions

GROUP BY interaction_date

SELECT * FROM daily_new_users