( SELECT

Date,

COUNT(DISTINCT address) AS no_arb_address,

SUM(Transaction_Volume) AS arb_transaction_volume,

SUM(Transaction_Count) AS arb_transaction_Count,

SUM(token_balance) AS arb_token_balance

FROM (

SELECT

date_trunc('day', block_timestamp) AS Date,

origin_from_address AS address,

amount_in_usd AS Transaction_Volume,

1 AS Transaction_Count,

COALESCE(amount_in_usd, 0) - COALESCE(amount_out_usd, 0) AS token_balance

FROM arbitrum.defi.ez_dex_swaps

WHERE platform = 'uniswap-v3'

UNION ALL

SELECT

date_trunc('day', block_timestamp) AS Date,

origin_to_address AS address,

amount_out_usd AS Transaction_Volume,

1 AS Transaction_Count,

COALESCE(amount_in_usd, 0) - COALESCE(amount_out_usd, 0) AS token_balance

FROM arbitrum.defi.ez_dex_swaps

WHERE platform = 'uniswap-v3'

) AS combined_data

GROUP BY 1),

optimism AS

( SELECT

Date,

COUNT(DISTINCT address) AS no_opt_address,

SUM(Transaction_Volume) AS opt_transaction_volume,

SUM(Transaction_Count) AS opt_transaction_Count,