shadilSwapping goBTC and goETH on DEXs - goETH
    Updated 2022-05-18
    -- 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
    Run a query to Download Data