select

tx_sender as wallet_address,

min(block_timestamp)::date as creation_date

from terra.core.fact_transactions

group by wallet_address

select

count(distinct wallet_address) as "Number of New Wallet",

round("Number of New Wallet" / count(distinct(creation_date))) as "Average New Wallet/Daily",

round("Number of New Wallet" / count(distinct(date_trunc('week', creation_date)))) as "Average New Wallet/Week"

from new_users

where creation_date >= '2022-12-25'

and creation_date < '2023-01-07'