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,

date(BLOCK_TIMESTAMP) as date,

TX_HASH,

ORIGIN_FROM_ADDRESS as swapper,

CONTRACT_ADDRESS as pool_address,

POOL_NAME,

AMOUNT_IN,

AMOUNT_IN_USD,

AMOUNT_OUT,

AMOUNT_OUT_USD,

TOKEN_IN,

SYMBOL_IN,

TOKEN_OUT,

SYMBOL_OUT

from base.defi.ez_dex_swaps

where block_timestamp >= '{{Start_Date}}'

and block_timestamp <= '{{End_Date}}'

having dex = '{{DEX}}'

order by block_timestamp)

select

coalesce(pool_name,pool_address) as "Pool",

pool_address as "Pool Address",

count(distinct tx_hash) as "Swap Transactions",

count(*) as "Swaps",