-- Tips: goETH asset_id = 386195940 goBTC asset_id = 386192725
SELECT SWAP_PROGRAM, sum(SWAP_TO_AMOUNT) as vol, 'goETH' as asset,
COUNT(DISTINCT swapper) as swappers,
'buy' as type
from flipside_prod_db.algorand.swaps
where SWAP_TO_ASSET_ID = 386195940
GROUP by asset, SWAP_PROGRAM
UNION
SELECT SWAP_PROGRAM, sum(SWAP_FROM_AMOUNT) as vol, 'goETH' as asset,
COUNT(DISTINCT swapper) as swappers,
'sell' as type
from flipside_prod_db.algorand.swaps
where SWAP_FROM_ASSET_ID = 386195940
GROUP by asset, SWAP_PROGRAM