date(block_timestamp) as days,

count(DISTINCT tx_hash) as swaps,

count(DISTINCT ORIGIN_FROM_ADDRESS) as swappers

FROM arbitrum.core.fact_event_logs

WHERE tx_hash IN (

SELECT DISTINCT tx_hash

FROM arbitrum.core.fact_event_logs

WHERE event_name LIKE 'Swap'

AND event_name LIKE 'Transfer'

GROUP by 1

ORDER BY 1