SELECT count(distinct from_address) as active_wallets_doing_transactions

from polygon.core.fact_transactions

where block_timestamp::date = current_date - 1

),

active_users_2 as (

SELECT count(distinct to_address) as active_wallets_receiving_tokens

from polygon.core.fact_transactions

where block_timestamp::date = current_date - 1

select *,

active_wallets_doing_transactions+active_wallets_receiving_tokens as current_active_wallets

from active_users, active_users_2