with tb0_0 AS (

SELECT

block_timestamp,

BLOCK_ID,

tx_hash,

ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER)::string as receiver,

ifnull(tx:actions[0]:Delegate:delegate_action:sender_id::string, TX_SIGNER)::string AS user

FROM near.core.fact_transactions

where block_timestamp::date >= current_date - 30

,

tb0 as ( select block_timestamp,

from thorchain.core.fact_transfers

where block_timestamp::date >= current_date - 30

select block_timestamp,

from thorchain.defi.fact_swaps

where block_timestamp::date >= current_date - 30

select block_timestamp,

native_to_address as from_address

from thorchain.defi.fact_swaps

where block_timestamp::date >= current_date - 30),

tb5 as (select address from avalanche.core.dim_contracts)

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 >= current_date - 30

group by 1