t1 as (

select message_value:sender as sender,

min (block_timestamp) as min_date

from terra.core.ez_messages

where tx_succeeded = 1

and message_type = '/cosmwasm.wasm.v1.MsgInstantiateContract'

group by 1

),

t2 as (

select

min_date::date as day,

count(distinct sender) as new_senders

from t1

group by 1

date_trunc('week', block_timestamp)::date as "Week",

count(distinct message_value:sender) "Senders Count",

new_senders as "New Senders",

sum("New Senders") over (order by "Week") as "Comulative New Senders Count",

sum("Senders Count") over (order by "Week") as "Comulative Senders Count"

from terra.core.ez_messages

join t2 on block_timestamp::date = day

where message_type = '/cosmwasm.wasm.v1.MsgExecuteContract'

and tx_succeeded = 1

group by 1, 3

order by 1