princefarzamThe total number of USDC,USDT, and STBL swaps since Mar.
    Updated 2022-04-07
    WITH USDC AS (
    SELECT
    COUNT(DISTINCT TX_GROUP_ID) AS Number_of_USDC_swaps
    FROM algorand.swaps
    WHERE BLOCK_TIMESTAMP::DATE >='2022-03-01'
    AND SWAP_FROM_ASSET_ID=31566704
    ),
    USDT AS (
    SELECT
    COUNT(DISTINCT TX_GROUP_ID) AS Number_of_USDT_swaps
    FROM algorand.swaps
    WHERE BLOCK_TIMESTAMP::DATE >='2022-03-01'
    AND SWAP_FROM_ASSET_ID=312769
    ),
    STBL AS (
    SELECT
    COUNT(DISTINCT TX_GROUP_ID) AS Number_of_STBL_swaps
    FROM algorand.swaps
    WHERE BLOCK_TIMESTAMP::DATE >='2022-03-01'
    AND SWAP_FROM_ASSET_ID=465865291
    )
    SELECT 'The total number of USDC swaps' as type, Number_of_USDC_swaps FROM USDC
    UNION ALL
    SELECT 'The total number of STBL swaps' as type, Number_of_STBL_swaps FROM STBL
    UNION ALL
    SELECT 'The total number of USDT swaps' as type, Number_of_USDT_swaps FROM USDT
    Run a query to Download Data