block_timestamp,

platform,

tx_hash,

ORIGIN_FROM_ADDRESS as swapper,

symbol_in,

symbol_out,

amount_in_usd,

amount_out_usd,

nvl(amount_in_usd, amount_out_usd) as amount_usd

from kaia.defi.ez_dex_swaps

WHERE platform ilike 'klayswap%'

SELECT

count(DISTINCT tx_hash) as n_swaps,

count(DISTINCT swapper) as unique_swapper,

sum(amount_usd) as volume,

volume/n_swaps as avg_vol_per_swap,

volume/unique_swapper as avg_vol_per_swappper,

FROM swapEvent