DATE_TRUNC('week', block_timestamp) AS transaction_week,

COUNT(DISTINCT origin_from_address) AS unique_senders,

COUNT(*) AS swap_count,

SUM(

IFNULL(amount_out_usd, 0) + IFNULL(amount_in_usd, 0)

) / 2 AS total_swap_value_usd,

COUNT(DISTINCT contract_address) AS distinct_liquidity_pools

base.defi.ez_dex_swaps

block_timestamp >= '2024-01-01'

GROUP BY

DATE_TRUNC('week', block_timestamp)

ORDER BY

transaction_week;