SELECT

tx_hash,

block_timestamp,

origin_from_address as ua,

decoded_log:maker as maker_ad,

decoded_log:gives as gives,

case

when (decoded_log:maker, block_timestamp) in (

SELECT

decoded_log:maker,

min(block_timestamp)

FROM

blast.core.ez_decoded_event_logs

where

contract_address = '0xb1a49c54192ea59b233200ea38ab56650dfb448c'

and event_name = 'OfferWrite'

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 = 'OfferWrite'

),

initial_weeks AS (

SELECT

maker_ad,

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

FROM

all_makers

GROUP BY

1