EVENT_NAME,

COUNT(*) AS "Number of Swaps",

AVG(AMOUNT_IN_USD) AS "Average Amount In (USD)",

AVG(AMOUNT_OUT_USD) AS "Average Amount Out (USD)",

MIN(AMOUNT_IN_USD) AS "Minimum Amount In (USD)",

MAX(AMOUNT_IN_USD) AS "Maximum Amount In (USD)",

MIN(AMOUNT_OUT_USD) AS "Minimum Amount Out (USD)",

MAX(AMOUNT_OUT_USD) AS "Maximum Amount Out (USD)"

bsc.defi.ez_dex_swaps

WHERE 1=1

AND platform like '%pancake%'

AND Date_part(year, block_timestamp) = 2024

GROUP BY

EVENT_NAME

ORDER BY

"Number of Swaps" DESC;

LIMIT 1000