princefarzamThe total volume of swapping USDC, USDT, and STBL in percent since Mar.(swap to amount)
    Updated 2022-04-07
    WITH USDC AS (
    SELECT
    sum(SWAP_TO_AMOUNT) AS USDC_SWAP_TO_AMOUNT
    FROM algorand.swaps
    WHERE BLOCK_TIMESTAMP::DATE >='2022-03-01'
    AND SWAP_TO_ASSET_ID=31566704
    ),
    USDT AS (
    SELECT
    sum(SWAP_TO_AMOUNT) AS USDT_SWAP_TO_AMOUNT
    FROM algorand.swaps
    WHERE BLOCK_TIMESTAMP::DATE >='2022-03-01'
    AND SWAP_TO_ASSET_ID=312769
    ),
    STBL AS (
    SELECT
    sum(SWAP_TO_AMOUNT) AS STBL_SWAP_TO_AMOUNT
    FROM algorand.swaps
    WHERE BLOCK_TIMESTAMP::DATE >='2022-03-01'
    AND SWAP_TO_ASSET_ID=465865291
    )
    SELECT 'The total volume of swap USDC' as type, USDC_SWAP_TO_AMOUNT FROM USDC
    UNION ALL
    SELECT 'The total volume of swap STBL' as type, STBL_SWAP_TO_AMOUNT FROM STBL
    UNION ALL
    SELECT 'The total volume of swap USDT' as type, USDT_SWAP_TO_AMOUNT FROM USDT
    Run a query to Download Data