( SELECT

date_trunc('day', a.block_timestamp) AS Date,

SUM(b.tx_fee) AS arb_gas_paid,

COUNT(DISTINCT b.from_address) AS arb_users

FROM arbitrum.defi.ez_dex_swaps a

LEFT JOIN arbitrum.core.fact_transactions b

ON b.from_address = a.origin_from_address

AND a.block_timestamp = b.block_timestamp

AND a.block_timestamp >= DATEADD(day, -60, CURRENT_DATE)

AND a.platform = 'uniswap-v3'

GROUP BY 1

),

optimism AS

( SELECT

date_trunc('day', a.block_timestamp) AS Date,

SUM(b.tx_fee) AS opt_gas_paid,

COUNT(DISTINCT b.from_address) AS opt_users

FROM optimism.defi.ez_dex_swaps a

LEFT JOIN optimism.core.fact_transactions b

ON b.from_address = a.origin_from_address

AND a.block_timestamp = b.block_timestamp

AND a.block_timestamp >= DATEADD(day, -60, CURRENT_DATE) -- Moved condition to the ON clause

AND a.platform = 'uniswap-v3' -- Keep this condition in the ON clause

GROUP BY 1

),

base AS

( SELECT

date_trunc('day', a.block_timestamp) AS Date,

SUM(b.tx_fee) AS base_gas_paid,

COUNT(DISTINCT b.from_address) AS base_users

FROM base.defi.ez_dex_swaps a

LEFT JOIN base.core.fact_transactions b

ON b.from_address = a.origin_from_address