from thorchain.core.fact_transfers

where block_timestamp::date >= '2024-06-01' and block_timestamp < '2024-07-01'

select block_timestamp,

from thorchain.defi.fact_swaps

where block_timestamp::date >= '2024-06-01' and block_timestamp < '2024-07-01'

select block_timestamp,

native_to_address as from_address

from thorchain.defi.fact_swaps

where block_timestamp::date >= '2024-06-01' and block_timestamp < '2024-07-01')

select trunc(block_timestamp,'day') as daily ,

'ethereum' as blockchain,

count(DISTINCT from_address) as active_addresses

from ethereum.core.fact_transactions

where block_timestamp::date >= '2024-06-01' and block_timestamp < '2024-07-01'

group by 1

UNION all

select trunc(block_timestamp,'day') as daily ,

'base' as blockchain,

count(DISTINCT from_address) as active_addresses

from base.core.fact_transactions

where block_timestamp::date >= '2024-06-01' and block_timestamp < '2024-07-01'

group by 1

UNION all

select trunc(block_timestamp,'day') as daily ,

'aptos' as blockchain,

count(DISTINCT sender) as active_addresses

from aptos.core.fact_transactions

where block_timestamp::date >= '2024-06-01' and block_timestamp < '2024-07-01'

and TX_TYPE ilike '%user%'

group by 1