select

count(distinct tx_hash) as swap_txs,

count(*) as swaps,

count(distinct ORIGIN_FROM_ADDRESS) as Swappers,

sum(coalesce(AMOUNT_OUT_USD , AMOUNT_IN_USD)) as volume

from base.defi.ez_dex_swaps

where block_timestamp >= '{{Start_Date}}'

and block_timestamp <= '{{End_Date}}'),

dexs as (

select

case

when platform = 'balancer' then 'Balancer'

when platform = 'baseswap' then 'BaseSwap'

when platform = 'dackieswap' then 'DackieSwap'

when platform = 'maverick' then 'Maverick'

when platform = 'sushiswap' then 'SushiSwap'

when platform = 'swapbased' then 'SwapBased'

when platform = 'uniswap-v3' then 'UniSwap'

when platform = 'woofi' then 'WooFi'

end as "DEX",

count(distinct tx_hash) as "Swap Transactions",

count(*) as "Swaps",

count(distinct ORIGIN_FROM_ADDRESS) as "Swapper",

count(distinct block_timestamp::date) as "Activity Days",

sum(coalesce(AMOUNT_OUT_USD , AMOUNT_IN_USD)) as "USD Volume",

count(distinct TOKEN_IN) as "From Tokens",

count(distinct TOKEN_OUT) as "To Tokens",

count(distinct CONTRACT_ADDRESS) as "Pools"

from base.defi.ez_dex_swaps

where block_timestamp >= '{{Start_Date}}'

and block_timestamp <= '{{End_Date}}'

group by 1

order by 2 desc)