lagandispenserUntitled Query
    Updated 2022-07-12
    -- https://coincodex.com/cryptocurrencies/sector/stablecoins/
    WITH
    STABLECOIN_IN AS (
    SELECT
    -- POOL_NAME, PLATFORM ,
    SYMBOL_IN ,
    COUNT (DISTINCT (TX_HASH)) AS SWAP_NUM_IN ,
    COUNT (DISTINCT (POOL_NAME)) AS POOL_NUM_IN ,
    SUM(AMOUNT_IN_USD) AS VOLUME_IN
    FROM flipside_prod_db.ethereum_core.ez_dex_swaps --ethereum.dex_swaps
    WHERE PLATFORM = 'sushiswap'
    AND AMOUNT_IN_USD IS NOT NULL
    AND ( SYMBOL_IN LIKE '%USD%'
    OR SYMBOL_IN IN ( 'DAI' , 'FRAX' , 'UST' ,'FEI' , 'VAI', 'EURS' ) )
    -- (USDT, USDC, BUSD, DAI, FRAX, TUSD, USDP, UST , USDN , USDK , LUSD , FEI, HUSD, GUSD, sUSD , VAI , EURS )
    GROUP BY 1 -- , 2 , 3
    HAVING VOLUME_IN >= 3E6
    ORDER BY VOLUME_IN DESC
    LIMIT 13 )
    ,
    STABLECOIN_OUT AS (
    SELECT
    SYMBOL_OUT ,
    COUNT (DISTINCT (TX_HASH)) AS SWAP_NUM_OUT,
    COUNT (DISTINCT (POOL_NAME)) AS POOL_NUM_OUT ,
    SUM(AMOUNT_OUT_USD) AS VOLUME_OUT
    FROM flipside_prod_db.ethereum_core.ez_dex_swaps
    WHERE PLATFORM = 'sushiswap'
    AND AMOUNT_OUT_USD IS NOT NULL
    AND ( SYMBOL_OUT LIKE '%USD%'
    OR SYMBOL_OUT IN ( 'DAI' ,'FRAX' , 'UST' ,'FEI' , 'VAI', 'EURS' ) )
    GROUP BY 1
    Run a query to Download Data