SELECT

tx_hash,

block_timestamp,

decoded_log:taker as taker_Ad,

case

when (decoded_log:taker, block_timestamp) in (

SELECT

decoded_log:taker,

min(block_timestamp)

from

blast.core.ez_decoded_event_logs

where

contract_address = '0xb1a49c54192ea59b233200ea38ab56650dfb448c'

and event_name = 'OrderComplete'

group by

1

) then 'New User'

else 'Returning User'

end as user_type

from

blast.core.ez_decoded_event_logs

where

contract_address = '0xb1a49c54192ea59b233200ea38ab56650dfb448c'

and event_name = 'OrderComplete'

),

initial_weeks AS (

SELECT

taker_ad,

MIN(DATE_TRUNC('WEEK', block_timestamp)) AS first_week

FROM

all_Takers

GROUP BY

1

),

maker_weeks AS (