AlishSwapping goBTC and goETH on DEXs: 1-Users and Volume
    Updated 2022-05-18
    /*goETH and goBTC are wrapped forms of ETH and BTC minted by algoMint.
    Let's look at goBTC and goETH swaps across the DEXs since the beginning of April and get a better understanding of how wallets are swapping goETH and goBTC
    - especially during the price crash in May.*/

    SELECT
    date_trunc('day',BLOCK_TIMESTAMP) as date, SWAP_PROGRAM as dex,
    sum(SWAP_FROM_AMOUNT) volume, COUNT(DISTINCT(SWAPPER)) as unique_users
    --sum(SWAP_TO_ASSET_ID) asset
    FROM flipside_prod_db.algorand.swaps
    WHERE SWAP_FROM_ASSET_ID=386192725
    or SWAP_FROM_ASSET_ID=386195940
    AND date>='2022-01-01'
    GROUP by 1,2
    ORDER by 1 ASC

    Run a query to Download Data