count(distinct tx_hash) as transactions,

count(distinct liquidity_provider) as liquidity_providers,

sum(nvl(amount0_usd, 0) + nvl(amount1_usd, 0)) as volume_usd,

avg(nvl(amount0_usd, 0) + nvl(amount1_usd, 0)) as average_volume_usd,

median(nvl(amount0_usd, 0) + nvl(amount1_usd, 0)) as median_volume_usd

from ethereum.uniswapv3.ez_lp_actions

where nvl(amount0_usd, 0) + nvl(amount1_usd, 0) < 10e8