coalesce(pool_name,contract_address) as "Pool",

contract_address as "Pool Address",

count(distinct tx_hash) as "Swap Transactions",

count(*) as "Swaps",

count(distinct ORIGIN_FROM_ADDRESS) as "Swappers",

sum(AMOUNT_OUT) as "Token Volume",

sum(AMOUNT_OUT_USD) as "USD Volume"

from base.defi.ez_dex_swaps

where block_timestamp >= '{{Start_Date}}'

and block_timestamp <= '{{End_Date}}'

group by 1,2

order by 3 desc