count (DISTINCT ORIGIN_FROM_ADDRESS) as wallets,

count(DISTINCT tx_hash) as trxs,

sum(AMOUNT_IN_USD) as volume_usd,

avg(AMOUNT_IN_USD) as avg_volume

from ethereum.core.ez_dex_swaps

where PLATFORM='uniswap-v3'

and CONTRACT_ADDRESS='0x99ac8ca7087fa4a2a1fb6357269965a2014abc35'

and BLOCK_TIMESTAMP >= current_date - {{days_ago}}