select
BLOCK_TIMESTAMP,
TX_HASH,
AMOUNT_OUT_USD-AMOUNT_IN_USD as profit
from arbitrum.core.ez_dex_swaps
where AMOUNT_OUT_USD>AMOUNT_IN_USD
and AMOUNT_OUT_USD is not NULL
and AMOUNT_IN_USD is not NULL
and BLOCK_TIMESTAMP >='2023-07-27'
order by 3 desc
limit 100