SELECT DISTINCT from_address as address

FROM berachain.testnet.fact_transactions

),

daily_dex_stats AS (

SELECT

s.blockchain,

COUNT(DISTINCT s.tx_hash) as daily_swaps,

COUNT(DISTINCT s.trader) as unique_traders,

SUM(COALESCE(s.amount_in_usd, 0)) as daily_volume_usd

FROM bera_users b

JOIN crosschain.defi.ez_dex_swaps s

ON LOWER(b.address) = LOWER(s.trader)

AND s.block_timestamp >= DATEADD(day, -30, CURRENT_DATE)

GROUP BY 1

ORDER BY 1

SELECT *

FROM daily_dex_stats;