count(*) AS "Swap Count",

sum(swap_from_amount) as "Swap Volume",

a.asset_name

FROM flipside_prod_db.algorand.swaps s

INNER JOIN flipside_prod_db.algorand.asset a ON a.asset_id = s.swap_from_asset_id

WHERE block_timestamp::date >= '2022-05-11'

AND block_timestamp::date <= '2022-05-12'

GROUP BY a.asset_name

ORDER BY 1 DESC

LIMIT 10