select

block_timestamp::date as date,

count(distinct total.from_address) as active_users

from (

select

block_timestamp,

from_address

from arbitrum.core.fact_transactions as arbitrum

where arbitrum.to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'

and arbitrum.block_timestamp >= current_date - 30

union

select

block_timestamp,

from_address

from avalanche.core.fact_transactions as avax

where avax.to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'

and avax.block_timestamp >= current_date - 30

union

select

block_timestamp,

from_address

from bsc.core.fact_transactions as bsc

where bsc.to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'

and bsc.block_timestamp >= current_date - 30

union

select

block_timestamp,

from_address

from ethereum.core.fact_transactions as ethereum

where ethereum.to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'

and ethereum.block_timestamp >= current_date - 30

union

select

block_timestamp,

from_address