princefarzamComparison between Swap volume of USDC, USDT, and STBL(SWAP TO AMOUNT)
    Updated 2022-04-07
    WITH USDC AS (
    SELECT
    date_trunc('day',BLOCK_TIMESTAMP) AS DAY,
    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
    GROUP BY 1
    ORDER BY 1 ASC),
    USDT AS (
    SELECT
    date_trunc('day',BLOCK_TIMESTAMP) AS DAY,
    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
    GROUP BY 1
    ORDER BY 1 ASC),
    STBL AS (
    SELECT
    date_trunc('day',BLOCK_TIMESTAMP) AS DAY,
    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
    GROUP BY 1
    ORDER BY 1 ASC)
    SELECT
    A.DAY,
    A.USDC_SWAP_TO_AMOUNT AS USDC_volume,
    B.USDT_SWAP_TO_AMOUNT AS USDT_volume,
    C.STBL_SWAP_TO_AMOUNT AS STBL_volume
    FROM USDC A INNER JOIN USDT B on A.DAY=B.DAY
    INNER JOIN STBL C on A.DAY=C.DAY
    Run a query to Download Data