SELECT

date_trunc(week, block_timestamp) AS week

, CASE WHEN platform ILIKE '%aerodrome%' THEN 'aerodrome'

WHEN platform ILIKE '%uniswap%' THEN 'uniswap'

ELSE platform END AS d_platform

, SUM((amount_in_usd+amount_out_usd)/2) AS volume

, SUM(volume) OVER (ORDER BY week) AS Cummulative_volume

, Count(DISTINCT tx_hash) AS Txs

, SUM(txs) OVER (ORDER BY week) AS Cummulative_txs

, COUNT(DISTINCT origin_from_address) AS users

FROM base.defi.ez_dex_swaps

WHERE 1=1

AND (token_in = lower('0x0d97F261b1e88845184f678e2d1e7a98D9FD38dE')

OR token_out = lower('0x0d97F261b1e88845184f678e2d1e7a98D9FD38dE'))

AND amount_in_usd > 0

AND amount_out_usd > 0

GROUP BY 1, 2

ORDER BY 1 DESC

*

, (SELECT COUNT(DISTINCT origin_from_address)

FROM base.defi.ez_dex_swaps

WHERE (token_in = lower('0x0d97F261b1e88845184f678e2d1e7a98D9FD38dE')

OR token_out = lower('0x0d97F261b1e88845184f678e2d1e7a98D9FD38dE'))

AND amount_in_usd > 0

AND amount_out_usd > 0

) AS Total_swappers

FROM weekly

ORDER BY

week DESC