SELECT

Block_timestamp,

Tx_hash,

Symbol_In,

Symbol_Out,

Origin_From_Address,

Amount_In_USD

FROM

base.defi.ez_dex_swaps

WHERE

platform = 'dackieswap'

SELECT

CONCAT(Symbol_In, '/', Symbol_Out) AS Token_Pair, -- Concatenates Symbol_In and Symbol_Out as a pair

COUNT( DISTINCT tx_hash) AS Paired_Count,

SUM(Amount_In_USD) AS Total_Swapped_Amount

FROM

Dackieswap

WHERE

Amount_In_USD IS NOT NULL

GROUP BY

Symbol_In, Symbol_Out

ORDER BY

Paired_Count DESC

LIMIT 20;