swaps as (

select

*,

case

when amount0_adjusted > 0 then '$wBTC to $USDC'

when amount0_adjusted < 0 then '$USDC to $wBTC'

else null

end as swap_direction

from

ethereum.uniswapv3.ez_swaps

where

pool_address = '0x99ac8ca7087fa4a2a1fb6357269965a2014abc35'

and date(block_timestamp) >= current_date - 31 and amount0_adjusted > 0

order by

block_timestamp desc

)

date_trunc('day', block_timestamp) as dt,

swap_direction,

count(distinct tx_hash) as swap_tx,

count(distinct sender) as address_count,

sum(abs(amount0_adjusted)) as volume_btc,

sum(abs(amount1_adjusted)) as volume_usdc

from swaps

group by 1,2