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 >= '2024-12-01' and block_timestamp < '2025-01-01' UNION SELECT block_timestamp, BLOCK_ID, tx_hash, to_address::string as receiver, from_address::string AS user FROM near.core.ez_token_transfers where block_timestamp::Date >= '2024-12-01' and block_timestamp < '2025-01-01' UNION SELECT block_timestamp, BLOCK_ID, tx_hash, receiver_id::string as receiver, SIGNER_ID::string AS user FROM near.core.fact_actions_events_function_call where block_timestamp::Date >= '2024-12-01' and block_timestamp < '2025-01-01' UNION SELECT block_timestamp, BLOCK_ID, tx_hash, receiver_id::string as receiver, PREDECESSOR_ID::string AS user FROM near.core.fact_actions_events_function_call where block_timestamp::Date >= '2024-12-01' and block_timestamp < '2025-01-01' ) , tb0 as ( select block_timestamp, from_address from thorchain.core.fact_transfers where block_timestamp::date >= '2024-12-01' and block_timestamp < '2025-01-01' UNION select block_timestamp, from_address from thorchain.defi.fact_swaps where block_timestamp::date >= '2024-12-01' and block_timestamp < '2025-01-01' UNION select block_timestamp, native_to_address as from_address from thorchain.defi.fact_swaps where block_timestamp::date >= '2024-12-01' and block_timestamp < '2025-01-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-12-01' and block_timestamp < '2025-01-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-12-01' and block_timestamp < '2025-01-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-12-01' and block_timestamp < '2025-01-01' and TX_TYPE ilike '%user%' group by 1 UNION all select trunc(block_timestamp,'day') as daily , 'arbitrum' as blockchain, count(DISTINCT from_address) as active_addresses from arbitrum.core.fact_transactions where block_timestamp::date >= '2024-12-01' and block_timestamp < '2025-01-01' group by 1 UNION all select trunc(block_timestamp,'day') as daily , 'blast' as blockchain, count(DISTINCT from_address) as active_addresses from blast.core.fact_transactions where block_timestamp::date >= '2024-12-01' and block_timestamp < '2025-01-01' group by 1 UNION all select trunc(block_timestamp,'day') as daily , 'sei' as blockchain, count(DISTINCT tx_from) as active_addresses from sei.core.fact_transactions where block_timestamp::date >= '2024-12-01' and block_timestamp < '2025-01-01' group by 1 UNION all select trunc(block_timestamp,'day') as daily , 'avalanche' as blockchain, count(DISTINCT from_address) as active_addresses from avalanche.core.fact_transactions where block_timestamp::date >= '2024-12-01' and block_timestamp < '2025-01-01' group by 1 UNION all select trunc(block_timestamp,'day') as daily , 'optimism' as blockchain, count(DISTINCT from_address) as active_addresses from optimism.core.fact_transactions where block_timestamp::date >= '2024-12-01' and block_timestamp < '2025-01-01' group by 1 UNION all select trunc(block_timestamp,'day') as daily , 'polygon' as blockchain, count(DISTINCT from_address) as active_addresses from polygon.core.fact_transactions where block_timestamp::date >= '2024-12-01' and block_timestamp < '2025-01-01' group by 1 UNION all select trunc(block_timestamp,'day') as daily , 'thorchain' as blockchain, count(DISTINCT from_address) as active_addresses from tb0 where block_timestamp::date >= '2024-12-01' and block_timestamp < '2025-01-01' group by 1 UNION all select trunc(block_timestamp,'day') as daily , 'kaia' as blockchain, count(DISTINCT from_address) as active_addresses from kaia.core.fact_transactions where block_timestamp::date >= '2024-12-01' and block_timestamp < '2025-01-01' and tx_succeeded = 'TRUE' group by 1 , 2 UNION all select trunc(block_timestamp,'day') as daily , 'near' as blockchain, count(DISTINCT user) as active_addresses from tb0_0 where block_timestamp::Date >= '2024-12-01' and block_timestamp < '2025-01-01' group by 1,2 UNION all select trunc(block_timestamp,'day') as daily , 'solana' as blockchain, count(DISTINCT SIGNERS[0]) as active_addresses from solana.core.fact_events where block_timestamp::Date >= '2024-12-01' and block_timestamp < '2025-01-01' and SUCCEEDED = 'TRUE' group by 1,2 order by 1 asc

Masi