princefarzamNumber of transactions for USDT vs. USDC
    Updated 2022-02-11
    WITH USDT_TX AS (
    SELECT
    date_trunc('day',block_timestamp) AS day,
    COUNT(DISTINCT tx_id) AS USDT_TRANSACTIONS
    FROM algorand.asset_transfer_transaction
    WHERE asset_id = 312769
    AND day::date >= '2021-09-01' --since september
    GROUP BY day
    ORDER BY day ASC
    ),
    USDC_TX AS (
    SELECT
    date_trunc('day',block_timestamp) AS day,
    COUNT(DISTINCT tx_id) AS USDC_TRANSACTIONS
    FROM algorand.asset_transfer_transaction
    WHERE asset_id = 31566704
    AND day::date >= '2021-09-01' --since september
    GROUP BY day
    ORDER BY day ASC
    )
    SELECT
    USDT.day AS DAY,
    USDT.USDT_TRANSACTIONS AS NUMBER_OF_USDT_TRANSACTIONS,
    USDC.USDC_TRANSACTIONS AS NUMBER_OF_USDC_TRANSACTIONS
    FROM USDT_TX USDT FULL OUTER JOIN USDC_TX USDC ON USDT.day= USDC.day

    Run a query to Download Data