SYMBOL_IN || ' => ' || 'BTC' as pair

, count(DISTINCT tx_hash) as swapped_cnt

, count(DISTINCT SENDER) as trader_cnt

, sum(iff(SYMBOL_IN in ('WBTC'), AMOUNT_IN, AMOUNT_OUT)) as swapped_volume_btc

, sum(iff(SYMBOL_IN in ('WBTC'), AMOUNT_IN_USD, AMOUNT_OUT_USD)) as swapped_volume_usd

from ethereum.core.sv_ez_dex_swaps

where SYMBOL_OUT in ('WBTC')

and BLOCK_TIMESTAMP > '2023-03-10'

and BLOCK_TIMESTAMP < '2023-03-12'

group by 1

ORDER by 4 DESC

limit 10