/*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