(DISTINCT(user)) number_of_wallets ,

date from (

select FROM

_ADDRESS as user ,block_timestamp::date as date

FROM ethereum.core.fact_transactions

WHERE block_timestamp

BETWEEN '2022-06-01'

and '2022-07-01'

UNION

select TO_ADDRESS as user ,block_timestamp::date as date

FROM ethereum.core.fact_transactions

WHERE block_timestamp

BETWEEN '2022-06-01'

and '2022-07-01'

)

GROUP by date