-- Arbitrum Blockchain daily active users

SELECT

DATE_TRUNC('week', block_timestamp) AS TimeLine,

COUNT(DISTINCT origin_from_address) AS ActiveUsers,

'Arbitrum' AS Blockchain

FROM arbitrum.defi.ez_dex_swaps

WHERE symbol_in = 'USDC'

OR symbol_out = 'USDC'

GROUP BY TimeLine

UNION ALL

-- Base Blockchain daily active users

SELECT

DATE_TRUNC('week', block_timestamp) AS TimeLine,

COUNT(DISTINCT origin_from_address) AS ActiveUsers,

'Base' AS Blockchain

FROM base.defi.ez_dex_swaps

WHERE symbol_in = 'USDC'

OR symbol_out = 'USDC'

GROUP BY TimeLine

UNION ALL

-- Solana Blockchain daily active users

SELECT

DATE_TRUNC('week', block_timestamp) AS TimeLine,

COUNT(DISTINCT swapper) AS ActiveUsers,

'Solana' AS Blockchain

FROM solana.defi.ez_dex_swaps

WHERE swap_from_symbol = 'USDC'

OR swap_from_symbol = 'USDC'

GROUP BY TimeLine