date_trunc('day', first_transaction_stamp) as first_transaction_date,

count(sender) as new_users

from (

select

msg_value:sender::string as sender,

min(block_timestamp) as first_transaction_stamp

from terra.msgs

WHERE msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' --anchor

AND block_timestamp >= CURRENT_DATE - 200

group by 1

)

where first_transaction_date > '2021-03-27'

and first_transaction_date < '2021-06-27'

group by 1

order by 1