Date_trunc('day', Block_timestamp) AS Date,

COUNT(DISTINCT TX_HASH) AS Total_Swaps,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as Total_Swappers,

SUM(AMOUNT_USD) as Total_Traded_volume,

FROM ronin.core.ez_token_transfers

WHERE ORIGIN_TO_ADDRESS in ('0x5f0acdd3ec767514ff1bf7e79949640bf94576bd')

AND ORIGIN_FUNCTION_SIGNATURE='0x3593564c'

AND SYMBOL='Ronke'

AND BLOCK_TIMESTAMP::date >= '2025-02-22'

GROUP BY 1