Query editor
SELECT COUNT(DISTINCT tt.tx_hash) as swaps, SUM(usd_amount) as volumeFROM(SELECT block_time, tx_hash,CASEWHEN "to" IN ('\x11111112542d85b3ef69ae05771c2dccff4faa26', '\x1111111254fb6c44bac0bed2854e76f90643097d') THEN '1inch'WHEN "to" IN ('\xdef1c0ded9bec7f1a1670819833240f027b25eff', '\x080bf510fcbf18b91105470639e9561022937712') THEN '0x'WHEN "to" IN ('\xDEF171Fe48CF0115B1d80b88dc8eAB59176FEe57', '\x1bD435F3C054b6e901B7b108a0ab7617C808677b') THEN 'Paraswap'WHEN "to" IN ('\xc549a5c701cb6e6cbc091007a80c089c49595468','\x522d6f36c95a1b6509a14272c17747bbb582f2a6') THEN 'Airswap'ELSE 'unidentified'END AS projectFROM ethereum."traces" etWHERE "from" = '\x74de5d4fcbf63e00296fd95d33236b9794016631' AND block_time > now() - interval '3 days' AND"to" IN ('\x11111112542d85b3ef69ae05771c2dccff4faa26', --1inch V3'\x1111111254fb6c44bac0bed2854e76f90643097d', --1inch V4'\xdef1c0ded9bec7f1a1670819833240f027b25eff', --0x: Exchange Proxy'\x080bf510fcbf18b91105470639e9561022937712', --0x: Exchange v2.1'\xDEF171Fe48CF0115B1d80b88dc8eAB59176FEe57', --Paraswap v5'\x1bD435F3C054b6e901B7b108a0ab7617C808677b', --ParaSwap P4'\xc549a5c701cb6e6cbc091007a80c089c49595468', --Airswap'\x522d6f36c95a1b6509a14272c17747bbb582f2a6') --Airswap) ttLEFT JOIN dex.trades dt ON dt.tx_hash = tt.tx_hash AND dt.project IN ('1inch', 'Paraswap', '0x API', '0x Native', 'airswap')--GROUP BY 1ORDER BY volume DESC