select

date_trunc('day', block_timestamp) as date,

tx_receiver as wallet_address,

(deposit / pow(10, 24)) as deposit_amount

from near.core.fact_transfers

where status = true and (

tx_signer = 'sweat_welcome.near' or

tx_signer like 'sweat_oracle_%.near'

)

having 0.05 >= deposit_amount

select count(distinct(wallet_address)) as "Number of active Wallets" from (

select date, wallet_address from t1

where date >= current_date - interval '1 months'

group by date, wallet_address