'WBTC => USDC' as dir,

date_trunc('day', block_timestamp) as date,

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 SYMBOL_IN='WBTC'

and BLOCK_TIMESTAMP >= current_date - {{days_ago}}

group by date

select

'USDC => WBTC' as dir,

date_trunc('day', block_timestamp) as date,

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 SYMBOL_IN='USDC'

and BLOCK_TIMESTAMP >= current_date - {{days_ago}}

group by date